Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

FM Adv. Server ODBC Connection string issue

Steve Pugh
in FileMaker Server v7 - v11

Featured Replies

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):P

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

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.

Create an account or sign in to comment

https://fmforums.com/topic/46469-fm-adv-server-odbc-connection-string-issue/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.