LMP - e-report 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 e-report to it's database using an ODBC DSN

If an e-report client is unable to communicate with a database on startup then the user is presented with the option to 'Retry'. If this is selected, e-report'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 e-report to use that named connection. Clearing the ODBC DSN box will cause e-report to revert to a DSNless connection.

Typical e-report ODBC DSN settings...

	Name is the unique title that this connection will be known as. The default is EReport2, 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 e-report database. If it is this machine, then (local) can be used instead of the real name.

Login Type is how the e-report database knows that you have permission to access it. The standard method for e-report 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 e-report should be set to erep
Password for e-report should be set to erep

	Default Database is the database to connect to on the server. The default is Erep2, 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