Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MM with MSAccess: Dynamic SQL generation not supported...
Message
De
29/04/2004 21:35:56
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
MM with MSAccess: Dynamic SQL generation not supported...
Divers
Thread ID:
00899573
Message ID:
00899573
Vues:
34
I'm getting an error during a save against MSAccess:

"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

OakLeaf.MM.Main.Business.mmBusinessObject.HandleException(Exception e)
OakLeaf.MM.Main.Business.mmBusinessObject.SaveDataSet(DataSet ds, String tableName, String databaseKey, IDbDataAdapter dbAdapter)
..."

web.config:
[databases]
[add key="xxx\Connection" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=d:\clients\xxx\website\database\xxx.mdb" /]
[add key="xxx\DataAccessClass" value="DataAccessOleDb" /]
[/databases]

Stupid question: does the MM Business object work with OleDb and MSAccess?

The save code was working for a few updates, and now, not! Removing changes to what I thought worked before still gets above error. Any clues?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform