Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Protection Violation Error connection from Small Talk application to Pervasive Database

Posted on 2014-03-10
5
Medium Priority
?
938 Views
Last Modified: 2014-03-16
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.
0
Comment
Question by:gilnari
  • 3
  • 2
5 Comments
 
LVL 28

Expert Comment

by:Bill Bach
ID: 39919056
Which version of the PSQL Client is installed onto the LabWare computer?  
Which version of the PSQL Engine is installed onto the Peachtree computer?
0
 

Author Comment

by:gilnari
ID: 39920400
I have Client Pervasive 10 and 11 on LabWare Computer and we ahve Pervasive 10 on the Engine Server that houses PEachtree data files.

I have tried both the 10 and 11 ODBC connection on the LAbWAre computer. Both 10 and 11 work if I test them with MS Access or Excel to see the data withn the Pervasive Server side. So I am confident the ODBC are good, unless I need to configure something different when it comes to LabWare using the same ODBC connections to Pervasive.
0
 

Author Comment

by:gilnari
ID: 39920412
How about we forget LAbWAre.  We are using an Oracle Database, if I could set up a view in Oracle to read the Pervasive database, would solve the issue between the two applciations.  

So options are (will accept either solution)
1. Figure out why LabWare to PErvasive give a protection viloation
2. How do you create a view against the Pervisave Database from Oracle.
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 1500 total points
ID: 39920628
You can only have ONE version of Pervasive on a machine at a time, so I am not quite sure how you got both v10 and v11 on the Labware machine.  Perhaps there is an issue there.  I would recommend removing the v11 components and sticking with v10 -- matching the PeachTree server.

As for Oracle, can you access an ODBC DSN natively?  I know Microsoft supports the concept of a "linked server", which works.  Is there something similar in Oracle? I know the PSQL stuff inside and out, but have little info on this database.
0
 

Author Closing Comment

by:gilnari
ID: 39932815
Going for a work around using LabWare to MS Access link and MS Access to Pervasive.  It works for now until we figure out how to use ODBC DSN with Oracle.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seveā€¦

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question