March 28, 2002 at 2:55 pm
I'm trying to create a linked server to an Access database using Enterprise Manager. I have the product name and data source filled in, but I'm not sure what to put for provider string? Books online defines it as
"Is the unique programmatic identifier (PROGID) of the OLE DB provider corresponding to this data source. provider_name must be unique for the specified OLE DB provider installed on the current computer. provider_name is nvarchar(128), with a default of NULL. The OLE DB provider is expected to be registered with the given PROGID in the registry."
ok, but where does this id come from? Any help would be much appreciated, thanks!
Dinesh
March 28, 2002 at 4:42 pm
Start adding a new linked server. Enter a name for it. For the provider select MS Jet 4.0, for data source enter the path and name of the mdb. That's it!
Andy
March 28, 2002 at 6:32 pm
I should add that the Access database is on the same machine as the sql server. I'm doing this just to see how it works. Is that a problem? I guess it defeats the point of a linked server if both databases are on the same system, but i can't find anything saying you can't do this. I put in everything like you said. It will let me expand the linked server icon, but if I try to look at the tables, nothing is displayed. If I refresh it, I get the following error:
Error 7399 ole db provider 'microsoft.jet.oledb.4.0' reported an error. (by the way where can I find what all of the error codes mean in books online?)
thanks for the help!
d.
March 29, 2002 at 5:41 am
Doesnt really matter where the mdb is, you create the linked server so that you can use it just like you would any SQL database. http://www.msdn.microsoft.com is usually the first place I check for error codes if I can't find enough info in BOL. Is it an Access 97 or Access 2000 database? Is it secured?
Andy
April 1, 2002 at 7:56 am
Check out "PRB: "Unspecified error" Error 7399 Using OPENROWSET Against Jet Database (Q296711)" at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296711
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply