odbc_databaseGetConnectionString()

Synopsis

Returns a concatenated connection string that may include a data source name, a user ID valid on the data source, a user authentication string (password, if the data source requires one), and other information.

Syntax

odbc_databaseGetConnectionString ( db_pointer As User ) As String

Argument	Type	Description
db_pointer	user	Database reference. This reference should be obtained with the previous call to odbc_databaseOpen

Example 1

Obtain connection string as seen by ODBC driver

 Dim db As User = odbc_databaseOpen( "ODBC;DSN=PEFRESULTS") 
Dim connString As String = odbc_databaseGetConnectionString(db)
odbc_databaseClose( db)
Return connString

--> "ODBC;DSN=PEFRESULTS;DBQ=C:\My Documents\TestDatabase.accdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;"