Testing access database

[shipu]

Hi,

I did the below:


QTP software is installed in C drive.

I created a access database with accdb ext. Name of db is test.accdb. I saved it in H:\qtp

I created a dsn connection. Name is dsna.I added the test.accdb in the dsna connection. I gave password under advanced option.

In QTP, I wrote as:

Code:

myDSN="dsn=dsna;uid=hr;pwd=hr;"  
Set con= CreateObject("ADODB.Connection")  
Set rs = CreateObject("ADODB.Recordset")  

con.Open myDSN

I am getting error at the last line saying 'can not open data base.....'.

Any advise please.

Thanks.

-S