Anyone with some sample code on this function? I have looked everywhere and cannot find anything that is MS-Access specific.
Background
I have an application where I want the user to be prompted to select an ODBC Data Source. I would like to then call this function to get some information about the ODBC driver so I can make RDBMS specific SQL calls.
I have used the connect connection property (see below) in the past but it does not give me enough information.
Background
I have an application where I want the user to be prompted to select an ODBC Data Source. I would like to then call this function to get some information about the ODBC driver so I can make RDBMS specific SQL calls.
I have used the connect connection property (see below) in the past but it does not give me enough information.
Code:
Dim wrkODBC As Workspace
Dim conPubs As Connection
' Create ODBCDirect Workspace object.
Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
Set conPubs = wrkODBC.OpenConnection("DBConnection", dbDriverPrompt, True, "ODBC;DSN=;UID=;PWD=")