Print Page | Close Window

Database connection problem

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=10942
Printed Date: 08 April 2026 at 2:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Database connection problem
Posted By: Helion
Subject: Database connection problem
Date 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 me error when I run it so I displayed out the codes to generate the tables and 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?



Replies:
Posted By: dpyers
Date 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.

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: Helion
Date 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.


Posted By: WebWiz-Bruce
Date 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 correct details for your SQL Server, then run the file msSQL_server_setup.asp, entering a username and password that has permissions on the MS SQL Server to create tables on the database. This file will create all the tables, stored procesdures, etc required for the forum.


-------------
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: Helion
Date Posted: 23 June 2004 at 4:59am
Yes, I know I shouldn't use the Query Analizer (QA), but the thing is that the msSQL_server_setup.asp doesn't run with the ID/password we were supplied. The ID/password works for the main site which the forum is 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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net