How do I setup a Linked Server in SQL to an ODBC connection pointed to a secure Access DB?
-
How do you link a SQL Server through an ODBC connection to an Access DB that has the User Security turned on? The ODBC connection contains the user name and password. When I test the connection in C# I don't have any problems but my client can't get their SQL Server to work. This is the error they sent me. OLE DB provider "MSDASQL" for linked server "testDB" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "testDB" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". OLE DB provider "MSDASQL" for linked server "testDB" returned message "[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "testDB".