SQL Enterprise Server
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=22909
Printed Date: 07 April 2026 at 11:05am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Enterprise Server
Posted By: SignPile
Subject: SQL Enterprise Server
Date Posted: 16 March 2007 at 6:56pm
Hello,
I set up a database for the ASP forum in my SQL Enterprise server. I
edited the connection to the database in the
inetpub/ftproot/signpile/forum/database/database_connection.asp as
follows:
'Initilise the DB Connection String
strCon = "72.32.197.198"
& strSQLServerName & "WebWiz" & strSQLDBUserName &
"iputthecorrectpasswordhere" & strSQLDBPassword & "WebWiz" & strSQLDBName
& ";"
End If
The database has the user setup and owner permissions. The URL to the forum should be signpile.com/forum/
I commented it out and inserted a DSN-less connection string. I am now
reciving the following error when I browse @ http://signpile.com/forum/,
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'tblDateTimeFormat'.
/forum/functions/functions_date_time_format.asp, line 60
Let me know. I want this to work before buying it.
Thanks,
Dave
-------------
Dave D
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 18 March 2007 at 10:08am
Looks like you have edited the wrong part, you don't edit the connect string you place your database details into the location provided in that file. If you read the install instructions it has more on this.
Once this is done you need to run the database setup file, again more is on this if you follow the step by step install instructions.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: __n3o__
Date Posted: 21 June 2007 at 5:06pm
I am getting this exact same problem? I did have to change the connection string as I could not connect using the default settings, and I needed to connect using a trusted connection??
Any ideas on what this error is?
|
Posted By: WebWiz-Bruce
Date Posted: 21 June 2007 at 7:06pm
Sounds like you have not installed SQL Server in mixed mode.
Install the software again, but this time make sure you select mixed mode and set a password for the sa account so you can login over TCP/IP
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: __n3o__
Date Posted: 21 June 2007 at 7:26pm
|
ok will try that now... Thanks Bruce
|
|