ZhiYeJianKang_PeiXun/cyqdata-master/文档
2025-02-20 15:41:53 +08:00
..
CYQ.Data API For V5.chm v1 2025-02-20 15:41:53 +08:00
CYQ.Data.dll v1 2025-02-20 15:41:53 +08:00
CYQ.Data.ProjectTool.exe v1 2025-02-20 15:41:53 +08:00
CYQ.Data精通VIP培训系列.pptx v1 2025-02-20 15:41:53 +08:00
Intelisense.rar v1 2025-02-20 15:41:53 +08:00
MySql.Data.dll v1 2025-02-20 15:41:53 +08:00
Npgsql2.0.11.92-bin-ms.net2.0.zip v1 2025-02-20 15:41:53 +08:00
Npgsql2.0.11.92-bin-ms.net4.0.zip v1 2025-02-20 15:41:53 +08:00
Oracle.ManagedDataAccess.rar v1 2025-02-20 15:41:53 +08:00
ReadMe.txt v1 2025-02-20 15:41:53 +08:00
System.Data.SQLite_64.rar v1 2025-02-20 15:41:53 +08:00
System.Data.SQLite_x86.rar v1 2025-02-20 15:41:53 +08:00
System.Data.SQLite.DLL v1 2025-02-20 15:41:53 +08:00
VS集成ProjectTool说明.txt v1 2025-02-20 15:41:53 +08:00

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

###--------------------------------------------------------###

   Txt::  Txt Path=E:\
   Xml::  Xml Path=E:\
Access::  Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\cyqdata.mdb
Sqlite::  Data Source=E:\cyqdata.db;failifmissing=false;
 MySql::  host=localhost;port=3306;database=cyqdata;uid=root;pwd=123456;Convert Zero Datetime=True;
 Mssql::  server=.;database=cyqdata;uid=sa;pwd=123456; 
Sybase::  data source=127.0.0.1;port=5000;database=cyqdata;uid=sa;pwd=123456;
Postgre:  server=localhost;uid=sa;pwd=123456;database=cyqdata; 
    DB2:  Database=SAMPLE;User ID=administrator;Server=127.0.0.1;password=1234560;provider=db2; 

Oracle OracleClient:: 
Provider=MSDAORA;Data Source=orcl;User ID=sa;Password=123456
Provider=MSDAORA;Data Source=ip\orcl;User ID=sa;Password=123456

Oracle ODP.NET::
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)));User ID=sa;password=123456

由于各种数据库链接语句基本一致除了特定写法外可以通过链接补充provider=mssql、provider=mysql、provider=db2、provider=postgre等来区分。
###--------------------------------------------------------###

中文说明:
1{0} 代表根目录
2sqlite、MySql、Sybase 都需要将对应的dll放到和cyq.data.dll同一目录。
相关的dll下载http://www.cyqdata.com/download/article-detail-426
3oracle 时:
A默认OracleClient引的是64位的如果是32位的需要自己从源码移除重新引用32位的。
B用odp.net 的Oracle.DataAccess 需要自己下载安装将把Oracle.DataAccess.dll放到和同一目录下。
C用Oracle.ManagedDataAccess放到同一目录下即可以使用。

Explanation:
1: {0} represents the root directory
2: sqlite, MySql, Sybase needs to put the corresponding dll and cyq.data.dll same directory.
Related dll download: http: //www.cyqdata.com/download/article-detail-426
3: oracle when:
A: The default OracleClient lead is 64, if it is 32, you need to remove yourself from the re-introduction of 32-bit source.
B: with odp.net of Oracle.DataAccess need to download to install, and will Oracle.DataAccess.dll into the same directory.
C: with Oracle.ManagedDataAccess into the same directory that is available.