Member Avatar for 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

  • 4 Contributors
  • 3 Replies
  • 368 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by xtianenikkian
Member Avatar for debasisdas

From VB use ADO to connenct to database.

Please find the connection string here.

Member Avatar for 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

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.