这次更新主要是增加对Oracle的支持,不需要安装Oracle客户端,下面的配置文件列出了Kalman Studio支持的几种数据库
<?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> </configSections> <connectionStrings> <clear/> <add name="Localhost" connectionString="Data Source=.;Integrated Security=SSPI;Persist Security Info=False;" /> <add name="MySql_Local" connectionString="Server=127.0.0.1;Database=test;Uid=root;Pwd=123456;" providerName="MySql.Data.MySqlClient"/> <add name="SQLite" connectionString="Data Source=F:datasqlite3 estdb.s3db;Version=3;" providerName="System.Data.SQLite"/> <add name="access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:main.mdb;User Id=admin;Password=;" providerName="System.Data.OleDb" /> <add name="oracle_ddtek" connectionString="Host=127.0.0.1;Port=1521;User ID=kly;Password=1111;SID=orcl" providerName="DDTek.Oracle"/> <add name="oracle_Devart_tns" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.20)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=kly;Password=111;" providerName="Devart.Data.Oracle"/> <add name="oracle_odp" connectionString="Data Source=orcl;User ID=kly;Password=111;" providerName="System.Data.OracleClient"/> </connectionStrings> <system.data> <DbProviderFactories> <clear/> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /> <add name="MySqlClient Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySql" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data" /> <add name="DB2 Data Provider" invariant="IBM.Data.DB2" description=".Net Framework Data Provider for DB2" type="IBM.Data.DB2.DB2Factory, IBM.Data.DB2" /> <add name="DDTek Oracle Data Provider" invariant="DDTek.Oracle" description=".Net Framework Data Provider for DDTek Oracle" type="DDTek.Oracle.OracleFactory, DDTek.Oracle" /> <add name="Devart Data Oracle Data Provider" invariant="Devart.Data.Oracle" description=".Net Framework Data Provider for Devart Data Oracle" type="Devart.Data.Oracle.OracleProviderFactory, Devart.Data.Oracle" /> </DbProviderFactories> </system.data> </configuration>
Oracle方面主要针对 DDTek Oracle做了测试,有问题加群122161138留言