473,320 Members | 1,982 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.

adodb vs ado.net

At this time my code use ODBC and adodb to access database. Working with win
vista i discovered that way i cannot work with SQL server. it is not clear
this is bug or Microsoft suppose to give priority to ado.net. The same time
my friend told me that Microsoft does not recomend to use ado.net. It sounds
confusing. I expected that ado.net can help to improve responce time from
database. Also ado.net simplify work with hierarhical recordset (good
alternative to left join with multiple child records).
Aleks

Apr 5 '07 #1
7 2956
I would highly question your friend's statement that Microsoft "does not"
recommend using ADO.Net; every PDC and TechEd I've gone to for the past
four/five years has talked about using ADO.Net, and I've rarely heard ODBC
come up (at least, clearly not as often as ADO.Net).

....but what, exactly, is your question?

--
~~~~~~~~~~~
Ben Rush
http://www.ben-rush.net/blog
"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D5**********************************@microsof t.com...
At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net. The
same time my friend told me that Microsoft does not recomend to use
ado.net. It sounds confusing. I expected that ado.net can help to improve
responce time from database. Also ado.net simplify work with hierarhical
recordset (good alternative to left join with multiple child records).
Aleks

Apr 5 '07 #2
There will be a lot of questions. I designed project using ado.net. First,
how i can estimate increase in memory if I read table from database.
Another is little more sophisticated. Assume I use tables A and B (they may
be different views of the same table from database, but this is not
important). I can statically establish only one relationship between A and B
which allows read in B child rows. But in reality it may be different
relationship between A and B, To implement them I need to create separate
tables and double read the same data from database. Can I establish
relationship dinamically or set dynamically property nested relation on and
off?
"Ben Rush" <kw*****@yahoo.comwrote in message
news:Op**************@TK2MSFTNGP06.phx.gbl...
>I would highly question your friend's statement that Microsoft "does not"
recommend using ADO.Net; every PDC and TechEd I've gone to for the past
four/five years has talked about using ADO.Net, and I've rarely heard ODBC
come up (at least, clearly not as often as ADO.Net).

...but what, exactly, is your question?

--
~~~~~~~~~~~
Ben Rush
http://www.ben-rush.net/blog
"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D5**********************************@microsof t.com...
>At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net. The
same time my friend told me that Microsoft does not recomend to use
ado.net. It sounds confusing. I expected that ado.net can help to improve
responce time from database. Also ado.net simplify work with hierarhical
recordset (good alternative to left join with multiple child records).
Aleks

Apr 5 '07 #3
Don't use ADODB. It probably doesn't work on Vista cos MS have not
installed it by default. You could download it and install it, but don't.
When working with .net you should only use ado.net.

To answer your question, yes you can relate two tables in ado.net. ADO.net
is a massive subject, best bet is to buy a book on it.

"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D4**********************************@microsof t.com...
There will be a lot of questions. I designed project using ado.net. First,
how i can estimate increase in memory if I read table from database.
Another is little more sophisticated. Assume I use tables A and B (they
may be different views of the same table from database, but this is not
important). I can statically establish only one relationship between A and
B which allows read in B child rows. But in reality it may be different
relationship between A and B, To implement them I need to create separate
tables and double read the same data from database. Can I establish
relationship dinamically or set dynamically property nested relation on
and off?
"Ben Rush" <kw*****@yahoo.comwrote in message
news:Op**************@TK2MSFTNGP06.phx.gbl...
>>I would highly question your friend's statement that Microsoft "does not"
recommend using ADO.Net; every PDC and TechEd I've gone to for the past
four/five years has talked about using ADO.Net, and I've rarely heard ODBC
come up (at least, clearly not as often as ADO.Net).

...but what, exactly, is your question?

--
~~~~~~~~~~~
Ben Rush
http://www.ben-rush.net/blog
"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D5**********************************@microso ft.com...
>>At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net. The
same time my friend told me that Microsoft does not recomend to use
ado.net. It sounds confusing. I expected that ado.net can help to
improve responce time from database. Also ado.net simplify work with
hierarhical recordset (good alternative to left join with multiple child
records).
Aleks


Apr 5 '07 #4
Hi Aleks,
At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net.
You're talking about 2 different technologies here: ODBC and ADODB. ODBC is
a technology that enables applications to connect to and talk to a wide
variety of databases using the same low level programming interface. It is
like a platform for creating device drivers for databases. And ODBC is
fully-supported by the .Net platform.

ADODB on the other hand is a COM object model for working with databases,
and it is not confined to working with ODBC. It can work with OLE DB as
well. But it is COM, and is not natively compatible with the .Net platform,
requiring Interop to use in a .Net application.
>The same time my friend told me that Microsoft does not recomend to use
ado.net.It sounds confusing. I expected that ado.net can help to improve
responce time from database.
ADO.Net is simply a term for the .Net platform's native technology for
database interactivity in a .Net application. So, I would consider any
opinion expressed by your friend as suspect in the future, and would verify
anything this friend told me from a reliable source in the future. In fact,
since the friend told you that Microsoft has said this, see if you can find
anywhere in the Microsoft docs that says this. You will not.

