Bonnie,

I have it narrowed down. It is a problem with passing the data. The null values are being passed as "default". Since there are no default values setup for the fields, it hurls with an error. I just need to find how to pass the true NULL.




>Fred,
>
>I don't know VB all that well, but post some of your code and maybe someone can see what you did wrong.
>
>
>~~Bonnie
>
>
>>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.