Password inccorect when trying to connect by ODBC with SQL
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.