Web Wiz Support and Community Forums : database_connection.asp details https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 07:59:47 +0000 Mon, 17 Apr 2006 13:56:19 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19340 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[database_connection.asp details : Thanks for your assistance Adam...]]> https://forums.webwiz.net/database-connection-asp-details_topic19340_post104591.html#104591 Author: adamsmith
Subject: 19340
Posted: 17 April 2006 at 1:56pm

Thanks for your assistance
 
Adam
]]> Mon, 17 Apr 2006 13:56:19 +0000 https://forums.webwiz.net/database-connection-asp-details_topic19340_post104591.html#104591 <![CDATA[database_connection.asp details : Try using version 8.01 and see...]]> https://forums.webwiz.net/database-connection-asp-details_topic19340_post104525.html#104525 Author: WebWiz-Bruce
Subject: 19340
Posted: 16 April 2006 at 6:20pm

Try using version 8.01 and see if that sorts out any issues you may have.]]> Sun, 16 Apr 2006 18:20:58 +0000 https://forums.webwiz.net/database-connection-asp-details_topic19340_post104525.html#104525 <![CDATA[database_connection.asp details : Install instructions come with...]]> https://forums.webwiz.net/database-connection-asp-details_topic19340_post104513.html#104513 Author: WebWiz-Bruce
Subject: 19340
Posted: 16 April 2006 at 5:11pm

Install instructions come with the software.

But it looks like your issues are with the setup of mySQL, you can checkout the mySQL site for help on setting up a mySQL database.
]]> Sun, 16 Apr 2006 17:11:20 +0000 https://forums.webwiz.net/database-connection-asp-details_topic19340_post104513.html#104513 <![CDATA[database_connection.asp details : Thanks for your reply - I am still...]]> https://forums.webwiz.net/database-connection-asp-details_topic19340_post104507.html#104507 Author: adamsmith
Subject: 19340
Posted: 16 April 2006 at 4:33pm

Thanks for your reply - I am still have issues.
 
Is there an idiots guide to set this up from start to finish?
 
Thanks again
Adam
]]> Sun, 16 Apr 2006 16:33:11 +0000 https://forums.webwiz.net/database-connection-asp-details_topic19340_post104507.html#104507 <![CDATA[database_connection.asp details : The error seems to suggest that...]]> https://forums.webwiz.net/database-connection-asp-details_topic19340_post104502.html#104502 Author: WebWiz-Bruce
Subject: 19340
Posted: 16 April 2006 at 4:02pm

The error seems to suggest that you haven't first created a blank database on mySQL to create the forums database tables etc. in.

In the database_connection.asp you don't edit the connection string file directly.

There is a place where you enter your S=mySQL server connection details:-

strSQLServerName = "" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
    strSQLDBUserName = "" 'Holds the user name (for SQL Server Authentication)
    strSQLDBPassword = "" 'Holds the password (for SQL Server Authentication)
    strSQLDBName = ""

These lines may need to be uncommented first.
]]> Sun, 16 Apr 2006 16:02:50 +0000 https://forums.webwiz.net/database-connection-asp-details_topic19340_post104502.html#104502 <![CDATA[database_connection.asp details : Sorry, new user question I...]]> https://forums.webwiz.net/database-connection-asp-details_topic19340_post104498.html#104498 Author: adamsmith
Subject: 19340
Posted: 16 April 2006 at 3:50pm

Sorry, new user question
 
I need some help setting the 'database_connection.asp'  file up as I am getting the following error when trying to create the tables on the mySQL_server_setup.asp page:


Error Creating the Table tblCategory
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblForum
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblTopic
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblThread
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblAuthor
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblPMMessage
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblBuddyList
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblConfiguration
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblDateTimeFormat
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblGroup
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblPoll
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblPollChoice
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblPollVote
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblEmailNotify
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblPermissions
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblSession
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblGuestName
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblSmut
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating the Table tblBanList
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error Creating one or more Indexs
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error entering default values in the Table tblGroup
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error entering default values in the Table tblAuthor
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error entering default values in the Table tblConfiguration
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error entering default values in the Table tblDateTimeFormat
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


Error entering default values in the Table tblSmut
[MySQL][ODBC 3.51 Driver][mysqld-5.0.20-nt]No database selected


mySQL database is set up, but with Error!

For instance if my 'mysql' database is named forum, my server address is 192.168.0.1, my username is administrator and my password is pass
 
How do I edit the  database_connection.asp file? I have tried differnet things but nothing works.
 
I am editing the following line:
 strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
 
Sorry if this is a stupid question!
 
Adam

 
]]> Sun, 16 Apr 2006 15:50:42 +0000 https://forums.webwiz.net/database-connection-asp-details_topic19340_post104498.html#104498