ADODB - Visual Basic .NET

Merlin

Hi,

In VB6 when using ADO e.t.c, it was often required to called the function
db.engine.idle, otherwise MS Access took ages to release record locks and
basically made concurrent use impossible.

Will I suffer the same problems with ADODB in VB.NET? if so is there a
correct method to also implement this function. or does good old ADODB do
all this for me?

Thought I'd enquire as I've found no reference to this and didn't want to be
caught out in the later stages of my project..

Thanks,

Merlin

Nov 19 '05 #1

Subscribe Reply

4127

Jeremy Cowles

"Merlin" <je**@jg-tech.co.uk> wrote in message
news:be******** **@sparta.btint ernet.com...

Hi,

In VB6 when using ADO e.t.c, it was often required to called the function
db.engine.idle, otherwise MS Access took ages to release record locks and
basically made concurrent use impossible.

Will I suffer the same problems with ADODB in VB.NET? if so is there a
correct method to also implement this function. or does good old ADODB do
all this for me?

As far as I know, ADODB is just a namespace for the ADO COM library. But
symantics aside, I think the ADO.NET people could better awnser this
question:

microsoft.publi c.dotnet.framew ork.adonet

HTH,
Jeremy

Nov 19 '05 #2

Paul Clement

On Wed, 9 Jul 2003 12:39:09 +0000 (UTC), "Merlin" <je**@jg-tech.co.uk> wrote:

¤ Hi,
¤
¤ In VB6 when using ADO e.t.c, it was often required to called the function
¤ db.engine.idle, otherwise MS Access took ages to release record locks and
¤ basically made concurrent use impossible.
¤
¤ Will I suffer the same problems with ADODB in VB.NET? if so is there a
¤ correct method to also implement this function. or does good old ADODB do
¤ all this for me?
¤
¤ Thought I'd enquire as I've found no reference to this and didn't want to be
¤ caught out in the later stages of my project..

I'm assuming you're referring to DAO (DBEngine.Idle) and not ADO.

ADO.NET operates a bit differently than DAO (and ADO) in that for the most part your data is in a
disconnected state. Whether you use SQL statements, stored procedures or the data objects, updates
operate under optimistic concurrency - which means that locking only occurs for the duration of
database update. There is no supported client-side edit locking mode. Edit locking (pessimistic
concurrency) only occurs at the database (server-side) level.
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)

Nov 19 '05 #3

Jeremy Cowles

"Paul Clement" <Us************ ***********@sws pectrum.com> wrote in message
news:is******** *************** *********@4ax.c om...

On Wed, 9 Jul 2003 12:39:09 +0000 (UTC), "Merlin" <je**@jg-tech.co.uk> wrote:
¤ Hi,
¤
¤ In VB6 when using ADO e.t.c, it was often required to called the function ¤ db.engine.idle, otherwise MS Access took ages to release record locks and ¤ basically made concurrent use impossible.
¤
¤ Will I suffer the same problems with ADODB in VB.NET? if so is there a
¤ correct method to also implement this function. or does good old ADODB do ¤ all this for me?
¤
¤ Thought I'd enquire as I've found no reference to this and didn't want to be ¤ caught out in the later stages of my project..

I'm assuming you're referring to DAO (DBEngine.Idle) and not ADO.

ADO.NET operates a bit differently than DAO (and ADO) in that for the most part your data is in a disconnected state.

This is, of course, depending on what ADO.NET objects you are using & how
you write your data-access layer.

Nov 19 '05 #4

Paul Clement

On Wed, 09 Jul 2003 14:00:50 GMT, "Jeremy Cowles" <je************ *************@a sifl.com> wrote:

¤
¤ "Paul Clement" <Us************ ***********@sws pectrum.com> wrote in message
¤ news:is******** *************** *********@4ax.c om...
¤ > On Wed, 9 Jul 2003 12:39:09 +0000 (UTC), "Merlin" <je**@jg-tech.co.uk>
¤ wrote:
¤ >
¤ > ¤ Hi,
¤ > ¤
¤ > ¤ In VB6 when using ADO e.t.c, it was often required to called the
¤ function
¤ > ¤ db.engine.idle, otherwise MS Access took ages to release record locks
¤ and
¤ > ¤ basically made concurrent use impossible.
¤ > ¤
¤ > ¤ Will I suffer the same problems with ADODB in VB.NET? if so is there a
¤ > ¤ correct method to also implement this function. or does good old ADODB
¤ do
¤ > ¤ all this for me?
¤ > ¤
¤ > ¤ Thought I'd enquire as I've found no reference to this and didn't want
¤ to be
¤ > ¤ caught out in the later stages of my project..
¤ >
¤ > I'm assuming you're referring to DAO (DBEngine.Idle) and not ADO.
¤ >
¤ > ADO.NET operates a bit differently than DAO (and ADO) in that for the most
¤ part your data is in a
¤ > disconnected state.
¤
¤ This is, of course, depending on what ADO.NET objects you are using & how
¤ you write your data-access layer.

Not sure what you're getting at. Do you have an example?
Paul ~~~ pc******@amerit ech.net
Microsoft MVP (Visual Basic)

Nov 19 '05 #5

Similar topics

9312

File or assembly name ADODB, was not found.

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.

ASP / Active Server Pages

2880

Populating disconnected ADODB.Recordset with System.Data.DataTable data.

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...

.NET Framework

2479

Storing Data in Binary Field using ADODB

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

C / C++

29848

ADODB.Recordset - referring to a field

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

Microsoft Access / VBA

3285

ADODB Command parameter error !

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:

C# / C Sharp

3538

ASP.NET, ADODB and "Access Denied"

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

ASP.NET

5511

C# - ADODB - Failure to connect on deployment

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");

C# / C Sharp

5366

ADODB custom wrapper

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...

Visual Basic .NET

4153

ADODB Find/ Seek method in C# 2005

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";

C# / C Sharp

5174

Problems w/ ADODB.Recordset as Report Source...

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:

Microsoft Access / VBA

9643

What is ONU?

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...

General

9480

Changing the language in Windows 10

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,...

Windows Server

9947

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7494

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6737

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5379

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

4045

transfer the data from one system to another through ip address

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

C# / C Sharp

3645

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2877

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General