Printable View
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:
VB Code:
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
Did you add the reference?
Which one? Nothing I have read so far tells me what reference to add...Quote:
Originally posted by Mike Hildner
Did you add the reference?
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.
You'll need to install the Oracle drivers, I suppose.
The code I posted was exactly link in the MSDN example (with the exception of a missing "Imports" in front of it)..Quote:
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 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.
I have the drivers installed.. I use Access and SqlPlus all the time to access the Oracle servers..Quote:
Originally posted by mendhak
You'll need to install the Oracle drivers, I suppose.
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.. :DQuote:
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.
Wonder why that is not referenced anyplace on MSDN...
:rolleyes: