FM Adv. Server ODBC Connection string issue

[Steve Pugh]

Hi all,

I am trying to connect to my Filemaker Advanced Server via ODBC (from RealBasic, on my Windows 2000 PC).

I can connect fine using the following ODBC connect string, but I would like to avoid constructing a DSN on every workstation running my application. For my work with MySQL databases, I've been able to accomplish all of my connection parameters in the connect string *without* installing a DSN on each machine.

Can anyone help this poor soul? Many thanks!

Successful string (requires DSN)

db1.DataSource = "DSN=ST;UID=myuser;PWD=mypwd"

Unsuccessful string (but more like what I'm hoping to use):

db1.DataSource = "DRIVER=DataDirect 32-BIT SequeLink 5.4;PORT=2399;HOST=FMServer;database=Tracker;UID=myuser;PWD=mypwd"

I realize this might seem more of a RealBasic question, and I'm working with their folks to also try and solve things, but thought I'd ask here in case anyone has had success with ODBC connection strings and can help.

Best,

Steve

[Wim Decorte]

You might also want to try the Datadirect forums.

do let us know what you find.

Avoiding these DSN's (and having to create one per file you want to touch) is one of the big advantages of using FMSA's XML engine instead of ODBC.