Member Avatar for sravani

Hi,
I want to know how can we connect to the Microsoft ODBC Drivers to the VB.

  • 3 Contributors
  • 2 Replies
  • 96 Views
  • 9 Months Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for venkatramasamy

hi,
VB automatically recognizes the ODBC drivers
i think your question may like this...

how to connect the database to Vb or how to create the ODBC driver for DB

With regards
venkatramasamy SN

Member Avatar for Jx_Man

try this if u use access as your database.
1st make module to connect vb with database

Global Conn As ADODB.Connection
Global rs As ADODB.Recordset

Sub Access_Connector()
    Set Conn = New ADODB.Connection
        Conn.Provider = "microsoft.jet.oledb.4.0"
        Conn.CursorLocation = adUseClient
        Conn.Open App.Path & "\databaseName.mdb"
End Sub

then u can call access_connector in ur form.

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.