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..
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..
Jump to PostYou 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.
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.