</sectionGroup>\r
</configSections>\r
<appSettings>\r
- <add key="PubsConnStr" value="factory=System.Data.SqlClient;server=speedy;database=pubs;uid=sa;pwd=" />\r
+ <add key="PubsConnStr" value="factory=System.Data.SqlClient;server=localhost;database=pubs;uid=sa;pwd=mypassword" />\r
+ <add key="OraConnStr" value="factory=System.Data.OracleClient;data source=testdb;user id=scott;password=tiger" />\r
+ <add key="PgConnStr" value="factory=Npgsql;Server=localhost;Database=monotest;User ID=monotest;Password=monotest" />\r
+ <add key="MySqlByteFXConnStr" value="factory=ByteFX.Data.MySqlClient;Database=test" />\r
+ <add key="FireConnStr" value="factory=FirebirdSql.Data.Firebird;Database=C:\FIREBIRD\EXAMPLES\EMPLOYEE.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=localhost" />\r
+ <add key="Sqlite2ConnStr" value="factory=Mono.Data.SqliteClient;URI=file:sqlitetest2.db" />\r
+ <add key="Sqlite3ConnStr" value="factory=Mono.Data.SqliteClient;URI=file:sqlitetest3.db,Version=3" />\r
+ <add key="SybaseConnStr" value="factory=Mono.Data.SybaseClient;Server=MYSERVER,5000;Database=testdb;User ID=sa;Password=;" />\r
+ <add key="MySqlConnStr" value="factory=MySql.Data;server=localhost;user id=user;password=pass;database=mysql;pooling=false" /> \r
</appSettings>\r
<mono.data>\r
<providers>\r
connection="System.Data.SqlClient.SqlConnection" \r
adapter="System.Data.SqlClient.SqlDataAdapter" \r
command="System.Data.SqlClient.SqlCommand" \r
- assembly="System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"\r
- description="Microsoft SQL Server 7.0/2000" />\r
+ assembly="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"\r
+ description="Microsoft SQL Server 7.0/2000/2005"\r
+ parameterprefix="at"\r
+ commandbuilder="System.Data.SqlClient.SqlCommandBuilder" />\r
<provider \r
name="System.Data.OleDb" \r
connection="System.Data.OleDb.OleDbConnection" \r
adapter="System.Data.OleDb.OleDbDataAdapter" \r
command="System.Data.OleDb.OleDbCommand" \r
- assembly="System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"\r
+ assembly="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"\r
description="OLE DB" />\r
<provider \r
name="System.Data.Odbc" \r
connection="System.Data.Odbc.OdbcConnection" \r
adapter="System.Data.Odbc.OdbcDataAdapter" \r
command="System.Data.Odbc.OdbcCommand" \r
- assembly="odbc"\r
- description="ODBC" />\r
+ assembly="System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"\r
+ description="ODBC"\r
+ parameterprefix="questionmark"\r
+ commandbuilder="System.Data.Odbc.OdbcCommandBuilder" />\r
<provider \r
- name="Mono.Data.TdsClient" \r
- connection="Mono.Data.TdsClient.TdsConnection" \r
- adapter="Mono.Data.TdsClient.TdsDataAdapter" \r
- command="Mono.Data.TdsClient.TdsCommand" \r
- assembly="Mono.Data.TdsClient"\r
- description="TDS Generic" />\r
- <provider name="Mono.Data.MySql" \r
- connection="Mono.Data.MySql.MySqlConnection" \r
- adapter="Mono.Data.MySql.MySqlDataAdapter" \r
- command="Mono.Data.MySql.MySqlCommand"\r
- assembly="Mono.Data.MySql"\r
- description="MySQL" />\r
+ name="System.Data.OracleClient" \r
+ connection="System.Data.OracleClient.OracleConnection" \r
+ adapter="System.Data.OracleClient.OracleDataAdapter" \r
+ command="System.Data.OracleClient.OracleCommand" \r
+ assembly="System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" \r
+ description="Oracle"\r
+ parameterprefix="colon"\r
+ commandbuilder="System.Data.OracleClient.OracleCommandBuilder" />\r
<provider \r
- name="Mono.Data.PostgreSqlClient" \r
- connection="Mono.Data.PostgreSqlClient.PgSqlConnection" \r
- adapter="Mono.Data.PostgreSqlClient.PgSqlDataAdapter" \r
- command="Mono.Data.PostgreSqlClient.PgSqlCommand" \r
- assembly="Mono.Data.PostgreSqlClient"\r
- description="PostgreSQL" />\r
+ name="ByteFX.Data.MySqlClient" \r
+ connection="ByteFX.Data.MySqlClient.MySqlConnection" \r
+ adapter="ByteFX.Data.MySqlClient.MySqlDataAdapter" \r
+ command="ByteFX.Data.MySqlClient.MySqlCommand"\r
+ assembly="ByteFX.Data, Version=0.7.6.1, Culture=neutral, PublicKeyToken=0738eb9f132ed756"\r
+ description="MySQL (ByteFX)" />\r
+ <provider \r
+ name="Npgsql" \r
+ connection="Npgsql.NpgsqlConnection" \r
+ adapter="Npgsql.NpgsqlDataAdapter" \r
+ command="Npgsql.NpgsqlCommand" \r
+ assembly="Npgsql, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7"\r
+ description="PostgreSQL"\r
+ parameterprefix="at"\r
+ commandbuilder="Npgsql.NpgsqlCommandBuilder" />\r
<provider \r
name="Mono.Data.SqliteClient" \r
connection="Mono.Data.SqliteClient.SqliteConnection" \r
adapter="Mono.Data.SqliteClient.SqliteDataAdapter" \r
command="Mono.Data.SqliteClient.SqliteCommand" \r
- assembly="Mono.Data.SqliteClient"\r
- description="SQL Lite" />\r
+ assembly="Mono.Data.SqliteClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756"\r
+ description="SQL Lite"\r
+ parameterprefix="colon" />\r
<provider \r
name="Mono.Data.SybaseClient" \r
connection="Mono.Data.SybaseClient.SybaseConnection" \r
adapter="Mono.Data.SybaseClient.SybaseDataAdapter" \r
command="Mono.Data.SybaseClient.SybaseCommand" \r
- assembly="Mono.Data.SybaseClient"\r
- description="Sybase" />\r
+ assembly="Mono.Data.SybaseClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756"\r
+ description="Sybase"\r
+ parameterprefix="at" />\r
+ <provider \r
+ name="FirebirdSql.Data.Firebird" \r
+ connection="FirebirdSql.Data.Firebird.FbConnection" \r
+ adapter="FirebirdSql.Data.Firebird.FbDataAdapter" \r
+ command="FirebirdSql.Data.Firebird.FbCommand" \r
+ assembly="FirebirdSql.Data.Firebird, Version=1.6.3.0, Culture=neutral, PublicKeyToken=e1b4f92304d7b12f"\r
+ description="Firebird"\r
+ parameterprefix="at"\r
+ commandbuilder="FirebirdSql.Data.Firebird.FbCommandBuilder" />\r
+ <provider \r
+ name="IBM.Data.DB2" \r
+ connection="IBM.Data.DB2.DB2Connection" \r
+ adapter="IBM.Data.DB2.DB2DataAdapter" \r
+ command="IBM.Data.DB2.DB2Command" \r
+ assembly="IBM.Data.DB2, Version=1.0.1728.9997, Culture=neutral, PublicKeyToken=7c307b91aa13d208"\r
+ description="IBM DB2 Universal Database" />\r
+ <provider \r
+ name="MySql.Data" \r
+ connection="MySql.Data.MySqlClient.MySqlConnection" \r
+ adapter="MySql.Data.MySqlClient.MySqlDataAdapter" \r
+ command="MySql.Data.MySqlClient.MySqlCommand"\r
+ assembly="MySql.Data, Version=1.0.7.30073, Culture=neutral, PublicKeyToken=8e323390df8d9ed4"\r
+ description="MySQL (MySQL AB)"\r
+ parameterprefix="at"\r
+ commandbuilder="MySql.Data.MySqlClient.MySqlCommandBuilder" />\r
</providers>\r
</mono.data>\r
</configuration>\r