ADO.Net can not be used with any .Net application without using interop.
Interop is costly in terms of processor and memory usage, and should be
avoided. So, if you're writing a .Net application, use ADO.Net. If you're
writing an unmanaged app, use ADODB or OLE DB.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D5**********************************@microsof t.com...
At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net. The
same time my friend told me that Microsoft does not recomend to use
ado.net. It sounds confusing. I expected that ado.net can help to improve
responce time from database. Also ado.net simplify work with hierarhical
recordset (good alternative to left join with multiple child records).
Aleks

Apr 5 '07 #5
I meet today interesting problem. More exactly I know it for a long time,
but it was not crucial until today. I have few stored procedures which
return recordset. when they do not have parameters there is no problem to
create table adapter based on stored procedure. But when stored procedure
has parameters the wizard has place where I can list values for these
parameters, however there is no option to insert some infomation about
parameters. I can create query, but query returns only single value.

At home application I created few datasets with different functionality. The
main reason is that when dataset has a lot of tables it can easy move to the
top and I have to scrol a lot return to interesting for me point. May be it
gets more space. However when we come to asp.net it may be useful from next
point of view. If I know that some tables never change I can put them to
dataset which I will refer from application, not session. This will give
ability to read these data from database only once.

and the last question. If I have 2 datatables is it possible to create joint
query base on these datatables or I have to reread data from database again?

"Kevin Spencer" <un**********@nothinks.comwrote in message
news:ey**************@TK2MSFTNGP04.phvx.gbl...
Hi Aleks,
>At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net.

You're talking about 2 different technologies here: ODBC and ADODB. ODBC
is a technology that enables applications to connect to and talk to a wide
variety of databases using the same low level programming interface. It is
like a platform for creating device drivers for databases. And ODBC is
fully-supported by the .Net platform.

ADODB on the other hand is a COM object model for working with databases,
and it is not confined to working with ODBC. It can work with OLE DB as
well. But it is COM, and is not natively compatible with the .Net
platform, requiring Interop to use in a .Net application.
>>The same time my friend told me that Microsoft does not recomend to use
ado.net.It sounds confusing. I expected that ado.net can help to improve
responce time from database.

ADO.Net is simply a term for the .Net platform's native technology for
database interactivity in a .Net application. So, I would consider any
opinion expressed by your friend as suspect in the future, and would
verify anything this friend told me from a reliable source in the future.
In fact, since the friend told you that Microsoft has said this, see if
you can find anywhere in the Microsoft docs that says this. You will not.

ADO.Net can not be used with any .Net application without using interop.
Interop is costly in terms of processor and memory usage, and should be
avoided. So, if you're writing a .Net application, use ADO.Net. If you're
writing an unmanaged app, use ADODB or OLE DB.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D5**********************************@microsof t.com...
>At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net. The
same time my friend told me that Microsoft does not recomend to use
ado.net. It sounds confusing. I expected that ado.net can help to improve
responce time from database. Also ado.net simplify work with hierarhical
recordset (good alternative to left join with multiple child records).
Aleks

Apr 6 '07 #6
I'm sorry, but I don't understand the questions.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:44**********************************@microsof t.com...
>I meet today interesting problem. More exactly I know it for a long time,
but it was not crucial until today. I have few stored procedures which
return recordset. when they do not have parameters there is no problem to
create table adapter based on stored procedure. But when stored procedure
has parameters the wizard has place where I can list values for these
parameters, however there is no option to insert some infomation about
parameters. I can create query, but query returns only single value.

At home application I created few datasets with different functionality.
The main reason is that when dataset has a lot of tables it can easy move
to the top and I have to scrol a lot return to interesting for me point.
May be it gets more space. However when we come to asp.net it may be
useful from next point of view. If I know that some tables never change I
can put them to dataset which I will refer from application, not session.
This will give ability to read these data from database only once.

and the last question. If I have 2 datatables is it possible to create
joint query base on these datatables or I have to reread data from
database again?

"Kevin Spencer" <un**********@nothinks.comwrote in message
news:ey**************@TK2MSFTNGP04.phvx.gbl...
>Hi Aleks,
>>At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net.

You're talking about 2 different technologies here: ODBC and ADODB. ODBC
is a technology that enables applications to connect to and talk to a
wide variety of databases using the same low level programming interface.
It is like a platform for creating device drivers for databases. And ODBC
is fully-supported by the .Net platform.

ADODB on the other hand is a COM object model for working with databases,
and it is not confined to working with ODBC. It can work with OLE DB as
well. But it is COM, and is not natively compatible with the .Net
platform, requiring Interop to use in a .Net application.
>>>The same time my friend told me that Microsoft does not recomend to use
ado.net.It sounds confusing. I expected that ado.net can help to improve
responce time from database.

