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 |
|
Shabugeorge
Starting Member
5 Posts |
 Posted - 2004-09-13 : 03:01:20
|
| Dear friends,I have a linked server with an sqlserver2000 DBThe linked server is an access DB which is lying in the Sql server Machine and is shared among all the users.Now when the user tries to connect they are getting the following error Server: Msg 7303, Level 16, State 2, Procedure smscustomer, Line 2Could not initialize data source object of OLE DB provider 'MSDASQL'. [OLE/DB provider returned message: Operation was canceled.]Please Help. |
|
|
n/a
deleted
35 Posts |
Posted - 2004-09-13 : 09:46:44
|
| what is line 2 of you smscustomer procedure?Can you browse the tables in the linked server via EM?what are you settings for the linked server (both connection and security)? Do you have internal security on the Access file?Paul |
 |
|
|
|
|
|
Linked Server