Easysoft.com Documentation Knowledge Base Products  |  Solutions  |  Support  |  Applications  |  Developer  |  Company

---

This article describes how to use a DSN-less connection that connects to an InterBase database from Visual Basic or VBA by using the Easysoft ODBC-InterBase Driver.

1. Create a Connection object:

   Dim con As New ADODB.Connection
   

2. Use the Open method to connect to the database. For example:

   con.Open "Driver={Easysoft Interbase ODBC};" _
       & "Database=myinterbaseserver:c:\myinterbasedatabase.gdb;" _
       & "UID=myinterbaseusername;PWD=myinterbaseusername"
   

   For more information about the Easysoft ODBC-InterBase Driver attributes that you can specify in the Open method’s ConnectionString argument, see the Easysoft ODBC-InterBase Driver documentation.

3. You can then query the connection using a Recordset object. The following code fetches some data and displays the results in the Immediate window:

   Dim rs As New ADODB.Recordset
   
   rs.Open "select column from mytable", con
   
   Do Until rs.EOF
      Debug.Print rs.Fields(0)
      rs.MoveNext
   Loop
   

4. Close any used recordsets and connections:

   rs.Close
   con.Close
   

   Note When you close a connection in ADO, the connection will only close in your program. ADO will keep the connection alive in case you choose to connect again.

Applies To

• Products
  • Easysoft ODBC-InterBase Driver
• Languages
  • Visual Basic