Using OLEDB in a VB.NET Application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am following some code examples referring to using system.data.oledb - however, I do not have "oledb" available as an item to select. I type system.data., and I can see SQLClient, but not oledb. I assume I am missing a reference, but cannot find anything documentation to tell me which reference I could add to have oledb available in my app

Any ideas

- Thanks

JRD
 
John,

If you have a reference to System.Data.dll then that's it, that's where the
provider lives. The namespace is System.Data.Oledb.

You might be missing an "imports" or "using" statement at the top of the
file?


--
____________________
Klaus H. Probst, MVP
http://www.vbbox.com/

John Dougherty said:
I am following some code examples referring to using system.data.oledb -
Click to expand...
however, I do not have "oledb" available as an item to select. I type
system.data., and I can see SQLClient, but not oledb. I assume I am missing
a reference, but cannot find anything documentation to tell me which
reference I could add to have oledb available in my app.
 
Hi John,

I asume you have a 2002 version, OleDb is 2003

Cor
I am following some code examples referring to using system.data.oledb -
Click to expand...
however, I do not have "oledb" available as an item to select. I type
system.data., and I can see SQLClient, but not oledb. I assume I am missing
a reference, but cannot find anything documentation to tell me which
reference I could add to have oledb available in my app.
 
Cor,
OleDb is in VS 2002/Framework 1.0 as well.
For John, I just tried this on my older VS 2002 project and it worked
System.Data.OleDb is the namespace. The only references added on this
project are System, System.Data, and System.XML.

Ron Allen
 
Hi Ron,

Thanks, where do I go wrong than, you could not use MS Access I thought in
2002, but maybe I am totally wrong, let us keep it by that by that.

I did not check this one.

Thanks again,

Cor
 
Back
Top