Error Connecting to database on SQL Server

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

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

Edited by metro - 18 March 2006 at 12:45am