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
 I 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
------------- 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)
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
 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.
If I remove errortrapping from the mySQL_server_setup.asp I get the following:
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
 |
michael wrote: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
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
|
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. |