Visual Basic and Sybase Central

[michael.pilapil]

Greetings!

Hi guys,

Im mike, i am new in using Sybase central using sql anywhere 9, i've got a big problem,

on how am i to connect my Sybase database to Visual Basic 6.0.

Guys.. i badly to want to know this, because i am new to my work.

I hope you can help me Guys..:)

Regards,
Mike Pilapil

[flagstar]

Hi, try this

http://forums.devshed.com/visual-basic-programming-52/run-a-sybase-sql-script-query-in-vb6-using-odbc-233950.html

[debasisdas]

From VB use ADO to connenct to database.

Please find the connection string here.

[xtianenikkian]

If you prefer connecting database using adodc and datagrid, this would help

Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database.mdb;Persist Security Info=False"
Adodc1.RecordSource = "Select * from table"
Set DataGrid1.DataSource = Adodc1
Adodc1.Refresh

database.mdb = name of your database "you database should be save in the same folder with the program"

Select * from table = is the SQL code you will use in database it means it will post all of the values from the table "table" into the datagrid