VB Forum / Database Access / January 2004

I have an ADOR. Recordset object that is designed to
access a remote server and retreive data in asynchronous
mode so I can return control to the program while the
download takes place -  that part works fine. I need to

What is a provider?
I keep hearing about how certain features that are part of ADO and ODBC
would depend on the provider.  Who provides these?  Do you need to go to
different places to get different implimentations of these and wouldn't

I'm a newbee looking to learn a bit about VB.NET and would like to get
recomendations on good books and/or tutorials online regarding vb.NET.
I know C++/java, so know "coding" in general, so hoping for a quick
introduction + maybe some more "advanced" books/tutorials.

The following simple line in the MSDESample from MSDN, run in VB6, almost always gets an error:
vbQuote = Chr$(34)
The error is "Can't find project or library."
What could be causing this?

I am totally new to ADO/VB.net and before emabrking on a long code change programme, I need to know a few things. I dont even really know where to begin looking.
Can anyone point me to an example of porting an ADODB.recordset into an ADO.NET Dataset and vice versa?
In other words, ...

Hi Friends,
I have controls binding with a recordset. When I'm going to update I
receieved a message like this:
"Recordsets have been changed"

This was something that I found interesting.
From a stored procedure in MSDE with adUseServer and adOpenKeyset, if
another user modifies a record in a recordset I've queried for, that
modified record drops and all records before it, while accessible, are

Even though I am referencing DAO in the following code, I
get run-time error 3251 Operation not supported for this
type of object.  The error comes up when the
       RecSet.Index="EmpID" line is read

My program uses shared Access (97) database. It works fine except in one
computer (Windows 2000). In there it works fine until the program ends.
Then it hangs the computer (ctrl+alt+del not responding).
I made some debug-printing and found out that it hangs to ADO Connection

I am looking for how to send 6 integer stored pieces of
data to an access database.  Can someone help me with the
commands and syntax.
James

I am trying to make an application that a user can type
data into all the fields and then when he is done he can
press a button to upload all this info into an Access
database.  So far it is setup with each of the fields

_____ the code___
sub insert_line (i, k)
DB.execute "INSERT INTO Table_test values(" & i & "," & k
& ")", dbSQLPassThrough

I am trying to run a stored procedure to fill a recordset in VB (against a
SQL Server DB).  If the query runs for a long, long time, can I kill it from
VB? (without killing the application itself....).
Do we have the ability in VB to do something graceful such as the stop

I am working on an application in VB which uses a database
created with MS Access 2000.  I tested the app on a Win98
PC and it failed.  Then I installed MS Access 2000 on the
Win98 PC, and the app worked.  Then I deinstalled MS

1. I need registry my dll file for adding link to references windows at vb
or other application, how I could do it..
2. I need add my database to System DSN at ODBC Data Source in program.
Where I could read about it or find help example files.