Sharepoint BDC中常用的数据连接串写法

SQL Server

Server=<DATABASE_SERVER_NAME>;Database=<DATABASE_NAME>;Integrated Security=SSPI;

 

Oracle

Provider=msdaora;Data Source=<DATABASE_NAME>;Persist Security Info=False;Integrated Security=Yes;

 

 

OLE DB

Provider=sqloledb;Data Source=<DATABASE_SERVER_NAME>;Initial Catalog=<DATABASE_NAME>;Integrated Security=SSPI;

 

OBDC

DSN=<DSN_NAME>;NTL=TCPIP;NP=<IP_ADDRESS>;NA=<PORT_NUMBER>;UID=<USERNAME>;PWS=<PASSWORD>;RDB=<DATABASE_NAME>;PC=<PACKAGE_COLLECTION_NAME>;DS=<DEFAULT_SCHEMA>;