Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO connection error
I am attempting my first attempt to connect to an Access database using ADO.
When I try to open the connection I get a run-time error -2147467259 (80004005) Could not find installable ISAM. what the heck does this mean? I have a book Excel 2003 VBA and followed the code to the T. Am I missin something? Sub init() Dim Connection As ADODB.Connection Set Connection = New ADODB.Connection Connection.ConnectionString = ConnectionString Connection.Open MsgBox Connection.State = ObjectStateEnum.adStateOpen Connection.Close End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO connection error
Hi,
There is probably something wrong with the connection string. Insert a line before Connection.Open (Assuming the this is the line that is raising the error) Debug.Print Connection.ConnectionString Then examine the ConnectionString that is printed - see if you can find a problem with it. Let the newsgroup know and someone may be able to help. "John T Ingato" wrote: I am attempting my first attempt to connect to an Access database using ADO. When I try to open the connection I get a run-time error -2147467259 (80004005) Could not find installable ISAM. what the heck does this mean? I have a book Excel 2003 VBA and followed the code to the T. Am I missin something? Sub init() Dim Connection As ADODB.Connection Set Connection = New ADODB.Connection Connection.ConnectionString = ConnectionString Connection.Open MsgBox Connection.State = ObjectStateEnum.adStateOpen Connection.Close End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADO connection error | Excel Programming | |||
Connection error | Excel Discussion (Misc queries) | |||
XL - Oracle connection Error | Excel Discussion (Misc queries) | |||
XL - Oracle Connection error | Excel Programming | |||
DB Connection error | Excel Programming |