OracleConnection throw null exception upon Open()

Question

When code reach .Open() method of OracleConnection object, it throw null exception, can't get why. Here is code:

using (OracleConnection connection = new OracleConnection($"User Id={dbLogin};Password={dbPass};Persist Security Info=False;Data Source={server}"))
{
    connection.Open();
}

All info being passed to connection string correctly. This sutiation happend when i'm trying to migrate from .Net oracle to ODA.NET, using Oracle.DataAccess v 4.0.3

Default System.Data.Oracle correctly opens the connection with that conenction string. Read mostly all topics about migration, no luck so far.

Ehm, no? Im asking why Open mothod throw that exception, since it's correctly initialized. — Max Podolskiy
– Max Podolskiy, Commented Apr 27, 2016 at 15:55
@OwenPauling The words 'null reference' in a post doesn't automatically qualify it as a duplicate. — Rob
– Rob ♦, Commented Apr 29, 2016 at 2:45

Max Podolskiy · Accepted Answer · 2016-04-28 10:59:40Z

1

Looks like the problem was in the corrupted Oracle Client installation.

Weird part - there was just NullRef exception with no ORA errors. After i've got proper install - everything works just fine.

Also reworked my code to OracleDataAdapter instead of OracleDataReader - code works faster and more stable.

answered Apr 28, 2016 at 10:59

Max Podolskiy

811 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dominic Cotton Over a year ago

I have found that with ODP.Net you don't always get good error reporting if you use a generic exception handler, if you catch an OracleException you get the ORA- number that will give you more information

Max Podolskiy Over a year ago

Thanks mate! But that part of my code can throw not only OracleException, and actually, i think that wasn't OracleProblem, just VS couldn't load dll's properly, or something like that.

Collectives™ on Stack Overflow

OracleConnection throw null exception upon Open()

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related