-
ORACLE error
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|