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 7 2980
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*********@Ma ilAps.orgwrote in message
news:D5******** *************** ***********@mic rosoft.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
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******** ******@TK2MSFTN GP06.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*********@Ma ilAps.orgwrote in message
news:D5******** *************** ***********@mic rosoft.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
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*********@Ma ilAps.orgwrote in message
news:D4******** *************** ***********@mic rosoft.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******** ******@TK2MSFTN GP06.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*********@Ma ilAps.orgwrote in message news:D5******* *************** ************@mi crosoft.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
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*********@Ma ilAps.orgwrote in message
news:D5******** *************** ***********@mic rosoft.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
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**********@n othinks.comwrot e in message
news:ey******** ******@TK2MSFTN GP04.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*********@Ma ilAps.orgwrote in message
news:D5******** *************** ***********@mic rosoft.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
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*********@Ma ilAps.orgwrote in message
news:44******** *************** ***********@mic rosoft.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**********@n othinks.comwrot e in message
news:ey******** ******@TK2MSFTN GP04.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*********@Ma ilAps.orgwrote in message news:D5******* *************** ************@mi crosoft.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
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**********@n othinks.comwrot e in message
news:%2******** *******@TK2MSFT NGP05.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*********@Ma ilAps.orgwrote in message
news:44******** *************** ***********@mic rosoft.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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 trying to
instantiate the com object.
This object runs fine in another asp application on the
same box, so it is not the object itself.
I am remotely compiling the application on our staging
server.
The full error message is below.
|
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
disconnected ADODB.Recordset from System.Data.DataTable data. Below
is the source code I am implementing to test the process. I do not
get any error, that I can see. The problem I have is that at the end,
the recordset seems to be empty. Any...
|
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 exceptions on various part. I have tried both AppendChunk and
using a stream object.
Unfortunately all the examples I can find in the Net and on the Microsoft
site
|
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 Long) As Boolean
Dim rsAssignedUser As ADODB.Recordset
Dim strSelectUser As String
|
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 for example).
When I try to set the connection property or try to open a recordset using
the Command object I've got an error.
Here is the mehotd code for the connection set error:
| |
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 original question, the
subject line is:
ADODB.NET and "Access Denied"
I have an ASP.NET page writtein in VB that uses ADODB. I just had to
|
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
Server};Server=4P-12.Leighton.local;Database=HD;Uid=l0073;Pwd=cheese");
|
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."
When I double click on it, I get the following dialog appear:
If I click 'No', for every object declared from the ADODB library, I get a
build error as follows: "Reference required to assembly 'ADODB' containing
the type 'ADODB.Connection'. Add...
|
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;"
ADODB.Connection conn = new ADODB.Connection();
ADODB.Recordset rs = new ADODB.Recordset();
string connString =string.Format("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source={0}", mdbFile);
string query = "Select * from Client";
|
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 have created an
ADODB.Recordset in the reports OPEN event, built the necessary records
inside of it, and then bound the report to this newly created
recordset.
Here's the rub:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |