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 |
Xhen
Starting Member
3 Posts |
Posted - 2013-03-28 : 05:13:16
|
Hello, i am trying to make linked server to microsoft access but still got errors on it, cannot initialize something like that. Anyone can help? |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-03-28 : 05:22:47
|
This link may help you........http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104092 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-03-28 : 06:04:50
|
Please refer this link: http://www.sqlservercentral.com/Forums/Topic1159903-146-1.aspx |
|
|
Xhen
Starting Member
3 Posts |
Posted - 2013-03-30 : 04:52:22
|
sorry, it doesn't solve my problem. The situation is :- the microsoft access file and the sql server are on the same computer- i'm logging on to sql server 2005 using sql server authentication with user id : sa- i'm trying these scriptsexec sp_addlinkedserver @server='Access',@srvproduct='Access',@provider='Microsoft.JET.OLEDB.4.0',@datasrc='D:\att2000.mdb'exec sp_addlinkedsrvlogin @rmtsrvname='Access',@useself='false',@rmtuser='Admin',@rmtpassword=''exec sp_tables_ex 'Access'but then it got errors like this :OLE DB provider "Microsoft.JET.OLEDB.4.0" for linked server "Access" returned message "Unspecified error".Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41Cannot initialize the data source object of OLE DB provider "Microsoft.JET.OLEDB.4.0" for linked server "Access". |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-01 : 19:00:32
|
Do any users, yourself included, have the mdb open? |
|
|
Xhen
Starting Member
3 Posts |
Posted - 2013-04-03 : 06:01:15
|
No, the mdb file is not open by anyone |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2013-04-03 : 06:11:07
|
which office suit (2003, 2007) are you using?CheersMIK |
|
|
|
|
|
|
|