Print Page | Close Window

Error en 7.96

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17206
Printed Date: 15 April 2026 at 11:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Error en 7.96
Posted By: julianml
Subject: Error en 7.96
Date 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


-------------
Sin problemas



Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 November 2005 at 1:49pm
Could you please trasnlate this error?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: julianml
Date Posted: 10 November 2005 at 2:08pm
Originally posted by -boRg- -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


-------------
Sin problemas


Posted By: julianml
Date 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.



-------------
Sin problemas


Posted By: dj air
Date 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.


Posted By: Ferry
Date 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,",",".")


Posted By: WebWiz-Bruce
Date 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?


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: Ferry
Date 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


Posted By: WebWiz-Bruce
Date Posted: 14 November 2005 at 4:08am
Thanks Ferry, I'll look into it, maybe just removing the stored procedure and running SQL would help, but I'm think I'm going to spend more time looking at trying to pass an international date/time parameter. Sould also help for the mySQL version I'm working on.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net