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 - 2005-08-22 : 07:05:30
|
| Srikanth B writes "Dear Sir/Madam,I am working on MS SQL Server 7, My database(Back End) is MS Access.I want to give link between SQL and Access.I have written Access linked server called 'ACCESS_DATABASE' that has to be connected to the database 'Srikanth_Workings.mdb' stored in the c:\ directory:code..................>EXEC sp_addlinkedserver @server='ACCESS_DATABASE', @srvproduct='ACCESS', @provider='Microsoft.Jet.OLEDB.4.0', @datasrc='c:\Srikanth_Workings.mdb'- - - - - - - - - - - - - But it is giving a Error....Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.Please kindly help me on the same.Waiting for your early reply.Thanks and RegardsSrikanth B" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-22 : 11:00:18
|
| Is the access db open? try leaving srvproduct argument out.THE BIGGER QUESTION: Why don't you just migrate your Access database to SQL Server. Everything will work a lot faster in most cases. SQL Server is not really intended to be a front end to access. However a lot of people do the opposite... look into the Access Upsizing Wizard.====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
MS SQL Server 7 - Linked Server - Error No. 7399