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
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
Topic Options
Post Options
Thanks(0)
