刚安装时候第一次打开需要配置数据连接

如下图配置,以下是配置sql2005

 

 

其他数据库配置如下图表格

 

Database Driver Sample Connection String Driver Included?
Firebird Firebird Manager Driver Database=C:\firebird\EMPLOYEE.GDB;User=SYSDBA;Password=wow;Dialect=3;Server=localhost Yes
IBM DB2 IBM OLE DB Provider for DB2 Servers Provider=IBMDADB2.1;Password=sa;User ID=DB2Admin;Data Source=MyMeta;Persist Security Info=True No
Interbase Firebird Manager Driver Database=C:\interbase\EMPLOYEE.GDB;User=SYSDBA;Password=wow;Dialect=3;Server=localhost Yes
Microsoft Access Microsoft Jet 4.0 OLE DB Provider Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\access\newnorthwind.mdb;User Id=;Password= No
Microsoft SQL Server Microsoft OLE DB Provider for SQL Server Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Northwind;Data Source=localhost No
MySQL MySQL.OLEDB Provider Provider=MySQLProv;Persist Security Info=True;Data Source=test;UID=griffo;PWD=;PORT=3306 No
MySQL2 MySQL Connector/Net Database=Test;Data Source=Griffo;User Id=anonymous; No
Oracle Oracle Provider for OLEDB Provider=OraOLEDB.Oracle.1;Password=sa;Persist Security Info=True;User ID=GRIFFO;Data Source=dbMeta No
PostgreSQL Npgsql Server=127.0.0.1;Port=5432;User Id=joe;Password=secret;Database=joedata; Yes
SQLite SQLite.NET Data Source=database.db;New=False;Compress=True;Synchronous=Off Yes
VistaDB VistaDB Data Provider DataSource=C:\Program Files\VistaDB 2.0\Data\Northwind.vdb;Cypher= None;Password= ;Exclusive=False;Readonly=False; No
Advantage Advantage .NET Data Provider Provider=Advantage.OLEDB.1;Password="";User ID=AdsSys;Data Source=C:\Program Files\Extended Systems\Advantage\Help\examples\aep_tutorial\task1;Initial Catalog=aep_tutorial.add;Persist Security Info=True;Advantage Server Type=ADS_LOCAL_SERVER;Trim Trailing Spaces=TRUE No
IBM iSeries IBM iSeries Client Access Drivers PROVIDER=IBMDA400; DATA SOURCE=MY_SYSTEM_NAME;USER ID=myUserName;PASSWORD=myPwd;DEFAULT COLLECTION=MY_LIBRARY; No
VistaDB 3.x VistaDB 3.x CTP Provider=Data Source=C:\Program Files\VistaDB 3.0 CTP\Data\Northwind.vdb3;OpenMode=NonexclusiveReadOnly No
Delimited Text Microsoft Jet OleDb Drivers Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\TxtFilesFolder\;Extended Properties='text;HDR=Yes;FMT=Delimited' Yes

 以上来源于使用说明书

posted on 2011-10-14 14:39  jackdesk  阅读(1988)  评论(0编辑  收藏  举报