0 Replies Latest reply on Oct 4, 2012 1:25 PM by kyle

    Password inccorect when trying to connect by ODBC with SQL

    kyle

      Title

      Password inccorect when trying to connect by ODBC with SQL

      Post

           If I use this connection string "Dsn=filemaker2;Database=CPMI;UID=DF;PWD=password;"

           with VB.NET, I am able to connect and select * from tables.

            

           However, if I try and add a linked server with SQL 2012 express 32 bit, and use that as my providerstring, it tells me

           OLE DB provider "MSDASQL" for linked server "FILEMAKER" returned message "[FileMaker][FileMaker]  (213): Password incorrect". (Microsoft SQL Server, Error: 7399)

           Yet, the password is correct. I have copied and pasted the exact string.

            

           Does anyone have any idea why this would happen? thanks.