Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2010-12-06 : 09:16:30
|
| Hello All,I was able to setup a linked server profile for an access 2007 database and I was able to connect to it on the physical server, but I’m not able to connect to it remotely. If I try to connect to it remotely I would get the below error:Cannot initialize the data soruce object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “ProjectsXtract.” (Mirosoft SQL Server, Error: 7303)Under the Linked Server Properties I setup my local login checked impersonate and set RPC Out to True still did not work.Does anyone knows how to resolve this issue?Thanks. |
|
|
|
|
|
Help accessing linked server outside the physical