MySQL 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=18075
Printed Date: 13 April 2026 at 8:49am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MySQL error
Posted By: Pulver
Subject: MySQL error
Date Posted: 22 January 2006 at 9:25am
|
I got a MySQL error yesterday - but looking at the error I see that my host uses the 4.0.24 version of MySQL. So I guess thats the problem... Posting the error anyway - got this when I was trying to send a PM:
|
Microsoft OLE DB Provider for ODBC Drivers error '80004005'Replies:
Posted By: WebWiz-Bruce
Date Posted: 23 January 2006 at 2:26pm
|
There is a problem with the query on that page when using the mySQL version. I am working on fixing this for the next beta release which will have much more testing done for the mySQL version. ------------- 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: RAVALON
Date Posted: 13 February 2006 at 3:00pm
|
In MySQL could not be used boolean fields as Access....you have to use 1 or 0 value
|
Posted By: WebWiz-Bruce
Date Posted: 13 February 2006 at 3:38pm
|
The problem was in that page I had omitted the code to check for mySQL, so it was defaulting to 'True' used for the Access version. VbScript's defaults are:- True = -1 False = 0 This means that for mySQL used in Web Wiz Forums, because 'True' and 'False' are usualy set in the vbScript and the myODBC driver is often used for ADO Inserts, that Web Wiz Forums mySQL version actualy uses -1 for 'True' ------------- 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: WebWiz-Bruce
Date Posted: 13 February 2006 at 3:41pm
|
I have also been using the mySQL version as the main bases of my development for the next beta version, then testing later in Access and SQL Server. This means that in beta 2, the mySQL version will be allot more stable as most of the bugs and issues are now fixed. ------------- 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 |