ODBC Examinedatabase returns unexpected results

[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)

[Fred]

Yes, it's may be badly named, but drivers are DSN, which is the important info to connect to an ODBC database