Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Protection Violation Error connection from Small Talk application to Pervasive Database

Posted on 2014-03-10
5
Medium Priority
?
921 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 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

721 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