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

    Wondows VBA ODBC Connection String


      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=;" _

      & "TranslationOption=0;UseRemoteConnection=0;"

      Straname = "Select * From DOC"


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


      any help?