| Author |
 Topic Search  Topic Options
|
LER2001 
Newbie
Joined: 15 December 2006
Location: Denmark
Status: Offline
Points: 6
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 15 December 2006 at 4:01pm |
I have just accesed the database via phpmyadmin and there are no tables. There is one database (with same name as my username - the name I called "aaa" before) and the db is empty.
I am - apperently - not allowed to create another database.
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 December 2006 at 5:01pm |
|
You don't have to create a database...you have to create tables in your database you already have. Specify that aaa database in the file and it should create the tables just fine... Is this mssql or mySQL?
|
|
|
|
LER2001
Newbie
Joined: 15 December 2006
Location: Denmark
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 December 2006 at 5:35pm |
 michael wrote:
You don't have to create a database...you have to create tables in your database you already have. Specify that aaa database in the file and it should create the tables just fine... Is this mssql or mySQL? |
It turns out that I had that mixed up.
I have just installed the mySQL version instead, since that is what my ISP provides.
-But I still get stuck at the same point.
mySQL_server_setup.asp wrote:
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.
|
If I remove errortrapping from the mySQL_server_setup.asp I get the following:
Modified-mySQL_server_setup.asp wrote:
ADODB.Connection.1 error '80004005'
SQLState: S Native Error Code: 1045 [TCX][MyODBC]Access denied for user: 'root@localhost' (Using password: YES)
/forum/mySQL_server_setup.asp, line 208
|
I think that this is the line that fails:
strCon = "Driver={MySQL ODBC 3.51 Driver};Server=" & strSQLServerName & ";User=" & strUsername & ";Password=" & Request.Form("password") & ";Database=" & strSQLDBName & ";Port=3306;Option=3;"
It seems like a problem with rights. I will try to contact my ISP via mail, and see if they can help.
-The ISP-Livechat was of no help 
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 December 2006 at 3:04am |
|
You might also check to see if your MySQL version is at least 4.1
|
Lead me not into temptation... I know the short cut, follow me.
|
|
LER2001
Newbie
Joined: 15 December 2006
Location: Denmark
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 December 2006 at 8:54am |
I am pretty sure, that I have located the problem:
I misspelled my username while trying to log into phpMyAdmin (the web-client for MySQL) and I got this message:
This (in connection with the error I got when running mySQL_server_setup.asp) indicates, that I do not have the password for root@localhost
The question is, how do I make the mySQL_server_setup.asp use username@localhost as logon?
Edited by LER2001 - 16 December 2006 at 8:55am
|
|
LER2001
Newbie
Joined: 15 December 2006
Location: Denmark
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 December 2006 at 10:46am |
I am by the way able to make the setup manually with phpMyAdmin. But I need a variable:
for example:
strSQL = "CREATE TABLE " & strDbTable & "Forum ("
What is strDbTable? -What file sets it?
I suspect, that it means that the table should be called aaaForum but I dont know.
|
|
LER2001
Newbie
Joined: 15 December 2006
Location: Denmark
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 December 2006 at 2:25pm |
dpyers wrote:
You might also check to see if your MySQL version is at least 4.1 |
That was the problem 
My ISP only have version 4.0.24 
Apperently the syntax has changed for logging on. -among other things.
I edited the mySQL_server_setup.asp to comply with the older version, and I now have the database running.
But that will probardly not be the only problem I will run into.
Unless I can get an older version of webwiz it seems like my project stops here
Thanks for all your help!
...Ole
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 December 2006 at 3:37pm |
|
Older versions did not support MySQL.
V8 requires MysQL 4.1 or better as some of the queries use the newer features in that version.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
