https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 11:07:55 +0000 Thu, 21 Jun 2007 19:26:26 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22909 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/sql-enterprise-server_topic22909_post123978.html#123978 Author: __n3o__
Subject: 22909
Posted: 21 June 2007 at 7:26pm

ok will try that now... Thanks Bruce]]> Thu, 21 Jun 2007 19:26:26 +0000 https://forums.webwiz.net/sql-enterprise-server_topic22909_post123978.html#123978 https://forums.webwiz.net/sql-enterprise-server_topic22909_post123974.html#123974 Author: WebWiz-Bruce
Subject: 22909
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
]]> Thu, 21 Jun 2007 19:06:33 +0000 https://forums.webwiz.net/sql-enterprise-server_topic22909_post123974.html#123974 https://forums.webwiz.net/sql-enterprise-server_topic22909_post123966.html#123966 Author: __n3o__
Subject: 22909
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?
]]> Thu, 21 Jun 2007 17:06:07 +0000 https://forums.webwiz.net/sql-enterprise-server_topic22909_post123966.html#123966 https://forums.webwiz.net/sql-enterprise-server_topic22909_post121329.html#121329 Author: WebWiz-Bruce
Subject: 22909
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.
]]> Sun, 18 Mar 2007 10:08:12 +0000 https://forums.webwiz.net/sql-enterprise-server_topic22909_post121329.html#121329 https://forums.webwiz.net/sql-enterprise-server_topic22909_post121306.html#121306 Author: SignPile
Subject: 22909
Posted: 16 March 2007 at 6:56pm

Hello,

I set up a database for the ASP forum in my SQL Enterprise server. Iedited the connection to the database in theinetpub/ftproot/signpile/forum/database/database_connection.asp asfollows:

'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 nowreciving 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




]]> Fri, 16 Mar 2007 18:56:44 +0000 https://forums.webwiz.net/sql-enterprise-server_topic22909_post121306.html#121306