We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,842 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Visual Basic and Sybase Central

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
1 Week
Discussion Span
1 Year Ago
Last Updated
4
Views
michael.pilapil
Newbie Poster
9 posts since Jul 2011
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0
flagstar
Practically a Master Poster
620 posts since Oct 2009
Reputation Points: 126
Solved Threads: 63
Skill Endorsements: 0

From VB use ADO to connenct to database.

Please find the connection string here.

debasisdas
Posting Genius
6,968 posts since Feb 2007
Reputation Points: 722
Solved Threads: 457
Skill Endorsements: 20

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

xtianenikkian
Light Poster
39 posts since Sep 2008
Reputation Points: 11
Solved Threads: 3
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
View similar articles that have also been tagged:
 
© 2013 DaniWeb® LLC
Page rendered in 0.0618 seconds using 2.63MB