Can anyone help me find an answer to this ODBC problem ?
In a Visual Basic application, I am trying to find out the database name of a Data Source. I have an ODBC data source which points to an MS Access 2000 database. In the ODBC administrator, if you click on a DSN, and then click the Configure button, a dialog is displayed and the current physical database path (i.e.; C:\Data\MyDataBase.mdb) is displayed. I need to know the physical database name given that I know the data source name. Inside my Visual Basic application, I call SQLDataSources to get the data source names on my machine, but this does not provide the Physical Database associated with this data source. Somehow, the ODBC administrator knows the physical name, but I can?t figure out how to get this information.
I thought I should use SQLGetInfo using the SQL_DATABASE_NAME InfoType, but cannot get this to work. My intention is to eventually use SQLConfigDataSource to change a physical mapping for a data source to a new physical databa
