Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - ASP/SQL ERROR - HELP!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

ASP/SQL ERROR - HELP!
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
cesco101 View Drop Down
Newbie
Newbie


Joined: 23 July 2003
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote cesco101 Quote  Post ReplyReply Direct Link To This Post Topic: ASP/SQL ERROR - HELP!
    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
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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

L. Jamal Inc : Web/ Print Design and ASP Programming
Back to Top
cesco101 View Drop Down
Newbie
Newbie


Joined: 23 July 2003
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote cesco101 Quote  Post ReplyReply Direct Link To This Post 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.)
Back to Top
ljamal View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 16 April 2003
Status: Offline
Points: 888 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ljamal Quote  Post ReplyReply Direct Link To This Post 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

L. Jamal Inc : Web/ Print Design and ASP Programming
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.