Update Sybase Tables via Visual Basic 1

[RangerFan]

We would like to update Sybase tables contained on a
standalone pc via use of a SQL statement executed from a
Visual Basic application.

Can anyone help in telling up how to connect to the tables
via ADO? Also what else would be needed to accomplish this
task? After making the connection, would it be like updating an Access table?

Any help would be appreciated.

 

[savok]

Here is some sample code, hope this helps you

Open new connection
//////////
Dim objConn As New ADODB.Connection
Dim objComm As New ADODB.Command
Dim objRec As New ADODB.Recordset
objConn.ConnectionString = "DSN=*;UID=*;SERVER=*;PWD=*"
objConn.Open

Update
////////
objComm.ActiveConnection = objConn
objComm.CommandText = "Update table blah blah.. "
objComm.CommandType = adCmdText
objComm.Execute
objConn.Close