Register
  Thursday, November 20, 2008  
   
Phoenix Users Group Forums
Minimize
Phoenix Discussion Forums
Minimize
Subject: tips for Oracle users
Prev Next
You are not authorized to post a reply.

Author Messages
Eric MathisUser is Offline

Posts:30

05/08/2008 9:28 AM  

A few things we have found using Oracle with the web services.

If you receive the following error when calling the Pull web service or running AOOSE:

Message: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Solutions:

1.  You must have the Oracle client installed on your web server and your TNS names set up properly.

2.  If you don't have ingrated security enabled, you must change your web.config connection setting for each deployment to read:  User Id=PHXADM;Password=;Integrated Security=no

3.  Sometimes you are required to 'reset' permissions for the Oracle folder.  To do this, navigate to the Oracle folder, and select security.  You will need to uncheck and re-check the 'Read & Execute' permissions check box for your web service user (usually Network Services).  This is an Oracle issue and we have run into it here - and you can find some discussion about this if you google the issue.

You are not authorized to post a reply.
Forums > 8.0 Functionality > Web Services > tips for Oracle users



ActiveForums 3.7
      © 2008 Vertafore, Inc., DBA AMS Services  Terms Of Use  Privacy Statement