Oracle Connection Problem

Question

1.00/5 (1 vote)

See more:

Hello,

Please i have a code that interacts with Oracle and is working fine in my local..

And when i have hosted to the server ...its giving me error

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. - at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
Please help

Posted 24-Jun-13 3:54am

Ranjith Kumar

Add a Solution

Comments

[no name] 24-Jun-13 10:02am

Well check your connection string.

Ranjith Kumar 24-Jun-13 10:15am

As i said earlier its working in my local with no errors with same connection string

ZurdoDev 24-Jun-13 10:22am

First, you need to reply to the user instead of add a new comment to your own question. Second, fix your connection string. The connection string tells the code what the server name is, username and password, etc which will hopefully be different hosted on the server.

Ranjith Kumar 24-Jun-13 10:33am

I rechecked twice but no connection string problem

ZurdoDev 24-Jun-13 10:36am

Did you change the connection string? The one that works on your local machine will not work on a hosted server.

Ranjith Kumar 24-Jun-13 10:39am

I am using Server level configurations as my connectionstring ..so it should work in local and server

ZurdoDev 24-Jun-13 10:42am

I don't know what you mean by that. Can you post your connection string?

Ranjith Kumar 24-Jun-13 10:43am

ZurdoDev 24-Jun-13 10:44am

Well, there's the problem. No connection string. :)
I think you may have forgot to paste something in.

Ranjith Kumar 24-Jun-13 10:45am

ZurdoDev 24-Jun-13 10:45am

Something's not working.

Ranjith Kumar 24-Jun-13 10:46am

add name="HaierOracleServer" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.24.35.85)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=DRMs)));User Id=ndbd;Password=123454#123;"

ZurdoDev 24-Jun-13 10:50am

And have you checked with your hoster that the connection string is right? If so, is there more of the stack trace. It may be that the proper oracle files are not installed on your hoster.

Ranjith Kumar 24-Jun-13 10:50am

Oracle is installed on server

ZurdoDev 24-Jun-13 10:58am

Yes, but did you check with the hoster if that connection string is right? What you posted has placeholders so I don't know what you actually have but you really need to be working with your hoster.

Ranjith Kumar 24-Jun-13 10:52am

11.2.0 version is installed

1 solution

Add a Solution

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

Bernhard Hiller · Answer 1 · 2013-06-24T21:32:00

Solution 1

172.24.35.85 is aprivate IP address. If your database is hosted somewhere in the internet, you won't be able to access it with that IP address (unless you have some Virtual Private Network configured).

Posted 24-Jun-13 21:32pm

Bernhard Hiller

Oracle Connection Problem

1 solution

Solution 1

Add your solution here

Preview 0

Oracle Connection Problem

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us