I am trying to link SQL Server 2008 - 64 to an MS Access database on a network share. I can get the link to work from the SQL management studio but when I try to do a ODBC query (from another machine) of a view table pointing to the access db through
a linked server using the "Microsoft.ACE.OLEDB.12.0"driver. The error from the odbc trace is:
" DIAG  [Microsoft][SQL Server Native Client 10.0][SQL Server]OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "STPRD" returned message "Not a valid account name or password.". (7412) "
Yes the login to the password are good. I have tried various setting using sp_addlinkedsrvlogin function but nothing will handle the extra hop.
View Complete Post