Newbie can't get it going! HELP

[John L.]

I'm trying to set up a filter start on MyDB. I started off with the example scirpt from 11c and changed everything that needed it to point to my new DSN and SQL.
When the script gets to the end there is a line giving this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Oracle][ODBC][Rdb]%SQL-F-SYNTAX_ERR, Syntax error

/crytech/aspdb/COC1.ASP, line 54

The line is:
MyDb.ASPdbPRO

Can anyone help? This should be an easy one.
Oh ya, I'm still working on the Eval copy, waiting for ASPdbView package to arrive.

Thanks much

[John L.]

OK what is the deal with this line? Every script I run, crashes there!

------------
John L. at 11/4/99 4:25:28 PM

I'm trying to set up a filter start on MyDB. I started off with the example scirpt from 11c and changed everything that needed it to point to my new DSN and SQL.
When the script gets to the end there is a line giving this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Oracle][ODBC][Rdb]%SQL-F-SYNTAX_ERR, Syntax error

/crytech/aspdb/COC1.ASP, line 54

The line is:
MyDb.ASPdbPRO

Can anyone help? This should be an easy one.
Oh ya, I'm still working on the Eval copy, waiting for ASPdbView package to arrive.

Thanks much

[Per Haglund]

wow...I think I know the answer to this!

try to change:
MyDb.ASPdbPRO
to
MyDb.ASPdbFree
because, since u said you we´re a newbie(like me) I don´t think that u have bought the
PRO-version yet?

------------
John L. at 11/4/99 4:46:43 PM

OK what is the deal with this line? Every script I run, crashes there!

------------
John L. at 11/4/99 4:25:28 PM

I'm trying to set up a filter start on MyDB. I started off with the example scirpt from 11c and changed everything that needed it to point to my new DSN and SQL.
When the script gets to the end there is a line giving this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Oracle][ODBC][Rdb]%SQL-F-SYNTAX_ERR, Syntax error

/crytech/aspdb/COC1.ASP, line 54

The line is:
MyDb.ASPdbPRO

Can anyone help? This should be an easy one.
Oh ya, I'm still working on the Eval copy, waiting for ASPdbView package to arrive.

Thanks much

[Mark]

John,

If you are trying to read an ORACLE database, you MUST include the line:

Mydb.dbDBType = "Oracle"

that should fix it.

Also, do NOT use Oracle's odbc driver, use microsoft's.

Mark.

[John L.]

Now it gives this error:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'MyDb.ASPdbFree'

/crytech/aspdb/coc6.asp, line 56

Thanks much

[Mark]

John,

If you are still having a problem, please email me directly. I need to
see your ENTIRE source code and the ENTIRE error msg that you are getting.
Before sending me your source code (asp file), please STRIP it down
to the ABSOLUTE SHORTEST SIMPLEST program that still demonstrates the error.
Try to get it down to 5 or 6 lines of code.
Thanks.

Mark.
mark@majormicro.com

[John L.]

The line I was looking for was found in the asp-test-pro.asp file. It was:
MyDb.aspDBPro

Thanks anyways!


------------
Per Haglund at 11/5/99 4:18:57 AM


wow...I think I know the answer to this!

try to change:
MyDb.ASPdbPRO
to
MyDb.ASPdbFree
because, since u said you we´re a newbie(like me) I don´t think that u have bought the
PRO-version yet?

------------
John L. at 11/4/99 4:46:43 PM

OK what is the deal with this line? Every script I run, crashes there!

------------
John L. at 11/4/99 4:25:28 PM

I'm trying to set up a filter start on MyDB. I started off with the example scirpt from 11c and changed everything that needed it to point to my new DSN and SQL.
When the script gets to the end there is a line giving this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Oracle][ODBC][Rdb]%SQL-F-SYNTAX_ERR, Syntax error

/crytech/aspdb/COC1.ASP, line 54

The line is:
MyDb.ASPdbPRO

Can anyone help? This should be an easy one.
Oh ya, I'm still working on the Eval copy, waiting for ASPdbView package to arrive.

Thanks much