Web Wiz Support and Community Forums : newbie problem installing https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 10:05:21 +0000 Sat, 23 Dec 2006 03:28:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22253 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[newbie problem installing : ninjaxryder wrote:&#039;Enter...]]> https://forums.webwiz.net/newbie-problem-installing_topic22253_post118615.html#118615 Author: Mikey
Subject: 22253
Posted: 23 December 2006 at 3:28am

Originally posted by ninjaxryder ninjaxryder wrote:

'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


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
]]> Sat, 23 Dec 2006 03:28:30 +0000 https://forums.webwiz.net/newbie-problem-installing_topic22253_post118615.html#118615 <![CDATA[newbie problem installing : You don&#039;t enter the details...]]> https://forums.webwiz.net/newbie-problem-installing_topic22253_post118609.html#118609 Author: Melkor
Subject: 22253
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

]]> Sat, 23 Dec 2006 00:05:19 +0000 https://forums.webwiz.net/newbie-problem-installing_topic22253_post118609.html#118609 <![CDATA[newbie problem installing : hi...ive trying to install this...]]> https://forums.webwiz.net/newbie-problem-installing_topic22253_post118603.html#118603 Author: ninjaxryder
Subject: 22253
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
]]> Fri, 22 Dec 2006 21:50:41 +0000 https://forums.webwiz.net/newbie-problem-installing_topic22253_post118603.html#118603