Print Page | Close Window

error on install

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=9862
Printed Date: 08 April 2026 at 3:32am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: error on install
Posted By: Bill
Subject: error on install
Date Posted: 16 February 2004 at 12:03pm

Have just completed the install procedure, first changing the constants:

Const strDbTable = "bds"
Const strDbProc = "bds"

in common.asp and msSQL_server_setup.asp

Then ran the msSQL_server_setup.asp file and it said installation successful. But then, when I went to the forum/index.asp page to have a look for the first time, I got the error message:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Could not find stored procedure 'wwfSpSelectConfiguration'.

/forum/common.asp, line 283

It would appear to be looking for a SP with the old 'wwf' name prefix. Can someone give me a steer on this? Is it a page that's corrupted, or am I going to have to do a complete reinstall? If so, I presume I am going to have to go through and drop all the tables and SPs first?

(Unfortunately I can't use enterprise manager on the site I'm trying to install the forum on, so I cannot 'see' what SPs are there etc.

Thanks

Bill




Replies:
Posted By: Semikolon
Date Posted: 16 February 2004 at 12:22pm

if the SPs and tables where installed before you changed the prefix, you will need to drop everything and reinstall, or rename everything..

you also have to change the prefixes in both common.asp files and the sql setup file



Posted By: Bill
Date Posted: 16 February 2004 at 12:27pm

No! As explained, I changed the prefixes in common.asp and the sql set up file, and only THEN did the installation of the SPs and tables.

But the index.asp  page is still looking for the old wwf... SP!



Posted By: thekiwi
Date Posted: 16 February 2004 at 12:45pm
Originally posted by Bill Bill wrote:

No! As explained, I changed the prefixes in common.asp and the sql set up file, and only THEN did the installation of the SPs and tables.

But the index.asp  page is still looking for the old wwf... SP!

Just to make sure we have all bases covered:

  • THere is no index.asp, its default.asp?

The error you are getting is because of this line:

If strDatabaseType = "SQLServer" Then
 strSQL = "EXECUTE " & strDbProc & "SelectConfiguration"

As you can see, the prefix is a variable set a few lines above, and therefore to get the error you have, the variable must be set as wwfSP.



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting


Posted By: thekiwi
Date Posted: 16 February 2004 at 12:47pm
Originally posted by Bill Bill wrote:

(Unfortunately I can't use enterprise manager on the site I'm trying to install the forum on, so I cannot 'see' what SPs are there etc.

Thanks

Bill

Use this:


CREATE PROCEDURE dbo.listProcedures 
AS 
BEGIN 
    SET NOCOUNT ON 
    SELECT 
        ROUTINE_NAME 
    FROM 
        INFORMATION_SCHEMA.ROUTINES 
    WHERE 
        ROUTINE_TYPE='PROCEDURE' 
        AND OBJECTPROPERTY 
        ( 
            OBJECT_ID(ROUTINE_NAME), 
            'IsMsShipped' 
        ) = 0 
    ORDER BY 
        ROUTINE_NAME 
END 
GO

then in ASP


<% 
    set conn = CreateObject("ADODB.Connection") 
    conn.open "<connection string>" 
    set rs = conn.execute("EXEC dbo.listProcedures") 
    do while not rs.eof 
        response.write rs(0) & "<br>" 
        rs.movenext 
    loop 
    rs.close: set rs = nothing 
    conn.close: set conn = nothing 
%>



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting


Posted By: thekiwi
Date Posted: 16 February 2004 at 12:49pm

PS you can do the same for showing the tables:

SELECT name 
    FROM sysobjects 
    WHERE xtype='U' 
    ORDER BY name 
 
-- or 
 
SELECT TABLE_NAME 
    FROM INFORMATION_SCHEMA.TABLES 
    WHERE TABLE_TYPE='BASE TABLE' 
    ORDER BY TABLE_NAME 



-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting


Posted By: WebWiz-Bruce
Date Posted: 16 February 2004 at 1:04pm
There are two common.asp files make sure that the prefix for the tables and stored procedures are changed in both.

At the moment becuase you have changed the prefix for the stored procedures and tables it is still looking for the old prefix name because you have not updated all the contents for the sp's and table prefixes.


-------------
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: Bill
Date Posted: 16 February 2004 at 1:20pm

Thanks for all your help. I had been blind - I had not seen the second common.asp file.

Really appreciate all your assistance!




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