Question

Workflow Query Data using Pervasive ODBC Interface

Workflow Laserfiche

Updated December 9, 2015

asked on December 8, 2015

I am having problems querying a pervasive database. The pervasive database uses a 32 bit driver.

The database is installed on Server #1. Windows Server 2008 R2 64-bit.

LaserFiche and Workflow is on Server #2 Windows Server 2008 R2 64-bit

I have tried installing just the 32 bit driver on Server#2 however when I try to configure the Data Sources in Workflow Administration Console it appears to be looking for the 64 bit driver.

Using Pervasive Control Center I can chose the 32 bit console or 64 bit console if I install the 64 bit driver.

When I test the connection using either control panel it says I have a valid connection and using either control panel I can query valid data.

However in Workflow I get the following error message if I use Windows ODBC and select my configured Data Source.

ERROR [IM003] Specified driver could not be loaded due to system error 998: Invalid access to memory location. (Pervasive ODBC Interface, C:\Program Files\Pervasive Software\PSQL\bin\odbcci64.dll).

If I try to use direct connections to pervasive it tells me the requested ODBC driver is not installed.[0106-LDP15]

Any ideas what this is and how to connect to the database properly.

0 0

Answer

SELECTED ANSWER

replied on December 9, 2015

Thanks for pointing me out those articles to me. Neither one worked but were great ideas.

The solution turned out to be simple. Restart server after installation of drivers. (Forehead Slap)

Everything is working as expected.

Now to figure out how to write my scripts to get workflow to get the data I need.

0 0

Replies

replied on December 9, 2015

Mike, unfortunately, this is a driver error, not a Laserfiche error, so we can't really help. You might get a better answer from the Pervasive forums. A quick Google search suggests this thread with a bit more direction on what might be going on.

As you guessed, because Workflow is 64-bit, you need to use the 64-bit ODBC driver.

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow Query Data using Pervasive ODBC Interface

Answer

Replies

Sign in to reply to this post.