Web Wiz Support and Community Forums : Database connection problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 17:38:44 +0000 Wed, 23 Jun 2004 04:59:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10942 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Database connection problem : Yes, I know I shouldn&#039;t use...]]> https://forums.webwiz.net/database-connection-problem_topic10942_post60224.html#60224 Author: Helion
Subject: 10942
Posted: 23 June 2004 at 4:59am

Yes, I know I shouldn't use the Query Analizer (QA), but the thing isthat the msSQL_server_setup.asp doesn't run with the ID/password wewere supplied. The ID/password works for the main site which the forumis also installed in.

So in the end, I output the codes onscreen and dump it into QA to create the tables/relationships and stored procedures.

I edited the SQL_server_connection.asp to connect via DSN and it works,but if I use SQLOLEDB as the provider, it gives me the error.
]]> Wed, 23 Jun 2004 04:59:54 +0000 https://forums.webwiz.net/database-connection-problem_topic10942_post60224.html#60224 <![CDATA[Database connection problem : Could you explain what you are...]]> https://forums.webwiz.net/database-connection-problem_topic10942_post60219.html#60219 Author: WebWiz-Bruce
Subject: 10942
Posted: 23 June 2004 at 4:24am

Could you explain what you are doing, you shouldn't need to use a query analizer.

Follow the install documents that come with the forum.

You need to edit the MS SQL Server connection file entering the correctdetails for your SQL Server, then run the file msSQL_server_setup.asp,entering a username and password that has permissions on the MS SQLServer to create tables on the database. This file will create all thetables, stored procesdures, etc required for the forum.
]]> Wed, 23 Jun 2004 04:24:29 +0000 https://forums.webwiz.net/database-connection-problem_topic10942_post60219.html#60219 <![CDATA[Database connection problem : Hi, no I am not trying to re-create...]]> https://forums.webwiz.net/database-connection-problem_topic10942_post60207.html#60207 Author: Helion
Subject: 10942
Posted: 22 June 2004 at 10:12pm

Hi, no I am not trying to re-create the table. This message shows up when I am trying to access the forum page.

I tried it locally and it was alright.
]]> Tue, 22 Jun 2004 22:12:24 +0000 https://forums.webwiz.net/database-connection-problem_topic10942_post60207.html#60207 <![CDATA[Database connection problem : Are you trying to create or re-create...]]> https://forums.webwiz.net/database-connection-problem_topic10942_post60127.html#60127 Author: dpyers
Subject: 10942
Posted: 21 June 2004 at 9:32am

Are you trying to create or re-create the table? If it's already been created, you have to drop it before re-creating it.]]> Mon, 21 Jun 2004 09:32:29 +0000 https://forums.webwiz.net/database-connection-problem_topic10942_post60127.html#60127 <![CDATA[Database connection problem : Hi, I have install the forum on...]]> https://forums.webwiz.net/database-connection-problem_topic10942_post60117.html#60117 Author: Helion
Subject: 10942
Posted: 21 June 2004 at 6:04am

Hi, I have install the forum on my DEV machine and it works fine with the SQL settings and stuff.

However, when I try to run the setup to create the table, it gave meerror when I run it so I displayed out the codes to generate the tablesand use that in the Query Analyzer.

However, the info that is in the SQL_server_connection.asp file doesn't gives me error when I try to access the forum.

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBXXXXXX]ConnectionOpen (CreateFile()).

/ctpdev/forum/common.asp, line 261

The login info is the same as those I used for my root site and the root site has no problem accessing the SQL server.

Anyone has any ideas?
]]> Mon, 21 Jun 2004 06:04:56 +0000 https://forums.webwiz.net/database-connection-problem_topic10942_post60117.html#60117