Error Connecting to database on SQL 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=18766
Printed Date: 12 April 2026 at 10:15pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error Connecting to database on SQL Server
Posted By: metro
Subject: Error Connecting to database on SQL Server
Date Posted: 18 March 2006 at 12:26am
In the past I only setup php forums so know the basics but that was
unix - but now have a site at godady and they have windows and
ASP.
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 have
a 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
|
Replies:
Posted By: WebWiz-Bruce
Date 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 well
clear of GoDaddy as from feedback on this forum it is one windows web
host worth avoiding
|
Posted By: metro
Date Posted: 18 March 2006 at 3:23pm
Thanks for your reply as I did not know about mySQL vs SQL. I have
several sites on iPowerWeb and they are Unix but they are at $90/year
and on a couple of new sites I noticed that godaddy cost only $30/yr
using Windows
I now looked back at iPower and they also use mySQL as do many hosts as
I am looking. Seems to me to be a good host they all should keep
current 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.
|
Posted By: WebWiz-Bruce
Date 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.
|
|