Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 949
  • Last Modified:

Protection Violation Error connection from Small Talk application to Pervasive Database

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
gilnari
Asked:
gilnari
  • 3
  • 2
1 Solution
 
Bill BachPresidentCommented:
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
 
gilnariAuthor Commented:
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
 
gilnariAuthor Commented:
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
 
Bill BachPresidentCommented:
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
 
gilnariAuthor Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now