Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Syntax error or access violation in ASP

Re: Syntax error or access violation in ASP

From: Darth Mike <xxdarth_mikexx_at_hotmail.com>
Date: Fri, 19 Jan 2001 22:30:04 -0000
Message-ID: <t6hfvc8cft8e75@corp.supernews.com>

I noticed that when you form the sSQL variable that you omitted a space in the second line so sSQL would be interpreted as :

     SELECT firstName, lastNameFROM displayTable

That is probably the source of the error.

newguysanfran wrote:
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC driver for Oracle]Syntax error or access violation
>
> /Lester/reciever.asp, line 12
> ============================================================
> from this code:
>
> 'DSN-less Connection
> sConnStr = "Driver=Microsoft ODBC for
> Oracle;Server=serverName;UID=SYS;PWD=change_on_install"
>
> 'Create and Open Connection Object
> Set oADOConn = Server.CreateObject("ADODB.Connection")
> oADOConn.Open sConnStr
>
> sSQL = "SELECT firstName, lastName"
> sSQL = sSQL & "FROM displayTable"
>
> Set rsADRS1 = oADOConn.Execute(sSQL)
> ========================================================
>
> I can access the Database through toad on this machine. The tnsnames
> is definitely setup. I'm not sure why I get an access violation. The
> sql statement works when run through toad? Any idea's. I'm just trying
> to get this set up on this machine. It's 8.1.5 personal edition. Does
> this affect it in some way?
>
> Regards,
> Bryan
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/

--
Posted via CNET Help.com
http://www.help.com/
Received on Fri Jan 19 2001 - 16:30:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US