Q:
Error when tried to update the SSOledbGrid connected to with Sybase Server Database
Oracle, Visual Basic, Servers, DB2, Database, Development, ActiveX, Adaptive Server Enterprise, Sybase EAServer, Sybase, SQL Anywhere Studio/M-Business Anywhere/Avantgo 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
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:
Jul 16 2004 3:25 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
