https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 22:17:08 +0000 Mon, 20 Mar 2006 11:00:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18766 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101755.html#101755 Author: WebWiz-Bruce
Subject: 18766
Posted: 20 March 2006 at 11:00am

The Access version of Web Wiz Forums does work on GoDaddy, if you wanted to test it out.]]> Mon, 20 Mar 2006 11:00:45 +0000 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101755.html#101755 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101644.html#101644 Author: metro
Subject: 18766
Posted: 18 March 2006 at 3:23pm

Thanks for your reply as I did not know about mySQL vs SQL. I haveseveral sites on iPowerWeb and they are Unix but they are at $90/yearand on a couple of new sites I noticed that godaddy cost only $30/yrusing Windows

I now looked back at iPower and they also use mySQL as do many hosts asI am looking. Seems to me to be a good host they all should keepcurrent on the new features...

I guess I can install another type of forum on the new account - just wanted to try this one out.

Thanks.
]]> Sat, 18 Mar 2006 15:23:25 +0000 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101644.html#101644 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101621.html#101621 Author: WebWiz-Bruce
Subject: 18766
Posted: 18 March 2006 at 10:36am

SQL Server and mySQL are two different database systems.

SQL Server is a database system produced by Microsoft and mySQL is a free open source database system.

Web Wiz Forums Version 7.x only supports SQL Server and not mySQL.

Version 8 will support mySQL, but only from mySQL version 4.1 or higher, as  understand it GoDaddy only supports a very old version of mySQL that doesn't have the required capabilities to run the mySQL version of Web Wiz Forums.

Also if you are looking for a good windows web host I would stay wellclear of GoDaddy as from feedback on this forum it is one windows webhost worth avoiding


Edited by -boRg- - 18 March 2006 at 10:37am]]> Sat, 18 Mar 2006 10:36:45 +0000 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101621.html#101621 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101586.html#101586 Author: metro
Subject: 18766
Posted: 18 March 2006 at 12:26am

In the past I only setup php forums so know the basics but that wasunix  - but now have a site at godady and they have windows andASP.

I set up a SQL database

Host Name    mysql24.secureserver.net
Database name  forum33
User name   forum33
pasword   xxxxxx

I uploaded all files to a directory (forum) I edited SQL_server_connection.asp to make the belwo changes

so I put in

'Enter the details of your SQL server below
strSQLServerName = "mysql24.secureserver.net"
strSQLDBUserName = "forum33"
strSQLDBPassword = "xxxxxx" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "forum33"     'Holds name of a database on the server

Then running msSQL_server_setup.asp

I enter my user name and password and after a while it replies:

Error Connecting to database on SQL Server

Check the following is set up and correct:-

SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server

Check also that you have entered the correct details in the file 'SQL_server_connection.asp' found in the admin directory.

-------

All of what I entered seem to be correct.

I tried by using a DSN name "mysql_forum33.dsn" in place of the server name but still did not work.

I have searched this forum adn help files and have not found what I am doing wrong.

Help would be appreciated.

Thanks

I am not sure of the version of ASP gofafy uses as I find no where but seems they would use what is required.

Also - I know that ASP does work as I am using front page and also havea form.asp that works fine for people signing up for a mailing list,,

So it is just a problem connecting to my database it seems




Edited by metro - 18 March 2006 at 12:45am]]> Sat, 18 Mar 2006 00:26:10 +0000 https://forums.webwiz.net/error-connecting-to-database-on-sql-server_topic18766_post101586.html#101586