Error in vb.net Service Application

Dharmchand Dhingra

Hi,

I have created a service application in vb.net. This service get records from MS-Access database and send mail to particular user.

I have tested this service in 5 machine. In 3 Machine it is working fine. but in two machine it is throwing Exception which is below.

Exception : "The provider could not determine the Object value. For example, the row was just created, the default for the Object column was not available, and the consumer had not yet set a new Object value."

I am confused. can any one guide me where i am wrong.

Thanks in advance.

Regards
Dharmchand Dhingra

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh N16y ago
this usually occurs when you tried to append a record where a field was required, a field not allowing null, a field designed without default value, and no value was specified by your code for that field.
Also, try to place the column names and table names inside [] and check..
0
Dharmchand Dhingra16y ago
Hi,
Thanks for reply.
i debug the code but not found this type of problem.
When i run service using installutil.exe command then it is working on 3 PC but in two PC it is not working and creating log file with following error

Exception : "The provider could not determine the Object value. For example, the row was just created, the default for the Object column was not available, and the consumer had not yet set a new Object value."

Thanks and Regards
Dharmchand Dhingra
0
Santhosh N16y ago
looks like there might be a broken query while execting this either beacuse of the some invalid characters or reserved words...
check that while debugging for that particular user/email which is failing..
0