Non-default parameter not allowed after default parameter???

Non-default parameter not allowed after default parameter???

Post by ralp » Fri, 03 Oct 1997 04:00:00



Trying to call a stored procedure in VBScript.  It has quite a few
parameters to pass with 24 (22 input, 2 output).  I'm receiving the
following ODBC error message when attempting to execute the stored
procedure.  Anybody have any ideas what I could start looking at?

"Non-default parameter not allowed after default parameter."

Please post to newsgroup, email address is false (I hate spam).
TIA for any assistance.

 
 
 

1. Non-default parameter not allowed after default parameter

"Non-default parameter not allowed after default parameter."

Anybody ever get this error when using RDO and ODBC to connect to SQL Server
6.5 to run a stored procedure?

I'm writing an app in VB 5.0 that calls out to SQL Server 6.5 through RDO
2.0 and ODBC, but I only get this error on Windows 95 machines, not NT 4.0
machines. And I don't get it on all Windows 95 machines.

I've checked all the procedures on the server and they appear fine.

Any suggestions?

Tom

2. selecting only duplicate data

3. VFP - Appending

4. Oracle ODBC Driver does not allow DEFAULT parameters

5. Essbase Web Gateway Problems

6. OUTPUT parameter will not accept default value

7. I've encountered what I think is a bug.

8. Default layout not the Default

9. Default Parameters using ODBC SDK

10. Can't set parameter to default SQL 7

11. Default Parameters in Stored Procedure calls

12. UDFs with default parameters - doesn't work?