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: 227, Answers: 22)
Asked on January 31, 2014 6:41 pm
28 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: 477)
Answered on January 31, 2014 6:43 pm
0
Private answer

THanks. That did it.

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

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top