13 Replies Latest reply on Jun 9, 2010 5:19 PM by IwaoAVE!

    Connecting to FM Server Advanced with VBA

    pequeajim

      Title

      Connecting to FM Server Advanced with VBA

      Your post

      I am trying to connect to our Filemaker Advanced Server, (ver. 10) via ODBC and VBA.  Let me say that I am not a VBA guru, and have not used it in a while.

       

      I setup the client application, (RSView SE running on Windows XP, SP2) to connect to SQL Server as a test and it worked.

       

      I setup the DataDirect ODBC SequeLinc driver, (ver 5.5) to connect to FileMaker with a DSN and that works.  I am able to see the database and update records with a simple SQL Client, so I know that works.

       

      The error I am getting right now appears to be in the connection string.

       

      Here is the connection string I am building.  I will keep things simple and not post a bunch of code.

       

      ConnectionString = "Provider=DSNNAME;Initial Catalog=DatabaseName;User ID=USERID;password=PASSWORD"

       

      I then do an ADODB  open of the database with something like

       

      cn.Open ConnectionString

       

      The connection fails, and I am not sure how to figure out how it is failing.  My first suspision is that my connection string is incorrect?  I am not sure of the syntax.

       

      Has anyone connected to Filemaker Server with VB and ADO using a DSN with ODBC?

       

      Yikes! That's a lot of acronyms...   :smileysurprised:

       

      Thanks

      Jim!