Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
WTF Does This Mean?????
Message
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
01446451
Message ID:
01446528
Vues:
53
Perhaps something to do with the structure of the dataset then. Isn't the datareader kind of open in that regard - i.e. it will eat whatever it is fed. I know there were some remote view issues in VFP/VFE if we defined remote views with select * and then the structure changed on the backend. ( though that may have had to do with the dbgetprops etc )

>FWIW - I changed my code to use a DataReader and it works.
>
>
>
>>>I'm trying to return a dataset from an Access table. I have done this same block of code in other apps dozens of times with no problems
>>>
>>>
>>>static string AccessConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Projects\Sales Quote\Database\Orig\quotedb 9-27.mdb";
>>>static OleDbConnection AccessConn = new OleDbConnection();
>>>
>>>static void Main(string[] args)
>>>{
>>>    AccessConn.ConnectionString = AccessConnString;
>>>
>>>    try
>>>    {
>>>        AccessConn.Open();
>>>    }
>>>    catch (Exception e)
>>>    {
>>>        throw e;
>>>    }
>>>
>>>    OleDbCommand oCmdVendors = new OleDbCommand();
>>>    oCmdVendors.CommandText = "select * from quote";
>>>    oCmdVendors.Connection = AccessConn;
>>>
>>>    OleDbDataAdapter AccessDA = new OleDbDataAdapter();
>>>    AccessDA.SelectCommand = oCmdVendors;
>>>
>>>    DataSet dsAccess = new DataSet();
>>>    AccessDA.Fill(dsAccess, "Quotes");
>>>}
>>>
>>>
>>>
>>>
>>>Tonight I get this message on the AccessDA.Fill:
>>>
>>>
>>>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 have Googled this and there are not any real answers. What the HECK is this????
>>
>>Two guesses : some kind of lock or something having to do with Select * and a structure change on the other end conflicting with structure of a strongly typed data set. If you enumerate the fields do you get the same result?


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform