i`am using PB 5.73 amd64 on Debian Bullseye and have a Problem with ODBC MySQL and Oracle Databases.
I think my unixodbc is installed correctly because it is posible to connect to the Databases via isql.
Exampl: isql DB USER PASSWORD let me execute SQL commands.
But if i try:
Code: Select all
UseODBCDatabase()
#db_mysql1=1
Debug OpenDatabase(#db_mysql1,"DB","USER","PASSWORD",#PB_Database_ODBC)
Debug DatabaseError()
sql.s="show databases;"
DatabaseQuery(#db_mysql1,sql)
Debug DatabaseError()
While NextDatabaseRow(#db_mysql1)
Debug GetDatabaseString(#db_mysql1,0)
Wend
It is posible to connect to PostgreSQL with UsePostgreSQLDatabase().
I think this is some sort of a Debian Bullseye problem..
unixodbc is installed in version 2.3.6-0.1+b1
Any Ideas?