By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,962 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,962 IT Pros & Developers. It's quick & easy.

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

P: n/a
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: }
Nov 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.