Error in VB Script connection with Oracle 11g 64 bit

Hi All,

I am trying to connect oracle 11g with VBscript for windows 64 bit.But while connecting with code it is throwing me error as "Provider not specified" the same code in windows 32 bit edition works fine.I have created DNS and trying to connect through that the DSN is successfully getting connected.

Below if the code that iam using :

Set objcon=createobject("ADODB.Connection")
objcon.Open "DSN=MYDSN;User Id=Myid;Password=Mypassword"



Please help,

Thanks and Regards,
Anjani Kumar Deo.

Welcome to VBForums :wave:

Thread moved from the 'VB6 and Earlier' forum to the 'VBScript' forum

Are you sure the 32 bit ODBC drivers are loaded? I've never hit Oracle via VBS but in other environments the 32 ODBC admin was required.