forum can't log into the database

Post Reply

Page <123 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
billiam777 Members Profile Find Members Posts Newbie Joined: 06 January 2012 Status: Offline Points: 25	Post Options Post Reply Quote billiam777 Report Post Thanks(0) Quote Reply Posted: 21 August 2012 at 3:48pm
	Originally when I installed it last year it installed fine. Then it stopped working on that server. I had to move the site to a new server anyway so I did that and it doesn't work on the new one either. I also tried upgrading to version 10.11 and the upgrade wouldn't work because it gave the same error. I'm using a Windows 2008 R2 server now with IIS 7.5

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: 21 August 2012 at 4:07pm
	It is a very strange error message that you are getting, normally there would be more information. I would suggest reinstalling the latest myODBC 3.51 driver on the server, if that does not work install the myODBC 5.1 driver and run the install/setup wizard again to make sure the database is up to date and using the correct driver. To have the install/setup wizard run update the files in the 'database' folder with the original files from the download from our website. Another thing to check is that you are running the websites application pool that the forum is running in, in 32bit mode. Many drivers and other ASP components do not work in 64bit mode.
	Web Wiz Forums Hosting ASP.NET Web Hosting

billiam777 Members Profile Find Members Posts Newbie Joined: 06 January 2012 Status: Offline Points: 25	Post Options Post Reply Quote billiam777 Report Post Thanks(0) Quote Reply Posted: 21 August 2012 at 7:10pm
	I can't change the application pool to 32 bit mode because when I do .asp files don't work at all. Plesk has already looked at it and determined it must be running in 64 bit mode. Although I did try this and sure enough the asp code didn't run. I have tried both myODBC 3.51 and 5.1 drivers and while the plesk panel says they work and can connect they don't in web wiz for some reason. I noticed in my database_settings.asp it has this line uncommented: strDatabaseType = "mySQL" 'MySQL 4.1 or MySQL 5.x and this one too: strDbPathAndName = Server.MapPath("databasewwForum.mdb") 'This is the path of the database from the applications location Does this matter?

billiam777 Members Profile Find Members Posts Newbie Joined: 06 January 2012 Status: Offline Points: 25	Post Options Post Reply Quote billiam777 Report Post Thanks(0) Quote Reply Posted: 21 August 2012 at 7:11pm
	I also have this setting in my database_settings.asp strSQLServerName = "localhost" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

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: 21 August 2012 at 8:00pm
	Web Wiz Forums needs to run in a 32bit mode application pool. As you are using 64bit application pools then this is why it is not running. Classic ASP will run when the application pool is in 32bit mode. If it is not running in 32bit mode then there is an issue with your server that needs fixing. Microsoft recommend that you run app pools in 32bit mode as you get better performance and memory management. We host many thousands of websites on our servers that run Classic ASP, ASP.NET and PHP and all websites run in 32bit application pools.
	Web Wiz Forums Hosting ASP.NET Web Hosting

billiam777 Members Profile Find Members Posts Newbie Joined: 06 January 2012 Status: Offline Points: 25	Post Options Post Reply Quote billiam777 Report Post Thanks(0) Quote Reply Posted: 21 August 2012 at 8:09pm
	If I go into the plesk(default)(2.0)(pool) and change "Enable 32-bit applications" to "true", then run the forums I get this error. 500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed.

billiam777 Members Profile Find Members Posts Newbie Joined: 06 January 2012 Status: Offline Points: 25	Post Options Post Reply Quote billiam777 Report Post Thanks(0) Quote Reply Posted: 21 August 2012 at 8:25pm
	I just tried a test_mysql.asp page and it was able to connect to mysql with asp. I will try creating a new application pool

billiam777 Members Profile Find Members Posts Newbie Joined: 06 January 2012 Status: Offline Points: 25	Post Options Post Reply Quote billiam777 Report Post Thanks(0) Quote Reply Posted: 21 August 2012 at 8:40pm
	Creating a new application pool for this with 32-bit causes asp to not work at all....grrr.... Ok I'm going to see if plesk can fix the environment so this will run.

Post Reply	Page <123 >

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

forum can't log into the database

500 - Internal server error.

There is a problem with the resource you are looking for, and it cannot be displayed.