473,320 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

ADO.NET missing?

Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component that
has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard
Nov 19 '05 #1
9 1340
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component that has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard

Nov 19 '05 #2
Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be
missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component

that
has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard


Nov 19 '05 #3
System.Data.ADO hasn't been around
since Beta 1 of the .Net Framework.

It was deprecated in Beta 2, quite some time ago.

Use any of the data classes Kevin suggested,
depending on the type of connection you need.

Take a look at
http://www.csharpfriends.com/quickst...ssbrowser.aspx
and check out
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

Juan T. Llibre
===========
"Psych971" <de*********@hotmail.com> wrote in message
news:9r*****************@newsread3.news.pas.earthl ink.net... Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be
missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component

that
has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard



Nov 19 '05 #4
WJ
It depends on what your needs are: If you just develop Asp.Net Web
Application using ADO.Net, then you need not to worry about where these
assemblies are located at. It is automatically referenced using
"System.Data.Dll" as soon as you drop the Data control(s) on your form.
Example; The SQL Connection or the DataADapter controls (from the Data tab).
However, if you want to call ADO methods itself, you will have to reference
them from the "C:\Program Files\Microsoft.NET\Primary Interop Assemblies"
folder. In this folder, there is such thing as "adodb.dll" and several
others.

Hope this helps,

John Webb

"Psych971" <de*********@hotmail.com> wrote in message
news:9r*****************@newsread3.news.pas.earthl ink.net...
Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be
missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component

that
has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard



Nov 19 '05 #5
Referencing System.Data.ADO will throw an error.

If you're still using Beta 1 of the .Net Framework ,
it does work, but it won't work with any version later
than Beta 1.

System.Data.ADO doesn't exist any more.
It was deprecated in Beta 2 of the .Net Framework.


Juan T. Llibre
===========
"WJ" <Jo*******@HotMail.Com> wrote in message
news:Ob**************@TK2MSFTNGP14.phx.gbl...
It depends on what your needs are: If you just develop Asp.Net Web
Application using ADO.Net, then you need not to worry about where these
assemblies are located at. It is automatically referenced using
"System.Data.Dll" as soon as you drop the Data control(s) on your form.
Example; The SQL Connection or the DataADapter controls (from the Data
tab). However, if you want to call ADO methods itself, you will have to
reference them from the "C:\Program Files\Microsoft.NET\Primary Interop
Assemblies" folder. In this folder, there is such thing as "adodb.dll" and
several others.

Hope this helps,

John Webb

"Psych971" <de*********@hotmail.com> wrote in message
news:9r*****************@newsread3.news.pas.earthl ink.net...
Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be
missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component
that
has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard



Nov 19 '05 #6
Basically, those are the namespaces that comprise (most of) ADO.Net.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:9r*****************@newsread3.news.pas.earthl ink.net...
Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
documentation says to reference System.Data.ADO but it seems to be
missing
from my system as I've checked the System.Data namespace in the Visual
Studio object browser and it's not there. Is this a separate component

that
has to be purchased or downloaded ? If so where can I find it?

Thanks,
Richard



Nov 19 '05 #7
WJ
I did say "System.Data.Dll", not "System.Data.ADO". And this is done
automatically for you by the VS.Net IDE. You do not need to do it if you are
using Asp.Net to interface with SQL/Server. The "ADODB.DLL" must be manually
referenced if you want to use direct "Interop." calls such as DataLink...

John

"Juan T. Llibre [MVP]" <no***********@nowhere.com> wrote in message
news:uC**************@TK2MSFTNGP09.phx.gbl...
Referencing System.Data.ADO will throw an error.

If you're still using Beta 1 of the .Net Framework ,
it does work, but it won't work with any version later
than Beta 1.

System.Data.ADO doesn't exist any more.
It was deprecated in Beta 2 of the .Net Framework.


Juan T. Llibre
===========
"WJ" <Jo*******@HotMail.Com> wrote in message
news:Ob**************@TK2MSFTNGP14.phx.gbl...
It depends on what your needs are: If you just develop Asp.Net Web
Application using ADO.Net, then you need not to worry about where these
assemblies are located at. It is automatically referenced using
"System.Data.Dll" as soon as you drop the Data control(s) on your form.
Example; The SQL Connection or the DataADapter controls (from the Data
tab). However, if you want to call ADO methods itself, you will have to
reference them from the "C:\Program Files\Microsoft.NET\Primary Interop
Assemblies" folder. In this folder, there is such thing as "adodb.dll"
and several others.

Hope this helps,

John Webb

"Psych971" <de*********@hotmail.com> wrote in message
news:9r*****************@newsread3.news.pas.earthl ink.net...
Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
System.Data
System.Data.SqlClient
System.Data.OleDb
System.Data.Odbc

