Connection

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.

Your connection string doesn't seem to be correct.

Take a look at what Carl Prothman has at
http://www.able-consulting.com/ado_conn.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"alvin" wrote in message

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