LMP - Train application notes - ODBC DSN Connections

LMP Technical Services Limited
Consulting Engineers & Specialists in Software for Statutory Plant

Telephone Number UK: 01933 683810
Fax Number UK: 01933 683819

Linking Train to it's database using an ODBC DSN

If an Train client is unable to communicate with a database on startup then the user is presented with the option to 'Retry'. If this is selected, Train's ODBC config screen is diplayed to permit the user to add or modify a link to the database.

Selecting an existing entry on the list will copy the name to the top box entitled ODBC DSN and configure Train to use that named connection. Clearing the ODBC DSN box will cause Train to revert to a DSNless connection.

Typical Train ODBC DSN settings...

	Name is the unique title that this connection will be known as. The default is Train2, but can be changed by the user.
	Description is anything the user wishes to type in to remind themselves what this connection is used for.
	Server is the name of the PC that is running the Train database. If it is this machine, then (local) can be used instead of the real name.

Login Type is how the Train database knows that you have permission to access it. The standard method for Train is SQL Authentication, although NT authentication can be used if talking to SQL Server Ver.7 or Ver.2000
Client Configuration this is the network protocol used to communicate with the database server. If your database server is running Windows 95 or Windows 98, then this must be set to TCP/IP. If communicating with an NT box, then Named Pipes or TCP/IP can be used.
Login ID for Train should be set to train
Password for Train should be set to train

	Default Database is the database to connect to on the server. The default is Train2, but can be changed by the user at creation time.
	All other parameters can be left in their default settings.

All parameters can be left in their default settings.

Home Page