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