Web Wiz Forums - newbie problem installing

newbie problem installing

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=22253
Printed Date: 08 April 2026 at 10:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: newbie problem installing

Posted By: ninjaxryder
Subject: newbie problem installing
Date Posted: 22 December 2006 at 9:50pm

hi...ive trying to install this forum now for days and still cannot get it to work..this is what i did...

These are not my actually user & pw ...just examples...
Host: mysql241.test.net

Database: abcd
User abcd
Password: 1234

'Enter the details of your Microsoft SQL Server or MySQL Server and database below
'*********************************************************************************

strSQLServerName = "mysql241.test.net" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "abcd" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "1234" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "abcd" 'Holds the name of the database

'Initilise the DB Connection String
strCon = "Server=mysql241.test.net" & strSQLServerName & ";User ID=abcd" & strSQLDBUserName & ";Password=1234" & strSQLDBPassword & ";Database=abcd" & strSQLDBName & ";"
End If

that is how i inputed in my database_connection.asp...

then when i went to msSQL_server_setup.asp it give me three things to put in....

SQL Server Username: abcd

SQL Server Password: 1234

SQL Server Username for creating tables: abcd

and get this message...

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 'database_connection.asp' found in the 'database' directory.

what am i doing wrong?!!? please help....thanks

Replies:

Posted By: Melkor
Date Posted: 23 December 2006 at 12:05am

You don't enter the details in the connection string, just where the strings are assigned values;

 strSQLServerName = "mysql241.test.net" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
 strSQLDBUserName = "abcd" 'Holds the user name (for SQL Server Authentication)
 strSQLDBPassword = "abcd" 'Holds the password (for SQL Server Authentication)
 strSQLDBName = "1234"  'Holds the name of the database
 
 
 'Initilise the DB Connection String
 strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
End If

Posted By: Mikey
Date Posted: 23 December 2006 at 3:28am

ninjaxryder wrote:

Thats correct, leave that as it is, also your host may supply a ip address to connect to your MySQL so try that and also try 'localhost'
My host supplies a full domain to connect to my MySQL but it never works where as the simple 'localhost' way does

-------------
Handyman man?