Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > "The provider could not determine the Object value" when accessing MSAccess database with ASP.NETV1

Reply
Thread Tools

"The provider could not determine the Object value" when accessing MSAccess database with ASP.NETV1

 
 
Siegfried Heintze
Guest
Posts: n/a
 
      11-11-2005
This program works fine on my desktop when I grant full control of the
MSAccess database to everyone. However, when I put it on my hosting service
with no impersonation, I now get this error (see below).
Can anyone suggest what the problem is?

When I turn on impersonation, I get "unspecified error". See below.

Thanks,
Siegfried

With no impersonation:
Server Error in '/keyword-job-search' Application.
----------------------------------------------------------------------------
----

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.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: 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.

Source Error:


Line 194: OleDbDataAdapter oCMD = new
OleDbDataAdapter(concat(selJobPosting[nCmd]), concat(strConn));
Line 195: DataSet oDS = new DataSet();
Line 196: oCMD.Fill(oDS, "MyList");
Line 197: return oDS;
Line 198: }



With impersonation:

Server Error in '/keyword-job-search' Application.
----------------------------------------------------------------------------
----

Unspecified error
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

Source Error:

Line 194: OleDbDataAdapter oCMD = new
OleDbDataAdapter(concat(selJobPosting[nCmd]), concat(strConn));
Line 195: DataSet oDS = new DataSet();
Line 196: oCMD.Fill(oDS, "MyList");
Line 197: return oDS;
Line 198: }


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR: Provider Management - Could not establish a connection to the database. Ted ASP .Net 3 02-05-2007 07:51 PM
How to have C# Web page query MSAccess Database and simultaneously populate MSAccess DB? Siegfried Heintze ASP .Net 1 04-15-2006 11:41 AM
accessing msaccess by using c language sudha C Programming 1 01-20-2005 06:31 PM
Could not quit MSACCESS.EXE =?Utf-8?B?RXpoaWw=?= ASP .Net 1 12-27-2004 10:28 PM
Could not quit MSACCESS.EXE Ezhil ASP General 4 12-27-2004 08:07 PM



Advertisments