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 |
|
lc6529
Starting Member
11 Posts |
 Posted - 2003-02-11 : 10:42:31
|
| Situation:Trying to setup Access database on OPEN (for everyone - just testing) share as a Linked server.Platform:SQL 2000 with SP2 running on Win2K Server with SP2.Error message returned: 7399 OLE DB Provider returned an error.The SQL Account is running under a domain account. I logged onto the server using the domain account and was able to see the share and could open the share to see the database. I made a copy of the database and put it in the same share under a different name and insured that the database was not secured with a workgroup file and the ADMIN password was blank.I still received ERROR 7399.I insured that the security context was seto map 'all logins not listed will use LOGIN - ADMIN, with PASSWORD - [blank]still...error 7399I then tried to setup an ODBC link the database, the ODBC attached without an issue but when I tried to setup the linked server - error 7399 still came up.I then copied the database to the server and put it on a drive and tried to setup linked server - Error 7399.I then went to a test server (yep! lucky me!) that runs Win2k Server with SP2 and installed SQL 7.0 and tried to setup the linked to the share: Voila! I could open the tables and run openquery statements without any problem.I then removed SQL 7.0 and installed SQL 2000 and tried to setup the linked server - Error 7399.I then jumped up and down and yelled...still Error 7399.I drop kicked the server across the room - still Error 7399.Can anyone help? I'm against a wall..cleaning a gun...at this point.. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-11 : 18:38:32
|
| It is probably the MDAC version that's causing it. SQL 2000 installs with a newer version (I think 2.6) whereas SQL 7.0 might be using 2.5 or earlier. The components that work with MS Access were removed from the general MDAC distribution around v2.5, so it's possible that it simply doesn't have the code to connect properly.Take a look at http://www.microsoft.com/data/download.htm for the latest MDAC components, and also look for the Jet service packs (4.0 SP3 is available) If you install the Jet components you should be able to get it working. |
 |
|
|
|
|
|
Error 7399./Linked Servers/Access DB