Using OLEDB in a VB.NET Application

[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

 

[Klaus H. Probst]

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/

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.

 

[Cor]

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 -

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.

 

[Ron Allen]

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

 

[Cor]

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