troubleshooting Question

Linked Server to connect using Advantage OLEDB from MS SQL

Avatar of Angel02
Angel02 asked on
Sybase DatabaseMicrosoft SQL ServerDatabases
18 Comments3 Solutions3488 ViewsLast Modified:
I have created a linked server on SQL Server 2008 instance using Provider Advantage OLE DB to connect to a database consisting on .DBF files. I right-clicked and hit test connection and it succeeded. I also tested the connection using .UDL and it worked. But when I try to access a .dbf file using the query it returns empty results

Select * from OpenQuery(DBFFILESERVER, 'SELECT * from MyTable')

It is throwing the following message

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Advantage.OLEDB.1" for linked server "DBFFILESERVER" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "Advantage.OLEDB.1" for linked server "DBFFILESERVER".

The same DBF file Database can be accessed using Advantage OLE from a SQL Server 2005 instance that we have on a different server (windows 2003). I am just trying to set up an environment on our new Windows 2008 Server but facing this issue.
ASKER CERTIFIED SOLUTION
prequel_server

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros