HI, i try to connect to a MSSQL database using FREETDS 64 bit in UBUNTU 12.04 64 bit.

From the terminal i connect without problem with the ODBC connector (UNIXODBC)

But when i try to do this in my web app:

Dim db As New ODBCDatabase
db.DataSource = “odbcname”
db.UserName = “user”
db.Password = “password”
If db.Connect Then
//proceed with database operations
MsgBox("Error: " + db.ErrorMessage)
End If

I receive the following error:

Error: [iODBC][Driver Manager]/usr/lib/x86_64-linux-gnu/odbc/ wrong ELF class: ELFCLASS64

I think that i need a 32 bits FREETDS or other something,

but i don’t know how to install a 32bits FREETDS and UNIXODBC package in UBUNTU 12.04 64 bits.

Or maybe other solution.

Please help

Still help please

All of Xojo is 32-bit so you need the 32-bit version of the database driver… Try doing a quick Google search or asking at the Ubuntu forums if anyone can help…