Web Wiz Forums - Problems conncting MySQL

Print Page | Close Window

Problems conncting MySQL

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=20248
Printed Date: 11 April 2026 at 1:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problems conncting MySQL

Posted By: lydbury
Subject: Problems conncting MySQL
Date Posted: 09 June 2006 at 4:14pm

I have been running the access version for years and years - but now have MySQL available. So I am quite new to MySQL. Am using PHPMyAdmin. All this is on a remote server. PHPMYAdmin is setting up an empty database fine. I have edited the database_connection.asp file. Now I am trying to use mySQL-server_setup.asp and that is where I start getting problems.

In brief:

I have made an empty database named grammar.

I have set up:

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

in the database_connection.asp

Then I go to http://www.lydbury.co.uk/grammar/mySQL_server_setup.asp - mySQL_server_setup.asp and enter the username and password and I get:

Error Connecting to database on mySQL Server

Check the following is set up and correct:-

mySQL Server User Name
mySQL Server Password
Name of the mySQL Server
Database name set up by you on the server
Empty Database set up by you on the mySQL Server

Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.

Can't see what I have done wrong. Grateful for any ideas you might have

Duncan

Replies:

Posted By: WebWiz-Bruce
Date Posted: 09 June 2006 at 4:23pm

Make sure the details of the mySQL database are entered correctly.

Check with your web hosts you can use 'loclahost' to connect to the server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: angel
Date Posted: 09 June 2006 at 5:14pm

he did not changed the name of the server to his own server and the db name to his own.

-------------
soon

Posted By: lydbury
Date Posted: 09 June 2006 at 6:13pm

localhost was the name given me by the ISP. And I did change the dbName to "grammar".

But I am checking with the ISP. All thoughts most welcome.

Posted By: lydbury
Date Posted: 09 June 2006 at 9:50pm

The ISP says:

You can connect to localhost (the fact phpMyAdmin can proves that).

Looking at your server the database also looks OK.

My database_connection.asp file seems fine - so I am totally confused. The ISP is looking at my files but I would still be very grateful for any thoughts.

Duncan

Posted By: lydbury
Date Posted: 10 June 2006 at 6:08pm

Now working fine - ISP uninstalled and reinstalled the ODBC drivers. Sorted.

Duncan