| Author |
 Topic Search  Topic Options
|
julianml 
Newbie
Joined: 10 November 2005
Location: Spain
Status: Offline
Points: 3
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Error en 7.96
Posted: 10 November 2005 at 1:37pm |
Información técnica (para personal de soporte técnico)
- Tipo de error:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
El parámetro número 2 y los sucesivos deben pasarse como '@nombre = valor'. Una vez usada la forma '@nombre = valor', todos los parámetros siguientes deben pasarse con esa forma.
active_topics.asp, line 312
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2005 at 1:49pm |
|
Could you please trasnlate this error?
|
|
|
|
julianml
Newbie
Joined: 10 November 2005
Location: Spain
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2005 at 2:08pm |
 -boRg- wrote:
Could you please trasnlate this error? |
Error type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The parameter number 2 and the followings must pass like ' @name= value '. One time method ' @nombre = value ' was used , all the following parameters must pass with this method.
This error appears when I trying to execute active_topics.asp in the line 312 from the main page, simply clicking button 'active topics'
Thanks in advantage
|
|
julianml
Newbie
Joined: 10 November 2005
Location: Spain
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2005 at 2:16pm |
Also I found an undefined variable error in page login_user.asp, I fixed the error. The variable is strTxtEnterCAPTCHAcode.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2005 at 3:22pm |
|
if you upgraded from a previous versin make sure you have upoaded all the edited files
also it sounds like they maybe corrupt if it is a fresh instrall try re downloading the application.
|
|
Ferry
Newbie
Joined: 29 September 2003
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2005 at 3:51pm |
I am getting the same error. The dblActiveFrom comes with a nummer and a comma (0,66666). The comma is the divider for the parameters.
Simply fixed by replacing the comma with a dot.
replace(dblActiveFrom,",",".")
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 November 2005 at 5:00am |
|
In version 7.95 which this post is about I used a (.) dot in double
numbers, this then gave an error on servers that used a (,) comma.
To resolve this issue I changed the file in 7.96 so that the number is created
by the server using CDbl(1111/12), this then means that server creates
the double number and uses the period sign that is set in the locale
settings on the server.
If you are getting this error it sounds like the locale settings on the
web server are set to use a comma (,) as the period in double numbers,
whereas the locale settings on the SQL Server are set to use a dot (.)
as the period on double numbers.
Would it be possiable to check to see if this is the case?
Edited by -boRg- - 11 November 2005 at 5:01am
|
|
|
|
Ferry
Newbie
Joined: 29 September 2003
Status: Offline
Points: 7
|
Post Options
Thanks(0)
Quote Reply
Posted: 13 November 2005 at 5:06am |
We use the standard Dutch options on the server and have a comma for double numbers 123.456.789,00.
The query string expects certain parameters seperated by a comma. So the above would generate a new parameter to the query without the @.
The parameter number 2 and the followings must pass like ' @name= value '. One time method ' @nombre = value ' was used , all the following parameters must pass with this method.
Hope this helps.
Ferry
|
|
