Re: Connection errors (ORA-12504) from .NET application

In message <45803eef$0$322$e4fe514c_at_news.xs4all.nl>, What's in a namespace <xml_at_ns.com> writes
>
>"ajmastrean" <ajmastrean_at_gmail.com> schreef in bericht
>news:1166023687.571968.186760_at_j44g2000cwa.googlegroups.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>