ADO.Net is simply a term for the .Net platform's native technology for
database interactivity in a .Net application. So, I would consider any
opinion expressed by your friend as suspect in the future, and would
verify anything this friend told me from a reliable source in the future.
In fact, since the friend told you that Microsoft has said this, see if
you can find anywhere in the Microsoft docs that says this. You will not.

ADO.Net can not be used with any .Net application without using interop.
Interop is costly in terms of processor and memory usage, and should be
avoided. So, if you're writing a .Net application, use ADO.Net. If you're
writing an unmanaged app, use ADODB or OLE DB.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:D5**********************************@microso ft.com...
>>At this time my code use ODBC and adodb to access database. Working with
win vista i discovered that way i cannot work with SQL server. it is not
clear this is bug or Microsoft suppose to give priority to ado.net. The
same time my friend told me that Microsoft does not recomend to use
ado.net. It sounds confusing. I expected that ado.net can help to
improve responce time from database. Also ado.net simplify work with
hierarhical recordset (good alternative to left join with multiple child
records).
Aleks


Apr 6 '07 #7
There are 3 questions.

1. How it is possible to set parameters of store procedure when I design
datatable in dataset. Designer offers to select stored procedure for view,
insert, update, delete. Only in case of delete I can give values for
parameters.

2. Is it good idea to keep dataset as application variable. In ORelly book
for asp author did not recomend to use database connection on application
level. But this point of view is not clear for me enough.

3. I can wrute
select * from A join B on A.id=B.idA
This reads data from database. Now Atable in dataset has data from table A
and similar Btable. Can I create table adapter or query which join data from
Atable and Btable.
"Kevin Spencer" <un**********@nothinks.comwrote in message
news:%2***************@TK2MSFTNGP05.phx.gbl...
I'm sorry, but I don't understand the questions.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Aleks Kleyn" <Al*********@MailAps.orgwrote in message
news:44**********************************@microsof t.com...
>>I meet today interesting problem. More exactly I know it for a long time,
but it was not crucial until today. I have few stored procedures which
return recordset. when they do not have parameters there is no problem to
create table adapter based on stored procedure. But when stored procedure
has parameters the wizard has place where I can list values for these
parameters, however there is no option to insert some infomation about
parameters. I can create query, but query returns only single value.

At home application I created few datasets with different functionality.
The main reason is that when dataset has a lot of tables it can easy move
to the top and I have to scrol a lot return to interesting for me point.
May be it gets more space. However when we come to asp.net it may be
useful from next point of view. If I know that some tables never change I
can put them to dataset which I will refer from application, not session.
This will give ability to read these data from database only once.

and the last question. If I have 2 datatables is it possible to create
joint query base on these datatables or I have to reread data from
database again?
Apr 6 '07 #8

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

Similar topics

4
by: KLomax | last post by:
I have a VB6 com object that uses ADO 2.1 for data access. I have referenced this object in a aspx application. It works fine on my local development machine. On our staging server, it errors when...
0
by: elcc1958 | last post by:
I need to support a VB6 application that will be receiving disconnected ADODB.Recordset from out DotNet solution. Our dotnet solution deals with System.Data.DataTable. I need to populate a...
0
by: Channing Jones | last post by:
Hello everyone, I am trying to store data in a binary field of an SQL-Server table using ADODB. So far, I have managed to store a record but not any data in the binary field. I only get...
5
by: Simone | last post by:
Hello I hope you guys can help me. I am very new to ADO... I am creating a ADODB connection in a module and trying to access it from a command button in a form. Function fxEIDAssgn(plngEID As...
0
by: Andre Azevedo | last post by:
Hi all ! I've created a .net serviced component with only one method. This method receive an ADODB.Command object and execute it. The ADODB.Command object is created in the client process. (VB...
0
by: ASP.Confused | last post by:
The old message looked a little stale, so I am re-posting it here. Anybody have any ideas of what I could do?!? The previous responses to this question are below. If you want to look at the...
4
by: Ames111 | last post by:
Hi I have an application that connects to a SQl database on my computer via an ADODB connection: ADODB.Connection Conn = new ADODB.Connection(); Conn.ConnectionString = ("Driver={SQL...
6
by: Wonder | last post by:
We have a VB.NET project with a reference to ADO 2.5 When I open it on my machine, I get the following build error: "The referenced component 'ADODB' has an updated custom wrapper available." ...
7
by: Bryan | last post by:
Hi , I am using ADO (ADODB) with access database. Not sure what I am doing wrong.here. Can anyone please help me? string mdbFile = System.IO.Directory.GetCurrentDirectory() +" \\bTrack.mdb;"...
6
by: Oko | last post by:
I'm currently developing an MS Access Data Project (.adp) in MS Access 2002. One of the reports within the DB uses data that is Dynamic and cannot be stored on the SQL Server. To resolve this, I...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.