Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Setting up a linked server to dBase 5 database in SQL Server 2000

Posted on 2003-03-14
Medium Priority
Last Modified: 2013-11-24
I've hit a wall trying to establish a linked server to a dBase database from within SQL Server 2000. I have tried all kinds of combinations in the connection properties. I've tried OLE DB and using a system DSN (which works if I try to bring the data into Excel!)

SQL Server lets me create the linked server and I'll see it in the list, but if I try to see any of the tables I get the following error.

OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:  
Error: 7399, Severity: 16, State: 1

Doing a Google search, I see lots of folks trying to do the same thing, being unsucessful, asking help and getting no responses. It has to be possible. I can connnect using the System DSN and Excel as well as in DTS with the standard dBase 5 connection.

I'm really under the gun on this one and will bump up the points if someone can get me an answer that works quickly.


Question by:David Little
  • 2
  • 2

Expert Comment

ID: 8142024
Try this:

1) Create an ODBC connection (TestDbase5) to the directory where you have the dbase files stored (in my case E:\data\test)

2) Add your linked server
sp_addlinkedserver @server='dbase5', @srvproduct='db5', @provider='MSDASQL',@datasrc='TestDbase5'

note: the value for srvproduct doesn't matter

3) Then to access a table named address

The [E:\DATA\TEST] is the catalog name that is assigned which you can see by executing:  sp_catalogs dbase5

This works for me.

Author Comment

by:David Little
ID: 8142751
I tried this command ...

exec sp_addlinkedserver

"Cougar" is the DSN I have set up and tested for connectivity with Excel. Using the DSN, I can import data into Excel from my dBase tables.

The linked server is created (I can see it in EM) but if I try to view a list of tables, I get the following error message ...

Error 7399: OLE DB provider 'MSDASQL' reported an error. Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].

Executing "sp_catalogs dbase5" within Query Analyzer gives me a similar error message ...

Server: Msg 7399, Level 16, State 1, Procedure sp_catalogs, Line 4
OLE DB provider 'MSDASQL' reported an error.  
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:   ].

Could this be a vestage of the tighter security in SP3? I know a few other things that got "flaky" after we applied the latest service pack.


I'm running SP3 on both the server and workstation and have tried it on multiple clients so it seems to be a server issue.

Accepted Solution

mcmahon_s earned 1000 total points
ID: 8145742
Did you create the DSN on the SQL Server machine as a system DSN?

Author Comment

by:David Little
ID: 8542540
I'm a little red faced to admit that it was this simple. Live and learn I guess!


Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question