Upgrade to ODBC 5.1 and win2008 server

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Jesper kick Members Profile Find Members Posts Newbie Joined: 10 December 2007 Status: Offline Points: 21	Post Options Post Reply Quote Jesper kick Report Post Thanks(0) Quote Reply Topic: Upgrade to ODBC 5.1 and win2008 server 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 (

Jesper kick Members Profile Find Members Posts Newbie Joined: 10 December 2007 Status: Offline Points: 21	Post Options Post Reply Quote Jesper kick Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Jesper kick Members Profile Find Members Posts Newbie Joined: 10 December 2007 Status: Offline Points: 21	Post Options Post Reply Quote Jesper kick Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Jesper kick Members Profile Find Members Posts Newbie Joined: 10 December 2007 Status: Offline Points: 21	Post Options Post Reply Quote Jesper kick Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum