Re: Connection errors (ORA-12504) from .NET application In message <45803eef$0$322$e4fe514c@news.xs4all.nl>, What's in a
namespace <xml@ns.com> writes
>
>"ajmastrean" <ajmastrean@gmail.com> schreef in bericht
>news:1166023687.571968.186760@j44g2000cwa.googleg roups.com...
>> Folks,
>>
>> I have the Enterprise Library 2.0 (January 2006), C# .NET, and an
>> Oracle database. I am trying to query the database using the Data
>> Access Application Block (DAAB), but I get an ORA-12504 error. My
>> connection string should be fine, as the
>> DatabaseFactory.CreateDatabase("[dbname]") command runs without error.
>>
>> The connection string is...
>> * * *
>> <add name="[dbname]" connectionString="data
>> source=[dbpath];Server=[serverpath];User
>> ID=[userid];Password=[password];"providerName="System.Data.OracleClient"
>> />
>Note that your SID should be XE and nothing but XE!
>
>
The OP is using the XE client, not necessarily the server.
Can you connect to the database using sqlplus? TNSPING only checks that
the listener knows about the database, not that it is actually
available. The message looks like a listener configuration error.
Can you provide some real values for [dbname], [serverpath]. If
possible, can you run "lsnrctl status" on the server and post the
output. [dbname] etc should match values in the listner configuration
--
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml> |