Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sending 25 parameters to Store Procedure
Message
De
29/07/2002 14:45:52
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Titre:
Sending 25 parameters to Store Procedure
Divers
Thread ID:
00683651
Message ID:
00683651
Vues:
52
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform