setup problem :(

Post Reply

Page 12 >

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
dcleslie Members Profile Find Members Posts Newbie Joined: 23 October 2003 Status: Offline Points: 22	Post Options Post Reply Quote dcleslie Report Post Thanks(0) Quote Reply Topic: setup problem :( 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?

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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.
	Blog \| MPG Tracker

dcleslie Members Profile Find Members Posts Newbie Joined: 23 October 2003 Status: Offline Points: 22	Post Options Post Reply Quote dcleslie Report Post Thanks(0) Quote Reply 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....

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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.
	Blog \| MPG Tracker

dcleslie Members Profile Find Members Posts Newbie Joined: 23 October 2003 Status: Offline Points: 22	Post Options Post Reply Quote dcleslie Report Post Thanks(0) Quote Reply 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...

Mikey Members Profile Find Members Posts Senior Member 1979 Joined: 06 October 2003 Location: United Kingdom Status: Offline Points: 839	Post Options Post Reply Quote Mikey Report Post Thanks(0) Quote Reply Posted: 14 December 2006 at 8:55pm
	Enter connection details in 'database/database_connection.asp' upload files to server run 'MSSQL_server_setup.asp' by entering the path to it in your web browser Fill in the form and hit submit. Post any errors you may receive, here.
	Handyman man?

LER2001 Members Profile Find Members Posts Newbie Joined: 15 December 2006 Location: Denmark Status: Offline Points: 6	Post Options Post Reply Quote LER2001 Report Post Thanks(0) Quote Reply 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.

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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?
	Blog \| MPG Tracker

Post Reply	Page 12 >

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum