Re: Syntax error or access violation in ASP

From: M Mulqueen <mmulqueen_at_teach.com>
Date: Wed, 31 Jan 2001 21:30:12 -0000
Message-ID: <t7h0v4c4q36g2b@corp.supernews.com>

jocave wrote:
>
>
> In article <948sbl$s15$1_at_nnrp1.deja.com>,
> newguysanfran_at_my-deja.com 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)
>
> This code appears not to put a space between "lastName" and "FROM",
> which would lead to an invalid SQL statement.
>
> > ========================================================
> >
> > 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/
> >
>
>
> Sent via Deja.com
> http://www.deja.com/

Okay, I understand that one, but I have one that throws the same error. I commented out all the extra code and only have:

CREATE OR REPLACE PROCEDURE sp_ins_user_short_reg(

user_id 	VARCHAR2 ,
first_name 	VARCHAR2 ,
middle_initial 	VARCHAR2 ,
last_name 	VARCHAR2 ,
email 	VARCHAR2 ,
password 	VARCHAR2 ,
clue 	VARCHAR2 ,
mailing_list 	VARCHAR2 ,
serial_number 	VARCHAR2 ,
RC1 	IN OUT globalPkg.RCT1)
AS
StoO_selcnt	INTEGER;
StoO_error 	INTEGER;
StoO_rowcnt	INTEGER;
StoO_crowcnt	INTEGER := 0;
StoO_fetchstatus	INTEGER := 0;
StoO_errmsg	VARCHAR2(255);
StoO_sqlstatus	INTEGER;
user_rec 	NUMBER(10,0);
org_rec 	NUMBER(10,0);
BEGIN
	begin
		 	OPEN RC1 FOR
				 SELECT  9999 "user_rec"
				 FROM DUAL;

end;
END sp_ins_user_short_reg;
/

called using :

{call sp_ins_user ('m1','m','m','m','m','m','CO','88888',' ',' ','m_at_m.com',' ','mcm','mcm','Y','m','TE005EP')};         

Can you help?

Thanks,

MCM

--
Posted via CNET Help.com
http://www.help.com/

Received on Wed Jan 31 2001 - 15:30:12 CST