Page 1 of 1

ODBC Examinedatabase returns unexpected results

Posted: Tue Sep 11, 2018 11:09 am
by Poltergeist
Hi,

I would like to find out which ODBC drivers are installed on my system. That should be an easy task, using the following code:

Code: Select all

UseODBCDatabase()
If ExamineDatabaseDrivers()
  While NextDatabaseDriver()
    Debug DatabaseDriverName()+":"+DatabaseDriverDescription()
  Wend
EndIf
However, this does not return the drivers, but the Data source names. DatabaseDriverName returns the name of the DSN, while DatabaseDriverDescription returns the driver which is used for the DSN. Is this the correct behaviour? Because, if so, I have to find another way to list the drivers

(using PB 5.62, 32bits)

Re: ODBC Examinedatabase returns unexpected results

Posted: Tue Sep 11, 2018 3:10 pm
by Fred
Yes, it's may be badly named, but drivers are DSN, which is the important info to connect to an ODBC database