Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sending 25 parameters to Store Procedure
Message
From
29/07/2002 14:45:52
 
 
To
All
General information
Forum:
ASP.NET
Category:
Databases
Title:
Sending 25 parameters to Store Procedure
Miscellaneous
Thread ID:
00683651
Message ID:
00683651
Views:
53
I have a VB.NET app that is accessing data on a SQL 2000 backend. The main table is 25 fields which are mostly integer fields with a couple of small text fields. A have a SP setup to update an existing record. The SP takes each field as a parameter, very basic. When I attempt to execute the ExecuteNonQuery method after opeing the connection and setting the parameters, I get two errors.

1. First Chance exception of type "System.Data.OleDB.OleDBException occurred in system.data.dll

then

2. Unhandled exception exception of type "System.Data.OleDB.OleDBException occurred in system.data.dll

Ideas of what to look at?

I look at SQL Profiler and the SP is not even being called.

I take and call the same SP with the exact values being passed in (Values pulled from the debug window) and the SP executed fine.
Fred Lauckner

You know, it works on my computer. I don't know what your problem is.

.Net aint so bad.
Next
Reply
Map
View

Click here to load this message in the networking platform