Web Wiz Forums - SQL Server Problem

Print Page | Close Window

SQL Server 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=5752
Printed Date: 03 April 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Server Problem

Posted By: Brolin99
Subject: SQL Server Problem
Date Posted: 14 September 2003 at 10:03pm

Hello all,

I recently upgraded from Access to SQL Server using the Access Upsize wizard. I also re-installed the SQL Server prepared forum download to replace my Access version.

Now my front page (default.asp) works fine with no errors - but doesn't pull any information out of the database (i.e. it gives me the "No Forums to display" text) and there are no membership listings or anything. However when I go to the admin section all of the information is there???

The only code I have modified is the SQL Server connection script and the common.inc source code to specify that I am using an SQL Server database - can anyone help?

Cheers!

Replies:

Posted By: michael
Date Posted: 15 September 2003 at 8:24am

Did you change both common.asp's? There is one in the root and one in the admin folder, plus the sql_server_connection.asp file.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Brolin99
Date Posted: 15 September 2003 at 3:54pm

Yes I changed them both - I even compared the source code and all of the attributes that both of them had were the same??

It's a weird one!