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

From VB use ADO to connenct to database.

Please find the connection string here.

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

commented: never knew sybase comes with .mdb files. -3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.