Access97 does not show Pervasive tables to link

[Guest_imported]

When the macola accounting system was updated from 7.0 to 7.5, the btrieve databases were updated to Pervasive SQLv7. In MS Acccess97, several btrieve files were linked using INTERSOLV ODBC driver (a third party ODBC). After the conversion the links still worked and did not have any problems linking the new Pervasive files.

Recently, I was trying to get an ODBC connection going on another workstation and while I was able to creat a DSN connection using the Pervasive 32-bit ODBC driver, when I try to link a table the link table box pops up but there are no tables listed in there. So I went to look at how the original workstation was able to link to the databases and in doing so lost the ability to link as well.

I'm not getting errors but when I check the Pervasive SQL log I see these these error codes: "8505:An initialization error occurred when trying to establish a session with the workstation engine" and "8517:An error occurred when closing the session with the workstation engine".

What is going on and how do I fix this?

Thanks in advance!!!

 

[Pervasivite]

There are not really any easy answers, but it sounds like you are using the wrong driver. Pervasive.SQL 7 used the ODBC-32 driver v2.54, but if Pervasive.SQL 7.5 got installed on top of 7 then that ODBC was replaced by a Pervasive ODBC Client and Engine Interface v7.x. In doing the installation the old SSQL engine in 7 was probably removed and replaced with a new ODBC native engine that Pervasive calls the SRDE, thus the engine needed to supply tables for the old driver is likely no longer present. It is also likely that the new client with the new ODBC interface is not installed on these systems that you are trying to set ODBC up on.

These issues are very tricky to work through, especially with two or three ODBC connection types involved. The error you are seeing, 8505, is closely related to a Status code 3105. To determine this and solutions you can look at that article in the Pervasive Knowledge Base -

http://support.pervasive.com/eSupport/

or contact Macola or a reseller who has database knowledge in your area.

One hint though is that in most cases you are not using a workstation engine since Macola is a Pervasive OEM and mainly uses the full client/server engine.

Pervasivite