Mark,
>I want to develop an MM.Net application with a Sql Anywhere 11 Server backend. I don't know if someone has developed a MM.Net wrapper around the Sql Anywhere .Net Provider yet, so I decided to try the OleDB connection provider first.
>I succesfully migrated the MM Northwind database to Sql Anywhere.
>
>I modified the app.config of the MM Northwind Winforms Sample Project and added:
>
>
>add key="CustC" value="Customer C SQL Anywhere"
>
>add key="CustC\Northwind\Connection" value="Provider=SAOLEDB.11;Persist Security Info=True;User ID=dba;Password=sql;Location=d:\_Data\SANorthwind.db"
>
>add key="CustC\Northwind\DataAccessClass" value="DataAccessOleDb"
>
>
>
>I then got the following error message :
>
>
>The keyword Provider is not supported
>(Het sleutelwoord wordt niet ondersteund: provider.)
>
>
> bij System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
> bij System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
> bij System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
> bij System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
> bij System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
> bij System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
> bij System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
> bij System.Data.SqlClient.SqlConnection..ctor(String connectionString)
> bij OakLeaf.MM.Main.Data.mmDataAccessSql.CreateSqlConnection()
> bij OakLeaf.MM.Main.Data.mmDataAccessSql.FillDataSet(DataSet ds, IDbDataAdapter dbAdapter, String tableName, Boolean clearOnFill)
You're getting this error because it's using a Sql Server data access class (as seen in he stack trace) rather than an OLE DB data access class. I recomend overridding the CreateDataAccessObject() method in your project-level Factory class to see what's going on.
Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com