I have some problems using ADO to retrieve data from an Interbase (.gdb
file) in Visual Basic 6.0. I am trying to connect excel speedsheet to
interbase but could not.

Here are some parts of the coding involving the database connection:

' Database information
DBName = ThisWorkbook.Path & "\t6gl.gdb"

' Open the connection
Set Connect = New ADODB.Connection
Cnct = "Provider=MSDASQL.1;"
Cnct = Cnct & "Data Source=" & DBName & ";"
Connect.Open ConnectionString:=Cnct

The error message appeared like this:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Driver Manager] Data Source Name not found and no default
driver specified.

Can someone look at this problem and any solution provided will be highly
appreciated.

Alvin.