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
John,
It prettyy much depend on the connection string you are using. So post the value of ConnectionString. NickHK "John T Ingato" . .. 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO connection error
Sorry. Here is the connection string:
Const ConnectionString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source = C:\Program Files\Microsoft Office\OFFICE11\SAMPLES\Northwind.mdb;Persist Security = False" "NickHK" wrote in message ... John, It prettyy much depend on the connection string you are using. So post the value of ConnectionString. NickHK "John T Ingato" . .. 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 | |||
Connection error | Excel Discussion (Misc queries) | |||
compile error... ADODB connection | Excel Programming | |||
XL - Oracle connection Error | Excel Discussion (Misc queries) | |||
XL - Oracle Connection error | Excel Programming | |||
DB Connection error | Excel Programming |