What`s wrong with my code ? Simple one.

[Nghi Nguyen]

Hi,
I`m a newbie to ASP-db. I have a very simple code to access my oracle db and an error msg that I couldn`t understand.
Could someone show me what`s wrong with it ?
<%
Set MyDB=Server.CreateObject("ASPdb.Pro")
MyDB.dbDSN="DSN=OracleTest;UID=Test;PWD=test"
MyDB.dbColor = "7,auto"
MyDB.dbMode = "dual"
MyDB.dbGridTableTag = "border=3 cellspacing=3 cellpadding=3"
response.write "test"
MyDB.dbSQL="SELECT * FROM test_table"
MyDB.ASPdbPro %>
And error is:
Microsoft OLE DB Provider for ODBC Drivers error `80040e14`

[Microsoft][ODBC driver for Oracle][Oracle]ORA-00923: FROM keyword not found where expected

Thank you very much,
Nghi Nguyen

[Frank]

Nghi,

Most likely the trouble is in this line -

MyDB.dbDSN="DSN=OracleTest;UID=Test;PWD=test"

To solve the problem, put this DSN in the Pure.asp program that comes with your download. If you do not have it goto the aspdb.com website to get it or call support to get a copy. The program is written specify for this purpose. There might be security requirements in ORACLE which involves executing the silent command property to clear that. Anyway, you must clear the ODBC data source syntax.

Finally, a quick try ->

MyDB.dbDSN="OracleTest;UID=Test;PWD=test"

where OracleTest is the system DSN name.


Frank

On 10/14/98 3:17:50 PM, Nghi Nguyen wrote:
> Hi,
I`m a newbie to ASP-db. I have a very simple code to access my oracle
> db and an error msg that I couldn`t understand.
Could someone show me
> what`s wrong with it ?
<%
Set
> MyDB=Server.CreateObject("ASPdb.Pro")
MyDB.dbDSN="DSN=OracleTest;UID=Test;P
> WD=test"
MyDB.dbColor = "7,auto"
MyDB.dbMode =
> "dual"
MyDB.dbGridTableTag = "border=3 cellspacing=3
> cellpadding=3"
response.write "test"
MyDB.dbSQL="SELECT * FROM
> test_table"
MyDB.ASPdbPro %>
And error is:
Microsoft OLE DB Provider for
> ODBC Drivers error `80040e14`

[Microsoft][ODBC driver for
> Oracle][Oracle]ORA-00923: FROM keyword not found where expected

Thank
> you very much,
Nghi Nguyen

[Nghi Nguyen]

Frank,
I`ve tried but still fail. I don`t think my odbc has problem since these works fine.
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "DSN=OracleTest;UID=Test;PWD=test
Set oRs = Server.CreateObject("ADODB.Recordset")
oRs.Open "SELECT * FROM test.test_table ", oConn, adOpenStatic"
Regards,
Nghi

On 10/14/98 8:10:35 PM, Frank wrote:
> Nghi,

Most likely the trouble is in this line
> -

MyDB.dbDSN="DSN=OracleTest;UID=Test;PWD=test"

To solve the problem,
> put this DSN in the Pure.asp program that comes with your download. If you
> do not have it goto the aspdb.com website to get it or call support to get
> a copy. The program is written specify for this purpose. There might be
> security requirements in ORACLE which involves executing the silent command
> property to clear that. Anyway, you must clear the ODBC data source syntax.
>

Finally, a quick try ->


> MyDB.dbDSN="OracleTest;UID=Test;PWD=test"

where OracleTest is the system
> DSN name.


Frank

On 10/14/98 3:17:50 PM, Nghi Nguyen wrote:
>
> Hi,
I`m a newbie to ASP-db. I have a very simple code to access my oracle
>
> db and an error msg that I couldn`t understand.
Could someone show me
>
> what`s wrong with it ?
<%
Set
>
> MyDB=Server.CreateObject("ASPdb.Pro")
MyDB.dbDSN="DSN=OracleTest;UID=Test;P
>
> WD=test"
MyDB.dbColor = "7,auto"
MyDB.dbMode =
>
> "dual"
MyDB.dbGridTableTag = "border=3 cellspacing=3
>
> cellpadding=3"
response.write "test"
MyDB.dbSQL="SELECT * FROM
>
> test_table"
MyDB.ASPdbPro %>
And error is:
Microsoft OLE DB Provider for
>
> ODBC Drivers error `80040e14`

[Microsoft][ODBC driver for
>
> Oracle][Oracle]ORA-00923: FROM keyword not found where expected

Thank
>
> you very much,
Nghi Nguyen