Member Avatar for TroxAlmighty

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..

  • 3 Contributors
  • 4 Replies
  • 114 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

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.

Edited by Reverend Jim
Member Avatar for TroxAlmighty

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..

Member Avatar for rishif2

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"
Member Avatar for Reverend Jim

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.