Windows 7 ADO.DB connection comand

[sams001]

Hi All,

In our f/w we are using Excel DSN to execute a set of qtp scripts. To open the connections for this, we use the following command:

Code:

Set dbConnect = CreateObject("ADODB.connection")
dbConnect.open "DSN=" & strDSN,"",""
sqlQry = "select * from [" & strSheetName & "$]"
rsTests.open sqlQry,dbConnect

This is working fine in windows XP machine. but the same in windows7 is giving the below error in line 2 (above code):
The specified DSN contains an architecture mismatch between the driver and Application.

I have no idea what this error is and fix for this. If anyone faced this issue, please share with me. I am spending so much time on this but no solution.

Pl help.

Thanks
Sams