Print Page | Close Window

setup problem :(

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=22200
Printed Date: 08 April 2026 at 11:56am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: setup problem :(
Posted By: dcleslie
Subject: setup problem :(
Date Posted: 14 December 2006 at 4:06pm
CryI am just trying to setup this forum right now and get this error:
 

Microsoft OLE DB Provider for SQL Server error '80040e37'

Invalid object name 'tblDateTimeFormat'.

/infoed/forum/functions/functions_date_time_format.asp, line 78

I've reuploaded all files and still get the error. Any ideas?



Replies:
Posted By: michael
Date Posted: 14 December 2006 at 4:17pm
What version did you download? Did you run the SQL Server Setup File? It appears your tables are not yet created....
Make sure you have SQL Server or mySQL installed depending on what version you downloaded. If you have neither, download the MS Access Version for testing.


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: dcleslie
Date Posted: 14 December 2006 at 4:23pm
argh.. you're right.. i'm an idiot...
except now I'm getting the error:
Error Connecting to database on SQL Server

Check the following is set up and correct:-

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

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

Is it true that when if I open the database_connection.asp page and it opens blank with no error than the string is correct? If so.. i'm not sure what's wrong here....


Posted By: michael
Date Posted: 14 December 2006 at 5:22pm
no, you need to open the file in notepad, the acutal asp does not do anything for you, it's just being included for connection variables....
 
Open it in NP and edit the info for server name, db, user, password.


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: dcleslie
Date Posted: 14 December 2006 at 7:05pm

Yes, I had done that so the database_connection.asp holds all the correct data from what I can tell -

sigh.. this must be a problem from my provider...
 


Posted By: Mikey
Date Posted: 14 December 2006 at 8:55pm
  1. Enter connection details in 'database/database_connection.asp'
  2. upload files to server
  3. run 'MSSQL_server_setup.asp' by entering the path to it in your web browser
  4. Fill in the form and hit submit.
  5. Post any errors you may receive, here.


-------------
Handyman man?


Posted By: LER2001
Date 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.


Posted By: michael
Date 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?

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: LER2001
Date 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.


Posted By: michael
Date 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?

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: LER2001
Date 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


Posted By: dpyers
Date 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.


Posted By: LER2001
Date 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: mailto:misspelled-username@localhost - '<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 mailto:root@localhost - root@localhost
 
The question is, how do I make the mySQL_server_setup.asp use mailto:username@localhost - username@localhost as logon?


Posted By: LER2001
Date 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.
 


Posted By: LER2001
Date 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
 
 


Posted By: dpyers
Date 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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net