AnsweredAssumed Answered

Password inccorect when trying to connect by ODBC with SQL

Question asked by kyle on Oct 4, 2012

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.

Outcomes