Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connection using ADO
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Internet connection | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
no DDE connection?? | Excel Discussion (Misc queries) | |||
SQL Connection | Excel Programming | |||
DB Connection error | Excel Programming |