Connecting to MySQL to retrive data !

[NancyNancy]

I am following the example in QTP unplugged chapter 22

trying to connect to the DB, our DB runs on MySqL

Here is my Script

Code:

Dim adocon
Set adoCon = CreateObject ("ADODB.Connection")
ConStr = " DSN = name ; UID= admin ; PWD= 4d645df259f5cb14d0b65f8395f21ac47746845ae08719122210aa77 ; DataBase = My_DB "
AdoCon.open ConStr

Run Error =

Code:

Run Error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Line (35): "AdoCon.open ConStr".

Does anyone tried this before?

[basanth27]

Are you able to create a dsn on your machine with those credentials? I guess there is a website called www. Connectionstrings.com which has the info you require. I may be wrong about the site. If you dont please google for connection string for mysql.