a query that works in VB does not work with asp

[alla]

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

[A1ien51]

ORACLE and Access have different Syntax!

[alla]

Here is the exact error message I am getting:

' ******** begin error message ********
Microsoft JET Database Engine error '80004005'
ODBC--connection to '{Microsoft ODBC for Oracle}myServerName' failed.

RawData.asp, line 66
' ******** end error message ********

line 66, is the one where the query is run.

[A1ien51]

:

[alla]

I am very new to this issue. Please explain why ODBC;Driver={Microsoft ODBC for Oracle} is the problem, and what should be used instead.
Thanks
~Alla