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 |
|
nsteiner
Starting Member
13 Posts |
 Posted - 2001-05-16 : 10:35:26
|
| Alright nr, it just so happens we are attempting to add a linked server. Here's the scoop:SERVER1 - SQLServer 7 SERVER2 - Access 2.0 Database on NTSERVER3 - Access 2.0 Database on NTWhen I run sp_addlinkedserver, it creates the server fine, but I cannot view any tables through the MMC. Here's the code within an ASP page which is executing the sproc on SERVER1:dbConn.Execute "sp_addlinkedserver 'ITrack', 'Access', 'Microsoft.Jet.OLEDB.4.0', '\\SERVER2\Track\itrack.mdb'"When I go into MMC to look at the tables of the linked server, I get:"Error 7303: Could not initialize data source object of OLE DB provider 'Microsoft.Jet.OLEDB.4.0'"And I have to say "huh???" to that little error message.Any words of wisdom??I am counting on you nr. ns==================================================Forced into becoming a SQL Guru |
|
|
|
|
|
LINKED SERVERS -- TELL ME MORE!!