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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-11 : 08:08:47
|
| Nalina writes "Hi!I was trying to set up linked server to a access database sitting my computer, I also have sql server client installed my computer, I used the linked sever wizard under security in sql enterprise manager and also used sp_addlinkedserver T-sql command to do this. But I am getting a error 7399. I searched on the net for this error explanation but its not really helpfull. Could you please tell me, if the sql server is sitting on a different computer and access database (which has a associated security workgroup file) is on a different computer how do i set up the linked server.I also get this error when I try to connect to a datawarehouse database (for which I have a dsn), I tried using MSDASQL provider and IBM OLE DB provider of DB2 database and all other providers to set up the linked server but I am not able to do it.Could you please give me detailed instructions on how to go about this.Your help is much appreciated Nalina" |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2004-03-11 : 13:08:09
|
| Did you do a sp_addlinkedsrvlogin, to map the logins. This is where the error usually happens. A good way to test your ability to connect to the access database, is to set up a DTS Transaction, and try to connect from there. |
 |
|
|
|
|
|
how to set up linked server to access db in sql server