Using revDB with DSN-less ODBC connections on MacOS X?

[Jay Madren]

For a DSN-less ODBC connection to MS SQL Server on Windows, I use
"DRIVER=SQL Server;SERVER=<servername>".  Note that this connection string
(which is really the host parameter in rev) has to be in double quotes.  And
since it's not a DSN, you have to specify the database name in the next
parameter.  An example of my call is:

revOpenDatabase("ODBC","DRIVER=SQL
Server;SERVER=<servername>","<dbname>","<login>","<pw>")

Hopefully you can apply this to your situation.

Jay Madren

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of Ben
Rubinstein
Sent: Wednesday, September 01, 2004 06:41
To: use-revolution at lists.runrev.com
Subject: Using revDB with DSN-less ODBC connections on MacOS X?


Has anyone succesfully used revDB to connect to an ODBC data source on MacOS
X without a DSN, using just a connection string?

Ken Ray kindly sent me a sample which suggested it should at least be
possible on Windows, replacing the DSN in the call with a connection string
of the form eg
    DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\test.mdb;

But all the plausible strings I try to construct on MacOS X fail with the
message
    [iODBC][Driver Manager]Data source name not found and no default
    driver specified. Driver could not be loaded.

I'm using the OpenLink SQL Server driver.  I'm copying text out of the
ODBC.ini file for DSNs that are known working, and I've tried both using the
driver name, eg
    DRIVER={OpenLink SQL Server Lite Driver}

and the path, eg
    DRIVER={/Library/ODBC/OpenLink SQL Server Lite ODBC
            Driver.bundle/Contents/MacOS/sql_st_lt.so};

but I get the same message each time.

Has anyone else succeeded (or tried and failed) to do this on MacOS X?

Is there some peculiarity of iODBC on MacOS X which means DSN's less
connections can't be used here, although they can on Windows?

Is it possible that the message is just misleading, and that one or other
formulation for driver was actually working, but it was failing on some
other part of the connection string?

Answers to any of the above gratefully received,

  Ben Rubinstein               |  Email: benr_mc at cogapp.com
  Cognitive Applications Ltd   |  Phone: +44 (0)1273-821600
  http://www.cogapp.com        |  Fax  : +44 (0)1273-728866

_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution