Web Wiz Forums - database_connection.asp details

Print Page | Close Window

database_connection.asp details

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

Topic: database_connection.asp details

Posted By: adamsmith
Subject: database_connection.asp details
Date 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

Replies:

Posted By: WebWiz-Bruce
Date 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.

Posted By: adamsmith
Date 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

Posted By: WebWiz-Bruce
Date 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.

Posted By: WebWiz-Bruce
Date Posted: 16 April 2006 at 6:20pm

Try using version 8.01 and see if that sorts out any issues you may have.

Posted By: adamsmith
Date Posted: 17 April 2006 at 1:56pm

Thanks for your assistance

Adam