Web.config in web service

Question

0.00/5 (No votes)

See more:

Can this configuration:

XML

<configuration>
  <oracle.dataaccess.client>
    <add key="DllPath"            value="C:\oracle\bin"/>
    <add key="FetchSize"          value="65536"/>
    <add key="StatementCacheSize" value="10"/>
    <add key="TraceFileName"      value="c:\odpnet1.trc"/>
    <add key="TraceLevel"         value="63"/>
    <add key="TraceOption"        value="1"/>
  </oracle.dataaccess.client>
</configuration>

Work inside of a web services web.config. i have tried it and specifically I need DllPath, but it is not working

Posted 25-Apr-13 10:30am

Ryanm1324

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

db7uk · Accepted Answer · 2013-04-25T10:33:00

Solution 1

Not sure what you are trying to do there but I would change the oracle.dataaccess.client to appSettings. Then call ConfigurationManager.AppSettings["Key of setting"]

http://msdn.microsoft.com/en-us/library/system.configuration.configurationmanager.appsettings.aspx[^]

Posted 25-Apr-13 10:33am

db7uk

Comments

Ryanm1324 25-Apr-13 17:44pm

The reason I am trying to set DllPath is because I first call a web service which queries a table in an old legace Oracle 7.3.4 database and it uses Oracle 8i client. When I switch to the other web service to insert the received data into an Oracle 10g database which is on the same IIS server, I get an error The provider is not compatible with the version of Oracle client. Im not sure if this is a good way of doing this or not. Ive had problems in the past with the old legacy database, but unfortunately there isnt a client compatible for both.

db7uk 25-Apr-13 18:03pm

Ok I understand. Can you create a linked server (Database Link)? http://it.toolbox.com/blogs/oracle-guide/database-links-a-definition-in-plain-english-7023. Not done it in oracle, but could you not reference the new database only and handle the legacy stuff from 10 links? Either that or do a bulk update to the new db from the legacy one? i.e. migrate all relevant data from the old database and migrate to new datbase under different schema?

Ryanm1324 26-Apr-13 10:19am

Unfortunately you cannot link to Oracle 7.3.4 from Oracle 10g. You can from Oracle 10g back to Oracle 9i, but not further back.

db7uk 26-Apr-13 17:22pm

I see you point. can you bulk insert your data into a database that you can then use on oracle 10g?

Ryanm1324 26-Apr-13 17:55pm

Other systems that cannot be phased out yet are feeding the data in Oracle 7.3.4. I am setting up kind of an interface to bring "OPEN" records to the 10g side for processing. I need this to run daily as there will be records added to the Oracle 7 side during each day.