Re: Unable to query Pervasive SQL
This is a discussion on Re: Unable to query Pervasive SQL within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Originally posted by Walid Haider > Hi Out there, > > I am trying to query a BTrieve database ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:14 PM
| ||||
| ||||
 Re: Unable to query Pervasive SQL Originally posted by Walid Haider > Hi Out there, > > I am trying to query a BTrieve database (which clients use > Pervasive SQL to > connect). I have managed to create a Linked Server in > Enterprise Manager > with the following details: > > Provider: Microsoft OLE DB Provider for ODBC Drivers > Data Source Driver: Pervasive ODBC Client Interface (tested and > connected > successfully) > > From the linked server in Enterprise Manager I am able to see > the tables, > but when I try to query any of the tables from Query Analyzer, > typing the > following syntax: > > SELECT * > FROM linkedserver.datasource..table > > I get the following message: > Server: Msg 7399, Level 16, State 1, Line 1 > OLE DB provider 'MSDASQL' reported an error > [OLE/DB provider returned message: unspecified error] > > Any ideas where I am going wrong? > > Thanks Walid -- Posted via http://dbforums.com      |
Linear Mode
