ODBC connection using DSN-LESS connection string...

Hi,

I like to migrate my Filemaker Dabatabe to Mysql. I use PHP as an API in mapping database schema and Adodb class library in connecting to Filemaker via ODBC connectivity. I have more than 25 filemaker databases that need to be imported to Mysql and it's a tedious task for if will create DSN for each of FM databases and so I prefer to use DSN-LESS connection.

The problem is I got an error in my connection string. here is my code:

require (ADODB_PATH.'adodb-errorhandler.inc.php');

require (ADODB_PATH.'adodb.inc.php');

require (ADODB_PATH.'drivers/adodb-odbc.inc.php');

$db = ADONewConnection(DBASE_TYPE);

$dsn = "DRIVER={DataDirect 32-BIT SequeLink 5.5};HST=10.10.1.41;PRT=2399;DB=FMdatabase;UID=Devel***;PWD=****";

$db->Connect($dsn);

Note: I changed the value of UID, DB, and PWD for security reason.

I got this error:

Warning: odbc_connect() [function.odbc-connect] SQL error: [DataDirect][ODBC SequeLink driver][sequeLink Server]The specified data source is not defined., SQL state S1000 in SQLConnect in includesclassesadodbdriversadodb-odbc.inc.php on line 164

It seems it cannot find the database I specified in the connection string.

However if I remove the 'DB' (Database) attribute of the connection string, I got no error but the connection will pick-up any open Filemaker databases randomly and I have no way to get the specific database that I want. I already use the Metadatabases() of Adodb but I still have no luck.

Has anyone encounter this scenario?

Edited December 17, 200718 yr by Guest