Harry Leboeuf Kinepolis


This is the Setup ...

On a Virtual PC i'm running an older Pervasive Btrieve App. That can be reached by a ODBC driver.

This Virtual PC runs om a 64bit Vista. On that 64bits Vista machine i'm running a 64bits instance of sql server and a 32bits, because there seems to be no way to have the 64bits instance use a 32 bits odbc driver.

From the production server (EntEd 32bits) i'm changing the ip of the Server in de Systsm_DSN to my Virtual PC. When testing the odbc driver it works, and using a select through the linked server works fine too.

When creating the same linked server on my Vista/32BitsSql Server it works too. But when selecting data i'm getting this error

OLE DB provider "MSDASQL" for linked server "VSERVER" returned message "[Pervasive][ODBC Client Interface][Client LNA]Your connection to the server is no longer working. To continue, disconnect from the data source and re-connect again. Contact your system administrator if you still need assistance.".

Msg 7306, Level 16, State 2, Line 1

Cannot open the table ""VANLIER"."SUP"" from OLE DB provider "MSDASQL" for linked server "VSERVER".

Is there a way to find out what's happening




Re: Problems ODBC driver

Harry Leboeuf Kinepolis


Never foudn what was/is happening, but by openquery i'm avoiding the problem !!