Web Wiz Support and Community Forums : MSSQL Error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 19:11:46 +0000 Sat, 20 May 2006 09:34:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19950 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MSSQL Error : This is very odd as no-one else...]]> https://forums.webwiz.net/mssql-error_topic19950_post107404.html#107404 Author: WebWiz-Bruce
Subject: 19950
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.
]]> Sat, 20 May 2006 09:34:14 +0000 https://forums.webwiz.net/mssql-error_topic19950_post107404.html#107404 <![CDATA[MSSQL Error : Thanks for the reply! Hmm......]]> https://forums.webwiz.net/mssql-error_topic19950_post107374.html#107374 Author: Heath
Subject: 19950
Posted: 19 May 2006 at 7:15pm

Thanks for the reply!  Smile
 
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... Ouch
 
Any other ideas?
]]> Fri, 19 May 2006 19:15:35 +0000 https://forums.webwiz.net/mssql-error_topic19950_post107374.html#107374 <![CDATA[MSSQL Error : It could be a corruted file. Try...]]> https://forums.webwiz.net/mssql-error_topic19950_post107369.html#107369 Author: WebWiz-Bruce
Subject: 19950
Posted: 19 May 2006 at 6:42pm

It could be a corruted file. Try reuploaidng the files again.]]> Fri, 19 May 2006 18:42:22 +0000 https://forums.webwiz.net/mssql-error_topic19950_post107369.html#107369 <![CDATA[MSSQL Error : Hi guys... Sorry, I&#039;m...]]> https://forums.webwiz.net/mssql-error_topic19950_post107357.html#107357 Author: Heath
Subject: 19950
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
]]> Fri, 19 May 2006 17:02:52 +0000 https://forums.webwiz.net/mssql-error_topic19950_post107357.html#107357