asp_web_howto thread: ODBC error '80040e14'
Message #1 by "Masoud Samimi" <samimi73@y...> on Sat, 25 Aug 2001 19:27:51
|
|
Hi,
This is my sql syntax:
sql = "execute sp_AddClient '" & _
chrFirstName & "', '" & _
chrLastName & "', '" & _
chrCompany & "', '" & _
chrCity & "', '" & _
chrAddress & "', '" & _
chrActivity & "', '" & _
chrWebURL & "', '" & _
chrPhone & "', '" & _
chrFax & "', '" & _
chrZipCode & "', '" & _
chrEmail & "', '" & _
chrPassword & "', '" & _
chrProvince & "', '" & _
chrCountry & "', '" & _
chrActivity & "', '" & _
chrRequest & "', '" & _
chrContacts & "', '" & _
chrTelOne & "', '" & _
chrTelTwo & "', '" & _
chrTelThree & "', '" & _
chrFaxOne & "', '" & _
chrFaxTwo & "', '" & _
chrFaxThree & "', '" & _
chrTelOneExt & "', '" & _
chrTelTwoExt & "', '" & _
chrTelThreeExt & "', " & _
intHaveWebY & ", " & _
intLocalYN & ", " & _
intAddMeYN
I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near ','.
/twcb/emailapplication.asp, line 143
And the line 143 code is:
set rsClients = dbClients.Execute(sql)
Please, any ideas what's wrong?
Cheers,
Masoud
Message #2 by "Monique Angelich" <mangelich@m...> on Sat, 25 Aug 2001 19:27:17 -0400
|
|
Before executing your SQL, do a response.write(sql) and write it to the
screen, when assembled you will easily be able to see the error, if not,
send teh final sql here and I will look at it for you.
Moe
----- Original Message -----
From: "Masoud Samimi" <samimi73@y...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Saturday, August 25, 2001 7:27 PM
Subject: [asp_web_howto] ODBC error '80040e14'
> Hi,
>
> This is my sql syntax:
>
>
> sql = "execute sp_AddClient '" & _
> chrFirstName & "', '" & _
> chrLastName & "', '" & _
> chrCompany & "', '" & _
> chrCity & "', '" & _
> chrAddress & "', '" & _
> chrActivity & "', '" & _
> chrWebURL & "', '" & _
> chrPhone & "', '" & _
> chrFax & "', '" & _
> chrZipCode & "', '" & _
> chrEmail & "', '" & _
> chrPassword & "', '" & _
> chrProvince & "', '" & _
> chrCountry & "', '" & _
> chrActivity & "', '" & _
> chrRequest & "', '" & _
> chrContacts & "', '" & _
> chrTelOne & "', '" & _
> chrTelTwo & "', '" & _
> chrTelThree & "', '" & _
> chrFaxOne & "', '" & _
> chrFaxTwo & "', '" & _
> chrFaxThree & "', '" & _
> chrTelOneExt & "', '" & _
> chrTelTwoExt & "', '" & _
> chrTelThreeExt & "', " & _
> intHaveWebY & ", " & _
> intLocalYN & ", " & _
> intAddMeYN
>
>
>
> I get this error:
>
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
> near ','.
>
> /twcb/emailapplication.asp, line 143
>
>
> And the line 143 code is:
>
> set rsClients = dbClients.Execute(sql)
>
>
> Please, any ideas what's wrong?
Message #3 by "Masoud Samimi" <samimi73@y...> on Sun, 26 Aug 2001 06:56:08
|
|
Hi Monique,
Thank you very much. :)
The Response.Write made it so clear. I was passing two wrong parameters
to the SP, but the error message was not helpful! :(
Cheers,
Masoud
|
View Cart
