Web Wiz Support and Community Forums : /forum/common.asp, line 260 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 18:03:55 +0000 Wed, 24 May 2006 22:14:15 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19987 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[/forum/common.asp, line 260 : Sometimes when using localhost...]]> https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107704.html#107704 Author: WebWiz-Bruce
Subject: 19987
Posted: 24 May 2006 at 10:14pm

Sometimes when using localhost you also need to include the instance name of the SQL server.

I find the SQL server 2005 Express always requires that you also include the instence name.
]]> Wed, 24 May 2006 22:14:15 +0000 https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107704.html#107704 <![CDATA[/forum/common.asp, line 260 : WOW! You aint going to believe...]]> https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107701.html#107701 Author: chong67
Subject: 19987
Posted: 24 May 2006 at 9:34pm

WOW!
 
You aint going to believe this.
 
I was playing around and really working very hard at it and I stumble upon it
 
OK, you cannot just put 'localhost' in strSQLServerName.  I explicit say the servername and it work.  Do I have 2 servers running?
 
I am running SQL2005 and I am using VMWare on it before I do the real thing on my computer.
 
Next I am going to update the db and do 8.01 and see how it goes!
 
Thanks so much Borg!
]]> Wed, 24 May 2006 21:34:43 +0000 https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107701.html#107701 <![CDATA[/forum/common.asp, line 260 : Borg, I went to my database...]]> https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107700.html#107700 Author: chong67
Subject: 19987
Posted: 24 May 2006 at 9:20pm

Borg,
 
I went to my database that WWF is using and right click on properties and the authenticaiton method is "SQL Server Authentication".  I can only do that or Window authentiation and I cannot do both somehow and I am on SQL2005.
 
I also went to Admin Tools - ODBC and using the same username n pwd as on SQL_server_connection.asp and do a test connection and it work fine.
 
I put the username in the WWF database-Security-Users and it is there as in the .asp file above and I also put it the MAIN Object Explorer under Security-Logins.
 
Still get this below and appreciate all your help!
 
 
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/forum/common.asp, line 260
]]> Wed, 24 May 2006 21:20:24 +0000 https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107700.html#107700 <![CDATA[/forum/common.asp, line 260 : Check that your SQL Server is...]]> https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107571.html#107571 Author: WebWiz-Bruce
Subject: 19987
Posted: 23 May 2006 at 8:52am

Check that your SQL Server is running in mixed mode to allow TCP/IP connections and check you have set the correct connection string details in the forum to connect to the SQL Server.]]> Tue, 23 May 2006 08:52:33 +0000 https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107571.html#107571 <![CDATA[/forum/common.asp, line 260 : I am trying to get my forum...]]> https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107548.html#107548 Author: chong67
Subject: 19987
Posted: 22 May 2006 at 11:21pm

I am trying to get my forum to work with my SQL 2005.  I got everything imported fine.
 
I went to the Admin Tools and click on the ODBC to test the login for WWF and click on the "Test Connection" using the name and pwd used by WWF and the correct db used by WWF nd it work fine.
 
When I go to the IE, I get this error message below.  I know the SQL Server is running and how can I get access denied?  I just tried the test above and it work.
 
Need help. 
 
----
 
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/forum/common.asp, line 260
]]> Mon, 22 May 2006 23:21:32 +0000 https://forums.webwiz.net/forum-common-asp-line-260_topic19987_post107548.html#107548