My Linux Xojo Web app can not talk to Firebird over ODBC.
For edge SQL cases I recommend the MBS SQL plugin. I generally use the Xojo (or vendor provided) database plugins when available but MBS SQL has some unique advantages. Firebird is on the supported list.
Yes, the server is definitely working, even I run my app in Xojo IDE (using windows ODBC), it works perfectly. So I think is the communication problem between my app and Linux ODBC
Your deployed app runs as a different, more restricted user than the other 2 scenarios you mentioned where it does work. Sounds like permissions or odbc setup.
The database is running on the Linux machine, which is firebird 2.5. My app will try to connect to the database through Linux ODBC driver. The database and ODBC seems working fine as my colleague can successfully connect to the database in Linux console, running the app in windows Xojo IDE can connect also.
The error message was something like “wrong ELF class: ELFCLASS64”
Sometimes differences in the environment (when running an app manually on a command line vs when running via apache or something else) can break your unixODBC configuration. I have found it easiest to specify the connection parameters in the DSN string of the ODBC driver connection, rather than to depend on odbc.ini files being loaded correctly.
Dim myDB As New ODBCDatabase
myDB.DataSource = "Driver=/path/to/driver.so;Address=123.456.78.90;Port=1234;Database=dbname;UID=myname;PWD=somepass;Parameter=value"
Experiment to make sure you get the configuration parameters right for your driver.
Maybe that is why it could be loading one version of a driver when you are at the console and another one when in CGI
I had similar problems with ODBC 64-Bit using firebird server 2.5 64-Bit on an 64-Bit LinuxMint System. With commandline-isql
it was easy to uses the odbc-installation. I switched to MBS SQLPLUGIN with the same database and it works. I checked with the support and it looks like there is a bug in the odbc-64 bit plugin… Just try the MBS-Plugin…