I am now trying to evaluate ASPDB with my oracle database, which is version 8.0.3 (using the Oracle 8.0.3 DSN). I was wondering if anyone could point me in the right direction. I searched the documentation as well as the web site and really couldn't find much about Oracle specific errors. All I'm trying to do is a simple select query and execute it.

eg
MyDb.dbSQL = "Select * From PROJECT"
MyDb.ASPdbPro()

But I get the following error:

ORA-00922: missing or invalid option

Note that I have also added the line

MyDb.dbDBType = "ORACLE"

I looked in this forum and searched for ORACLE. It looks like others have also had Oracle problems, and ran pureASP that seemd to fix it. However, I know the DSN works fine-- it connects with another application that I wrote using standard ADO and sql.

The same exact code works fine for my access database. (It is connecting to the Oracle database, but it looks like it is parsing the SQL in a non-Oracle friendly way).

Thanks!

Greg