Web Wiz Forums - Upgrade to ODBC 5.1 and win2008 server

Print Page | Close Window

Upgrade to ODBC 5.1 and win2008 server

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=29092
Printed Date: 01 April 2026 at 4:05pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upgrade to ODBC 5.1 and win2008 server

Posted By: Jesper kick
Subject: Upgrade to ODBC 5.1 and win2008 server
Date Posted: 30 January 2011 at 1:40pm

My ISP wants to upgrade the web server to a win 2008 server on my homepage tenere.dk
I'm therefore testing the homepage on a new server.

Most of my forum works fine in test, but when creating a new post (

Replies:

Posted By: Jesper kick
Date Posted: 01 February 2011 at 6:07am

I think the problem is related to the ODBC driver upgrade and the definition of the field "message" as "text" in the database tblthread. What is the correct definition of that field?
The upgrade of ODBC is from 3.5.1 to 5.1.

I have tried to install a new brand ny version 9.7 of the forum, to see the field definition, but that gives my a a lot of other problems, so I would be very happy, I someone could help me?

Kind regards
Jesper Kick Denmark

Posted By: WebWiz-Bruce
Date Posted: 01 February 2011 at 1:57pm

Since 2008 Web Wiz Forums has been developed on Windows 2008 64 bit, so the setup you have is the recommend setup for the mySQL version.

As you are having to change the driver from 'MySQL ODBC 3.51' Driver to 'MySQL' it means that the myODBC 5.1 driver has not been installed or not correctly installed on the server.

By changing it to the 'MySQL' driver it means that you are not using the myODBC 5.1 driver for mySQL and instead using an old generic driver which is not supported and will give errors.

You need to contact your web hosts and inform them that their is an issue with the installation of the myODBC 5.1 driver.

You also need to make sure that the app pool for your website is running in 32 bit mode as this is the recommend settings that Microsoft gives as it gives improved compatibility, performance, and memory management.

-------------
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: Jesper kick
Date Posted: 03 February 2011 at 8:02pm

Hi Bruce
Thanks for you reply.
I think that you are right about the ODBC 5.1 driver and are having a long dialog with the support team at my ISP.
The app pool is running in 32 bit.
I have another MySQL/ASP application running on the same server with no problems. Do you have any idea, why my application is running and not all of the forum. The connection parameters are the same? Both apps works perfect on an windows2000 server with ODBC 3.51?
Kind regards
Jesper Ahlers

Posted By: WebWiz-Bruce
Date Posted: 04 February 2011 at 6:40pm

You need to have installed either the myODBC Driver 3.51 or 5.1 installed on the server.

If you install the x64 version it will install both 32bit and 64bit versions. You can also run myODBC Driver 3.51 and 5.1 side by side on the same server. When you set the driver you simply put in what version of the myODBC driver you want to use.

Without the myODBC Driver 3.51 or 5.1 driver installed on the server the forum will not run and you will get error like you are experiencing.

Posted By: Jesper kick
Date Posted: 05 February 2011 at 3:15pm

You are absolutely correct. There is some kind of error on the myODBC 5.1 driver on my my homepages server, but I got them to install a 3.51, and now is everything working perfect again.

Thanks a lot

Jesper Kick Denmark