I'm trying to use SQL 7 stored procedures to implement something like
example B7 where I allow users to signon and only show them to update
records that they should be able to update.

I first got the error in my B7 code, then I simplified down
to a hardcoded simple ASP that tries to do a view (without
all the logon stuff).

ASP code set if SQL statement:
mydb.SQL = "EXEC training_usp1 @parm1=abc"
I also have:
MyDB.dbDBType = "SQL"


Listing of Stored Procedure:

CREATE PROCEDURE training_usp1
@parm1 char(12) = NULL
AS
SELECT tr_exam, tr_classname, tr_city, tr_metroplex, tr_state,
tr_country, tr_date_from, tr_date_to, tr_cost, trp_comp_name,
tr_teacher
from training, trprovider
where tr_provider_id = trp_id
and trp_userid = @parm1




I'm getting the following error:
Error # = 0
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'abcdefg'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 01000
NativeError = 5701

NOTE: "abcdefg" is my userid and database name.

followed by

Error # = 0
Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 01000
NativeError = 5703

Any ideas?
Thanks in advance,
Neal Walters
http://ITCoolStuff.com