Information générale
Catégorie:
Bases de données
PMFJI...
To tag onto Mike's response, check out the sqlconnection, sqlcommand, sqldatareader objects that are in the system.data.sqlclient namespace. These objects are optimized to work with and only work with sql server.
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement