ActiveX error on DB script

Question ID: 105262
0
0

I’m getting the following error when running this database code in UFT:

"ActiveX Component cannot create Object : ADODB.Connection"

Set objDB=CreateObject("ADODB.Connection"
objDB.ConnectionString="DSN=" & DSNName &";uid=Test;pwd=xyzabc123;"
objDB.Open

Marked as spam
Posted by (Questions: 201, Answers: 22)
Asked on January 31, 2014 6:41 pm
9 views
Answers (2)
1
Private answer

You may need to reinstall or repair the MSADE:

Go to UFT's install media (.zip, .iso, etc.) and go to Prerequisites folder
Find the msade2007 folder and open the folder

Run the following .exe file: AccessDatabaseEngine.exe

Marked as spam
Posted by (Questions: 2, Answers: 451)
Answered on January 31, 2014 6:43 pm
0
Private answer

THanks. That did it.

Marked as spam
Posted by (Questions: 201, Answers: 22)
Answered on January 31, 2014 10:19 pm