Access/Oracle query does not work in asp

Hello,
I am trying to run a query that copies a table from and ORACLE Database to an Access file. By some reason, this query works perfectly when run from a VB project, and gives a "connection failed" error in asp. Here it is:
sSQLCopyTable = "SELECT * INTO myAccessTable FROM [ODBC;Driver={Microsoft ODBC for Oracle};CONNECTSTRING=myDBName;uid=myUserName;pwd=myPassword;].ONEDOT.myOracleTable; "

The Access connection uses the following connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myFilename.mdb;Jet OLEDB:Engine Type=4;" I also tried Engine Type 5 in this one, and the one below:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=myFileName.mdb;"

Thank you for your help!
~Alla