ODBC and BDE Configuration
Open Database Connectivity (ODBC) drivers must be installed before some programs can run.
This is based on Ying Tang's original documentation at Smathersnt4\Systems\Applications\DLC\DelphiApps_Config.DOC.
Note: spelling counts. Trust me.
ODBC configuration for DLC Production
You need this one for the Tracking Database and the FileSort CD lister.
- Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).
- Select the System DSN tab: if SQLSRVR4 exists, proceed down to "Configure the Delphi BDE".
- Otherwise, click on Add.
- Select SQL Server then Finish.
- For What name: enter SQLSRVR4.
- For Which SQL Server: select SMATHERSNT4 from the drop-down.
- Accept the rest of the defaults, except under Change the default database, select DLCProduction.
- Select Next, Finish, Test Data Source, OK, OK, OK.
ODBC configuration for Filmlog
You need this one for access to Reprosaurus.
- Select Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC).
- Select the System DSN tab: if SQL Server exists, proceed to the next part below: Configure the Delphi BDE.
- Otherwise, click on Add.
- Select SQL Server then Finish.
- For Name: enter SQLFilmlog.
- For Which SQL Server: select SMATHERSNT4 from the drop-down.
- Accept the rest of the defaults, except under Change the default database, select FilmLog.
- Select Next, Finish, Test Data Source, OK, OK, OK.
Configure the Delphi BDE (Borland Database Engine)
- If the BDE Administrator has been installed, run it from C:\Program Files\Common Files\Borland Shared\BDE\BDEADMIN.EXE.
- If it has not been installed, run the setup.exe file at Smathersnt4\systems\applications\Library-Wide\BDE5 2000 install\144MB\disk1.
- Now run BDE Administrator.
- Under the Databases tab, right click Databases then select New.
- Select SQL Server for the new database alias, then OK.
- It will display a new databse on the list, with a default name highlighted.
- Replace that name (probably ODBC1) with NTDLCProduction and hit Enter. This is its alias.
- In the right-hand pane, under DATABASE NAME enter DLCProduction (omitting the initial "NT"). This is the true name.
- Further down, under ODBC DSN enter SQLSRVR4.
- Right click the alias name on the left, and select Apply then OK.
- Right click again and select Open.
- Just click OK to the password prompt.
- A green box should appear around the alias.
- Right click again and select Close.
- For a second time, right click Databases then select New.
- Follow the routine exactly as before, but this time the alias name is NTDLCProd instead of NTDLCProduction. All the other facts (DATABASE NAME: DLCProduction, ODBC DSN: SQLSRVR4) remain the same.
- After the second Apply, Open and Close, exit the program.
