Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
MM with MSAccess: Dynamic SQL generation not supported...
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement