Bug with ADO ??

  • Thread starter Thread starter Kwong
  • Start date Start date
K

Kwong

Hi,
I am using VB6 to create a DataEnvironment object
and setup a connection to a database(Access 2K).

The connection was setup using the data link properties
of the connection and the connection is tested to be
successful.
Then I created a few unbound text boxes. When user clicked
the Save button, this data will be added to an ado
recordset and updated successfully.

My problem is when I use the following statement to reset
the connection string to the connection object(examConn)
as below

DataEnvironment1.ExamConn.ConnectionString = strConn


then when user click the save button a run-time error 3251
appear and the error statement is:

Object or provider is not capable of performing requested
operation.

The connection string is the same connection string which
I copy directly from the connection object property.

I checked all my setting for the cursur location and lock
type properties are set correctly.
Why using the data link properties to set up the
connection the recordset created by the command object can
be updated correctly but on the other hand the same
recordset and the same connection string set by programing
method failed?

Why this happen? Please help!!!
 
Kwong, I think you should post to the VB6 newsgroup. This one is the VB.NET
newsgroup.
 
* "Kwong said:
I am using VB6 to create a DataEnvironment object
and setup a connection to a database(Access 2K).
Click to expand...

This is a VB.NET language group. Please turn to one of the
microsoft.public.vb.database[.*] groups.
 
Back
Top