Web Wiz Support and Community Forums : setup problem :( https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 13:36:19 +0000 Sun, 17 Dec 2006 15:37:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22200 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[setup problem :( : Older versions did not support...]]> https://forums.webwiz.net/setup-problem_topic22200_post118360.html#118360 Author: dpyers
Subject: 22200
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.
]]> Sun, 17 Dec 2006 15:37:12 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118360.html#118360 <![CDATA[setup problem :( : dpyers wrote:You might also...]]> https://forums.webwiz.net/setup-problem_topic22200_post118359.html#118359 Author: LER2001
Subject: 22200
Posted: 17 December 2006 at 2:25pm

Originally posted by dpyers dpyers wrote:

You might also check to see if your MySQL version is at least 4.1
That was the problem Angry
 
My ISP only have version 4.0.24 Ouch
 
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 Ouch
 
Thanks for all your help!
 
...Ole
 
 
]]> Sun, 17 Dec 2006 14:25:03 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118359.html#118359 <![CDATA[setup problem :( : I am by the way able to make the...]]> https://forums.webwiz.net/setup-problem_topic22200_post118337.html#118337 Author: LER2001
Subject: 22200
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.
 
]]> Sat, 16 Dec 2006 10:46:42 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118337.html#118337 <![CDATA[setup problem :( : I am pretty sure, that I have...]]> https://forums.webwiz.net/setup-problem_topic22200_post118336.html#118336 Author: LER2001
Subject: 22200
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:
 
#1045 - Access denied for user: '<misspelled-username>@localhost' (Using password: YES)
 
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]]> Sat, 16 Dec 2006 08:54:05 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118336.html#118336 <![CDATA[setup problem :( : You might also check to see if...]]> https://forums.webwiz.net/setup-problem_topic22200_post118335.html#118335 Author: dpyers
Subject: 22200
Posted: 16 December 2006 at 3:04am

You might also check to see if your MySQL version is at least 4.1]]> Sat, 16 Dec 2006 03:04:52 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118335.html#118335 <![CDATA[setup problem :( : michael wrote:You don&#039;t...]]> https://forums.webwiz.net/setup-problem_topic22200_post118323.html#118323 Author: LER2001
Subject: 22200
Posted: 15 December 2006 at 5:35pm

Originally posted by michael 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?
Embarrassed
 
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.
 
Originally posted by mySQL_server_setup.asp 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:
 
Originally posted by Modified-mySQL_server_setup.asp 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 helpConfused
]]> Fri, 15 Dec 2006 17:35:12 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118323.html#118323 <![CDATA[setup problem :( : You don&#039;t have to create...]]> https://forums.webwiz.net/setup-problem_topic22200_post118322.html#118322 Author: michael
Subject: 22200
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?]]> Fri, 15 Dec 2006 17:01:57 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118322.html#118322 <![CDATA[setup problem :( : I have just accesed the database...]]> https://forums.webwiz.net/setup-problem_topic22200_post118320.html#118320 Author: LER2001
Subject: 22200
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.
]]> Fri, 15 Dec 2006 16:01:43 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118320.html#118320 <![CDATA[setup problem :( : If you think the conenction information...]]> https://forums.webwiz.net/setup-problem_topic22200_post118317.html#118317 Author: michael
Subject: 22200
Posted: 15 December 2006 at 3:31pm

If you think the conenction information is correct, did you ever check the actual db to see if the tblDateTimeFormat is there?]]> Fri, 15 Dec 2006 15:31:13 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118317.html#118317 <![CDATA[setup problem :( : Hi! I hope, that I am not...]]> https://forums.webwiz.net/setup-problem_topic22200_post118307.html#118307 Author: LER2001
Subject: 22200
Posted: 15 December 2006 at 1:27pm

Hi!
 
I hope, that I am not stealing this tread. dcleslie: If you feel I am stealing just say so, and I will make my own tread:)
 
Anyway, I have the excact same problem.
I have setup the database/database_connection.asp and uploaded it with the rest of the files.
When I run the MSSQL_server_setup.asp, and enter the information I get the error-message, that dcleslie got in hes third post. (Error Connecting to database on SQL Server)
 
I have three suspicions as to what could be the problem:
 
1. In the database/database_connection.asp I have entered:
 strSQLServerName = "localhost"
since that is what my ISP has told me to enter. Is localhost a valid value? Or should it be the name of my domaine?
 
2. I may be typing in the wrong information in the MSSQL_server_setup.asp-form. What is the difference between the SQL Server Username and SQL Server Username for creating tables?
 
3. The text says: Enter a username and password in the box below that has table creation/modification rights at the SQL Server database you are using. Will I have that kind of rights? From my ISP I have only recieved:
 
MySQL:
Host:                   localhost
Database:               aaa
User:      aaa
Password:     *********

Thank you.
]]> Fri, 15 Dec 2006 13:27:31 +0000 https://forums.webwiz.net/setup-problem_topic22200_post118307.html#118307