--
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"Psych971" <de*********@hotmail.com> wrote in message
news:Hu*****************@newsread1.news.pas.earthl ink.net...
> Hi, I'm wondering where I'm supposed to get the ADO.NET component? The
> documentation says to reference System.Data.ADO but it seems to be
> missing
> from my system as I've checked the System.Data namespace in the Visual
> Studio object browser and it's not there. Is this a separate component
that
> has to be purchased or downloaded ? If so where can I find it?
>
> Thanks,
> Richard
>
>



Nov 19 '05 #8
Yes, John.

I was adding to your comment, since many
people don't use an IDE ( like VS.NET )
which auto-references needed resources.


Juan T. Llibre
===========
"WJ" <Jo*******@HotMail.Com> wrote in message
news:%2****************@TK2MSFTNGP15.phx.gbl...
I did say "System.Data.Dll", not "System.Data.ADO". And this is done
automatically for you by the VS.Net IDE. You do not need to do it if you
are using Asp.Net to interface with SQL/Server. The "ADODB.DLL" must be
manually referenced if you want to use direct "Interop." calls such as
DataLink...

John "Juan T. Llibre [MVP]" <no***********@nowhere.com> wrote in message
news:uC**************@TK2MSFTNGP09.phx.gbl...
Referencing System.Data.ADO will throw an error.

If you're still using Beta 1 of the .Net Framework ,
it does work, but it won't work with any version later
than Beta 1.

System.Data.ADO doesn't exist any more.
It was deprecated in Beta 2 of the .Net Framework.


Juan T. Llibre
===========
"WJ" <Jo*******@HotMail.Com> wrote in message
news:Ob**************@TK2MSFTNGP14.phx.gbl...
It depends on what your needs are: If you just develop Asp.Net Web
Application using ADO.Net, then you need not to worry about where these
assemblies are located at. It is automatically referenced using
"System.Data.Dll" as soon as you drop the Data control(s) on your form.
Example; The SQL Connection or the DataADapter controls (from the Data
tab). However, if you want to call ADO methods itself, you will have to
reference them from the "C:\Program Files\Microsoft.NET\Primary Interop
Assemblies" folder. In this folder, there is such thing as "adodb.dll"
and several others.

Hope this helps,

John Webb

"Psych971" <de*********@hotmail.com> wrote in message
news:9r*****************@newsread3.news.pas.earthl ink.net...
Yes, but isn't there a System.Data.ADO namespace? Or is it just those
namespaces that constitute ADO? Thanks, Kevin.

-Richard

"Kevin Spencer" <ks******@takempis.com> wrote in message
news:ep**************@tk2msftngp13.phx.gbl...
> System.Data
> System.Data.SqlClient
> System.Data.OleDb
> System.Data.Odbc
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> Neither a follower
> nor a lender be.
>
> "Psych971" <de*********@hotmail.com> wrote in message
> news:Hu*****************@newsread1.news.pas.earthl ink.net...
>> Hi, I'm wondering where I'm supposed to get the ADO.NET component?
>> The
>> documentation says to reference System.Data.ADO but it seems to be
>> missing
>> from my system as I've checked the System.Data namespace in the
>> Visual
>> Studio object browser and it's not there. Is this a separate
>> component
> that
>> has to be purchased or downloaded ? If so where can I find it?
>>
>> Thanks,
>> Richard
>>
>>
>
>



Nov 19 '05 #9
You are obviously referring to outdated documentation.

with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Steven T. Hatton | last post by:
If you happen to have Accelerated C++ by Koenig and Moo, and haven't gotten around to reading it, I suggest you count the pages between page 18 and page 51. I came up with zero. This is very...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
102
by: Skybuck Flying | last post by:
Sometime ago on the comp.lang.c, I saw a teacher's post asking why C compilers produce so many error messages as soon as a closing bracket is missing. The response was simply because the compiler...
0
by: kris | last post by:
hi can any one help me out, i have written a code for Word Indexing using Dll's i think this is an incomplete code for WORD INDEX. I had encountered this error "Error! No index entries found"...
17
by: Justin Emlay | last post by:
I'm hopping someone can help me out on a payroll project I need to implement. To start we are dealing with payroll periods. So we are dealing with an exact 10 days (Monday - Friday, 2 weeks). ...
2
by: jodyblau | last post by:
I have noticed that when I move my database onto a different computer, I often get a message about some reference missing. So I go into the reference list, and find the one that says "Missing,"...
0
by: youth | last post by:
I am trying to bind the DB2 utlities to a new database that was created by our DBAs. Each time I try I get the following: db2ajgrt.bnd - No errors db2clish.bnd - 13 errors all for missing...
5
by: le0 | last post by:
Hello guys, Im really having a hard time doing this, I have a record set with the ItemNo field with the data type as Text. In the record that I have, I want to find the missing number in the...
1
by: BobPaul | last post by:
I'm following code out of a howto book and this is really bugging me. This header file was created by VStudio 6.0 when I did a "Right Click: Add Member Function" CLine is a class I wrote (per the...
3
by: Fred Chateau | last post by:
Still working on my XML DataSet... Having moved on past difficult and complex problems, resolved with the assistance of everyone here, I find myself facing yet another problem. My XML document...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.