SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Linked ser ver with MS Access
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

CSK
Constraint Violating Yak Guru

USA
489 Posts

Posted - 06/03/2008 :  15:25:39  Show Profile  Send CSK a Yahoo! Message  Reply with Quote
Gurus,

While creating Linked server from SQl server to Ms access I am getting the following error


TITLE: Microsoft SQL Server Management Studio
------------------------------

"The linked server has been created but failed a connection test. Do you want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACC".
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ACC" returned message
"The Microsoft Jet database engine cannot open the file '\\xxxx\xxxxxxxx\xxxxxx\REM_Prod.mdb'.
It is already opened exclusively by another user, or you need permission to view its data.".
(Microsoft SQL Server, Error: 7303)


But rem_prod.mdb is closed. I just created the Access database. There is no password and the shared directory is having full of read and write access. Can anyone suggest me where was the problem. or am i missing something..?

Thanks
Krishna

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/03/2008 :  15:35:12  Show Profile  Reply with Quote
what did you put in location of datasource while setting up linked server?
Go to Top of Page

CSK
Constraint Violating Yak Guru

USA
489 Posts

Posted - 06/03/2008 :  15:38:40  Show Profile  Send CSK a Yahoo! Message  Reply with Quote
in datasource location i put this path \\SCLSC\Application\Database\REM_Prod.mdb
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 06/03/2008 :  15:40:31  Show Profile  Reply with Quote
But you said its no more. Be more clear.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/03/2008 :  15:58:13  Show Profile  Reply with Quote
Does sql service account have permission to access that file?
Go to Top of Page

CSK
Constraint Violating Yak Guru

USA
489 Posts

Posted - 06/03/2008 :  16:14:14  Show Profile  Send CSK a Yahoo! Message  Reply with Quote
Yes!! I got the solution !! Thanks for the reply rmiao

I hope I provided enough info in my previous post. Do any one fell that is not clear..?

-- Krishna.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.64 seconds. Powered By: Snitz Forums 2000