ASP/SQL ERROR - HELP!
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=4481
Printed Date: 02 April 2026 at 8:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: ASP/SQL ERROR - HELP!
Posted By: cesco101
Subject: ASP/SQL ERROR - HELP!
Date Posted: 23 July 2003 at 7:10pm
|
I get this error when i run the forum:
Microsoft OLE DB Provider for SQL Server error '80040e14' Could not find stored procedure 'wwfSpSelectConfiguration'. /forum/common.asp, line 191 The forum works fine when using Access 2000 database. But, I migrate the database to MSSQL to make it run faster. PLEASE HELP asap! Thanks a lot in advance |
Replies:
Posted By: ljamal
Date Posted: 23 July 2003 at 7:15pm
|
The SQL Server version of WWF uses stored procedures which are not used in the Access version. Because of this you can not just upload an Access DB into a SQL DB, you must run the SQL configuration script. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |
Posted By: cesco101
Date Posted: 23 July 2003 at 7:29pm
Thanks  .
Sorry but, i don't understand what you are saying since i'm new new newbie   .
What do I need to do in order to resolve that problem   .
Can you please tell it as you were trying to explain it to a child with no experience at all in SQL (programming, software ...etc.)
|
Posted By: ljamal
Date Posted: 23 July 2003 at 7:35pm
|
Access and SQL Server (MSSQL) are databases however MSSQL has a method for running multiple and complex database queries(stored procedures) that Access does not. The SQL version of WWF uses this method for SQL Server which means that if you just upload your Access DB to a SQL Server, the boards will not function because the DB will lack the stored procedures.
There may be scripts on the forum some where to assist in the migration from Access to SQL so start there. If you don't have any experience with MSSQL, then my suggestion is to contact some who does for migration help. ------------- L. Jamal Walton http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming |