hello guys.. just a new member here.. and also a beginner at VB6..

i would like some help on how to connect my system with a database? because i cannot see the basic of connecting my system to a database.. thank you very much..

Recommended Answers

You have to use a connection object with the appropriate connection string. That string will depend on what type of database you are connecting to. Sample connection strings can be found here.

Jump to Post

All 4 Replies

You have to use a connection object with the appropriate connection string. That string will depend on what type of database you are connecting to. Sample connection strings can be found here.

well.. i am using access for my database. microsoft access to be exact.. so what connection must i use? because i am seeing many types of connections just like adodb adodc.. well i really don't have experience on any of these..

i am using access for my database. microsoft access to be exact.

try this:-

con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\db.mdb;Persist Security Info=False"

You will have to use OleDb or ADODB objects for your interface to an Access database.

Be a part of the DaniWeb community

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