Classic ASP Discussion - Access/Oracle query does not work in asp

Print Page | Close Window

Access/Oracle query does not work in asp

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=5111
Printed Date: 30 March 2026 at 7:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access/Oracle query does not work in asp

Posted By: ulaska
Subject: Access/Oracle query does not work in asp
Date Posted: 18 August 2003 at 4:02pm

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