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

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

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!

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.

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 
%>

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 

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

Really appreciate all your assistance!