Hi,

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)
.....


Since this didn't work, I changed the Database Sets in the File Options to Customer B (Visual Foxpro) to try out the VFP OleDB connection example provided. When I then selected the Employee menu item,I got the same error
I suspect the app stil want's to use an MS SqlConnection.

What did I do wrong?

Thanks in advance,

Mark