1 Reply Latest reply on Feb 9, 2014 9:21 PM by user19752

    Wondows VBA ODBC Connection String

    rharrigan@fracmed.com

      I am developing an application in VBA(Visio) and I am trying to get the ODBC connection string to work.

       

      I have this:

       

      strConnection = "Driver=FileMaker Pro Advanced;AllAsText=0;ApplicationUsingThreads=1;FetchChunkSize=100;" _

      & "FileOpenCache=0;IntlSort=0;MaxTextlength=255;ServerAddress=127.0.0.1;" _

      & "TranslationOption=0;UseRemoteConnection=0;"

      Straname = "Select * From DOC"

       

      Set vsoDataRecordset = ThisDocument.DataRecordsets.Add(strConnection, strName, 0, "Org Data")

       

      any help?