Solved

Protection Violation Error connection from Small Talk application to Pervasive Database

Posted on 2014-03-10
5
898 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

734 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