LC7and up - cannot connect to DB with ODBC connection string

Matthias Rebbe matthias_livecode_150811 at m-r-d.de
Fri Aug 5 09:34:14 EDT 2016


Hi,

maybe i am missing something.

I have here a script which connects fine in LC6 to a DB using an odbc connection string.

The connection string looks like this:
get revOpenDatabase("ODBC","Driver={Actual SQL Server};Server=192.168.1.250;Database=testdb;UID=mr;PWD=Baj43jaX;",,,)

In LC7 and up i get the error 

[iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded


Connecting using a DNS (using the same driver from Actual Tech) works w/o problems in LC7 and up.
This problem just exists on Mac OSX.  On Windows i can connect to a DB in LC7 and up using a ODBC connection string.

Tried with LC 7.14 and LC 8.1.0 DP3.


Did anyone else run into this already?

Could this be a bug?

Matthias Rebbe





More information about the use-livecode mailing list