Using OLEDB in a VB.NET Application

[John Dougherty]

I am following some code examples referring to using system.data.ole db - 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.Ole db.

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" <an*******@disc ussions.microso ft.com> wrote in message
news:23******** *************** ***********@mic rosoft.com...

I am following some code examples referring to using system.data.ole db - 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

[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.ole db -

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.Ole Db is the namespace. The only references added on this
project are System, System.Data, and System.XML.

Ron Allen
"Cor" <no*@non.com> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

Hi John,

I asume you have a 2002 version, OleDb is 2003

Cor

I am following some code examples referring to using system.data.ole db - 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 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