Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database connection error
#1
Not Solved
I get an error: Provider cannot be found. It may not be properly installed. Error Number : 3706. Please assist.
My code:
Code:
Public Function ConnectAccess (dbName)  
    On Error Resume Next

    Dim con

    Set con = CreateObject("ADODB.Connection")
    With con
        .ConnectionTimeout = 60
        .Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & dbName & ";Persist Security Info=False;"

        Set ConnectAccess = con
        Set con = Nothing
    End With
End Function
Reply


Messages In This Thread
Database connection error - by learnasugo - 05-12-2014, 06:09 PM
RE: Database connection error - by Ankur - 05-13-2014, 02:36 PM
RE: Database connection error - by learnasugo - 05-14-2014, 05:12 PM
RE: Database connection error - by Ankur - 05-15-2014, 01:49 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [UFT] Connection String for Oracle robertosalemi 6 11,739 01-15-2016, 04:51 PM
Last Post: robertosalemi
  DB2 Connect connection with IE 11 SRP 1 2,422 12-18-2015, 12:41 PM
Last Post: vinod123
  IBM DB2 connection with VB script bmurali 2 10,473 12-18-2015, 12:38 PM
Last Post: vinod123
  Connection with HP ALM hachem 0 2,416 02-26-2015, 04:36 PM
Last Post: hachem
  “Cannot connect to 8822 (connection timed out)" Ikbal 0 1,998 12-08-2014, 11:38 PM
Last Post: Ikbal

Forum Jump:


Users browsing this thread: 1 Guest(s)