Solved

Protection Violation Error connection from Small Talk application to Pervasive Database

Posted on 2014-03-10
5
850 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

772 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now