国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

SQL服務(wù)器 ODBC連接方式
標(biāo)準(zhǔn)安全連接
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
信任連接
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;
提示輸入用戶名和密碼方式
這個(gè)有一點(diǎn)問題，首先你需要設(shè)置一個(gè)Prompt 屬性等于adPromptAlways連接對(duì)象，然后在使用連接字符串
oConn.Properties("Prompt") = adPromptAlways
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;
OLE DB, OleDbConnection 連接方式(.NET)
標(biāo)準(zhǔn)安全連接
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
信任連接
Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
指定服務(wù)器的連接
Provider=sqloledb;Data Source=myServerName\theInstanceName;Initial Catalog=myDataBase;Integrated Security=SSPI;
提示輸入用戶名和密碼方式
oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
Data Source=myServerAddress;Initial Catalog=myDataBase;
通過(guò)IP地址連接
這里的Data Source=190.190.200.100,1433 前面的190.190.200.100是IP地址，1433連接是端口
Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

SqlConnection連接方式 (.NET)
標(biāo)準(zhǔn)安全連接
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
標(biāo)準(zhǔn)安全另外一種連接寫法
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;
信任連接
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
信任連接另外一種連接寫法
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
指定服務(wù)器的連接
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
對(duì)CE設(shè)備的信任連接
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;User ID=myDomain\myUsername;Password=myPassword;
通過(guò)IP地址連接
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
指定包大小的連接
默認(rèn)情況下， SQL服務(wù)器的微軟.NET框架數(shù)據(jù)提供者設(shè)置網(wǎng)絡(luò)包大小對(duì)8192個(gè)字節(jié)。然而這不一定是最好的，你可以根據(jù)你覺的合適的包大小設(shè)置包的大小，Packet Size= 就是設(shè)置包的大小值
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;Packet Size=4096;

Data Shape連接方式
MS Data Shape
Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
MySQL
MyODBC連接方式
MyODBC 2.50本地?cái)?shù)據(jù)庫(kù)
Driver={mySQL};Server=localhost;Option=16834;Database=myDataBase;
MyODBC 2.50遠(yuǎn)程數(shù)據(jù)庫(kù)
Driver={mySQL};Server=myServerAddress;Port=3306;Option=131072;Stmt=; Database=myDataBase;Uid=myUsername;Pwd=myPassword;
MyODBC 3.51本地?cái)?shù)據(jù)庫(kù)
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;
MyODBC 3.51遠(yuǎn)程數(shù)據(jù)庫(kù)
Driver={MySQL ODBC 3.51 Driver};Server=data.domain.com;Port=3306;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;
OLE DB, OleDbConnection連接方式(.NET)
標(biāo)準(zhǔn)連接
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;
Connector/Net 1.0連接方式(.NET)
標(biāo)準(zhǔn)連接
默認(rèn)端口是3306
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
指定端口
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
命名管道
如果端口號(hào)為 -1 就是告訴驅(qū)動(dòng)使用命名管道協(xié)議
Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
MySqlConnection連接方式(.NET)
eInfoDesigns.dbProvider
Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Command Logging=false;
SevenObjects MySqlClient連接方式(.NET)
標(biāo)準(zhǔn)連接
Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase;
Core Labs MySQLDirect連接方式 (.NET)
標(biāo)準(zhǔn)連接
User ID=root;Password=myPassword;Host=localhost;Port=3306;Database=myDataBase; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;
MySQLDriverCS 連接方式(.NET)
標(biāo)準(zhǔn)連接
Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";

Oracle
Oracle XE
標(biāo)準(zhǔn)連接
Oracle XE (或 "Oracle Database 10g Express Edition")是自由分布的簡(jiǎn)化版本
Driver=(Oracle in XEClient);dbq=111.21.31.99:1521/XE;Uid=myUsername;Pwd=myPassword;ODBC
新版本
Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;
舊版本
Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUsername;Pwd=myPassword;
OLE DB, OleDbConnection (.NET)
標(biāo)準(zhǔn)安全連接(微軟提供)
Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
被信任連接(微軟提供)
Provider=msdaora;Data Source=MyOracleDB;Persist Security Info=False;Integrated Security=Yes;
標(biāo)準(zhǔn)安全連接(Oracle提供)
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
被信任連接(Oracle提供)
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;
TNS-less連接
Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED)));User Id=myUsername;Password=myPassword;
Oracle.DataAccess.Client.OracleConnection
標(biāo)準(zhǔn)連接
Data Source=TORCL;User Id=myUsername;Password=myPassword;
綜合的安全連接
Data Source=TORCL;Integrated Security=SSPI;
沒有tnsnames.ora的ODP.NET連接
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;
OracleConnection, Oracle Data Provider, ODP.NET, System.Data.OracleClient.OracleConnection
標(biāo)準(zhǔn)連接
這個(gè)方式只適合Oracle 8i release 3或者之后的版本
Data Source=MyOracleDB;Integrated Security=yes;
指定用戶名和密碼的連接
這個(gè)方式只適合Oracle 8i release 3或者之后的版本
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;省去tnsnames.ora的連接
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));uid=myUsername;pwd=myPassword;
在Visual Studio中使用上面的字符串如果出現(xiàn)問題，就使用下面這個(gè)連接字符串
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;
使用共用連接
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;Incr Pool Size=5;Decr Pool Size=2;
Windows認(rèn)證的連接
Data Source=myOracleDB;User Id=/;
特許連接
SYSDBA 特許
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;
SYSOPER 特許
Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSOPER;
運(yùn)用密碼失效功能的連接
首先會(huì)打開連接，如果因?yàn)槊艽a失效而提示錯(cuò)誤的時(shí)候，就會(huì)使用OpenWithNewPassword中指定的新密碼
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;
oConn.OpenWithNewPassword(sTheNewPassword);
代理驗(yàn)證連接
Data Source=myOracleDB;User Id=myUsername;Password=myPassword;Proxy User Id=pUserId;Proxy Password=pPassword;

本站僅提供存儲(chǔ)服務(wù)，所有內(nèi)容均由用戶發(fā)布，如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容，請(qǐng)點(diǎn)擊舉報(bào)。