+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Database connection error (/Thread-Database-connection-error)
Database connection error - learnasugo - 05-12-2014
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 FunctionRE: Database connection error - Ankur - 05-13-2014
Check ConnectionStrings to verify whether your are entering correct data for database connectivity.
RE: Database connection error - learnasugo - 05-14-2014
The connection settings should be fine because this used to work on my old machine. I only started getting this error when I tried working with the same programs on a new machine. Any suggestions?
RE: Database connection error - Ankur - 05-15-2014
Looks like you are missing a component on this machine. Check this.