A puzzler for you. I have a small talk applicaiton(LabWare if you must know) that I needs to read data from a Peachtree database (just read only no write so not to violate SOX). My issue is I can connect application to MS Access and MS Access to Pervasive Database and pull the data all through ODBC connections.
What I cannot do is connect LabWate to PEachtree through ODBC (one ODBC connection vs the two). LAbWare is on one server, PEachtree / Pervasive is on other. When I try the one hop ODBC LabWAre to Pervasive I get "Protection Violation Error". I have changed the DEP settings for Labware on the LabWAre server but still get the issue - What am I missing? Do I need to allow DEP exception on the PErvasive Server and if so for what applicaiton?
I wish I could reward more points if somone could help me figure this out so I don't have to have MS Access running as middle man between the two applications.