Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - database_connection.asp details
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

database_connection.asp details

 Post Reply Post Reply
Author
adamsmith View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Location: Australia
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote adamsmith Quote  Post ReplyReply Direct Link To This Post Topic: database_connection.asp details
    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

 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
adamsmith View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Location: Australia
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote adamsmith Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 16 April 2006 at 6:20pm
Try using version 8.01 and see if that sorts out any issues you may have.
Back to Top
adamsmith View Drop Down
Newbie
Newbie


Joined: 16 April 2006
Location: Australia
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote adamsmith Quote  Post ReplyReply Direct Link To This Post Posted: 17 April 2006 at 1:56pm
Thanks for your assistance
 
Adam
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.