MSSQL Error
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=19950
Printed Date: 11 April 2026 at 5:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MSSQL Error
Posted By: Heath
Subject: MSSQL Error
Date Posted: 19 May 2006 at 5:02pm
|
Hi guys...
Sorry, I'm sure this is a simple thing, but I can't seem to figure it out. I've just installed the software... I'm running MSSQL Server 2000 with MDAC 2.6. I keep getting this error when I try to browse to the forums:
Server Error in Forum Application
An error has occured while executing SQL query on database. Please contact the forum administrator. Support Error Code:- err_SQLServer_get_last_USR_+_count File Name:- default.asp Error details:- Microsoft OLE DB Provider for SQL Server Line 1: Incorrect syntax near '1'. Any ideas?
Thanks -
----- Heath
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 19 May 2006 at 6:42pm
|
It could be a corruted file. Try reuploaidng the files again.
------------- 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: Heath
Date Posted: 19 May 2006 at 7:15pm
|
Thanks for the reply!
 Hmm... I've tried re-uploading and no luck. I downloaded the files again and tried again with a fresh set of files. Same error...
 Any other ideas?
|
Posted By: WebWiz-Bruce
Date Posted: 20 May 2006 at 9:34am
|
This is very odd as no-one else seems to be having an issue with the SQL query that is throwing the error on SQL 2000, I even tested it myself countless times without issue. The only thing I can think is that some strange setup on your SQL Server is coursing the problem, or a corruption of some kind in your MDAC Drivers. Try first installing the latest MDAC Drivers on the server and see if that resolves the issue. ------------- 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 |