Error when tried to update the SSOledbGrid connected to with Sybase Server Database

0 pts.
Tags:
ActiveX
Adaptive Server Enterprise
Database
DB2
Development
Oracle
Servers
SQL Anywhere Studio/M-Business Anywhere/Avantgo
Sybase
Sybase EAServer
Visual Basic
I have a visual basic 6.0 application with connect to Sybase Server 11 with OBDC Driver ?Sybase System 11?. In VB application use ADO 2.8 for update a table with two fields (Integer, Varchar(10)), the SSOledbgrid return error ?16389? to update or add a register. Show error when I tried to update the varchar field. My connect String is: Set cnContacts = New ADODB.Connection cnContacts.CursorLocation = adUseClient cnContacts.ConnectionString = "Provider=MSDASQL.1;Extended properties='DSN=WellPadDB Server;SRVR=TEST120;DB=WellPadDB;UID=WellPadAdmin;PWD=AdminWellPad' Set rsContacts = New ADODB.Recordset rsContacts.CursorLocation = adUseClient rsContacts.Open SQL, cnContacts, adOpenStatic, adLockPessimistic, adCmdText Set Me.SSOleDBGrid1.DataSource = rsContacts SSOleDBGrid1.Refresh Thanks for you help
ASKED: July 16, 2004  3:25 PM
UPDATED: July 16, 2004  3:40 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

What is the error text?
Do you have to use adlockpessimistic or can you use adlockbatchoptimistic or some other type of locking?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following