A little help with an oracle connection please

[RudyL]

I am trying to connect to an oracle server now.. When I look it up on the MSDN sire I get this page..

MSDN

Which tells me to add this:

System.Data.OracleClient.OracleConnection

The only problem is that VB does not like that.. I get a squiggly line under it and can not build it.. What am I missing??

Rudy

[Mike Hildner]

Did you add the reference?

[RudyL]

Originally posted by Mike Hildner
Did you add the reference?

Which one? Nothing I have read so far tells me what reference to add...

[Mike Hildner]

I don't use Oracle these days, but the .NET idea is the same. I'm guessing you need to add the Oracle reference to your project. As in right-click on the References node in the Solution Explorer... Add Reference, blah blah blah. That's what I mean by "did you add the reference".

Of course, the original code you posted isn't valid anyway. Can you post more code, or be specific about the "squiggly line". I know what squiggly lines are, but the specific message is helpful. When you build it, what is the *specific* error message? Details are good.

[mendhak]

You'll need to install the Oracle drivers, I suppose.

[RudyL]

Originally posted by Mike Hildner
I don't use Oracle these days, but the .NET idea is the same. I'm guessing you need to add the Oracle reference to your project. As in right-click on the References node in the Solution Explorer... Add Reference, blah blah blah. That's what I mean by "did you add the reference".

Of course, the original code you posted isn't valid anyway. Can you post more code, or be specific about the "squiggly line". I know what squiggly lines are, but the specific message is helpful. When you build it, what is the *specific* error message? Details are good.

The code I posted was exactly link in the MSDN example (with the exception of a missing "Imports" in front of it)..

The error I get is:
C:\Documents and Settings\Me\My Documents\Visual Studio Projects\VS .NET 2003\Visual Basic\WindowsApplication2\Form1.vb(1): Namespace or type 'OracleClient' for the Imports 'System.Data.OracleClient' cannot be found.

[RudyL]

Originally posted by mendhak
You'll need to install the Oracle drivers, I suppose.

I have the drivers installed.. I use Access and SqlPlus all the time to access the Oracle servers..

[Mike Hildner]

You need to add the reference to OracleClient before you can successfully use the Imports statement.

In the solution explorer, right click references, choose add reference, then, on the .NET tab, double click System.Data.OracleClient.dll, then click ok.

[RudyL]

Originally posted by Mike Hildner
You need to add the reference to OracleClient before you can successfully use the Imports statement.

In the solution explorer, right click references, choose add reference, then, on the .NET tab, double click System.Data.OracleClient.dll, then click ok.

ahhh.. That is what I have been looking for.. Thanks! You have just curred one of my biggest headaches of the month..

Wonder why that is not referenced anyplace on MSDN...