Ado连接字符串..doc

ADO.NET连接字符串 说明 1 - SQL Server2 - SQL Server 20053 - ACCESS, Oracle4 - MySQL, Interbase, IBM DB25 - Sybase, Informix, Ingres, Mimer SQL, Lightbase, PostgreSQL, Paradox, DNS6 - Firebird, Excel , Text, DBF / FoxPro, AS/400 (iSeries), Exchange, Visual FoxPro, Pervasive, UDL 1 SQL Server ODBC 标准安全 Driver={SQL Server}; Server=Aron1; Database=pubs; Uid=sa; Pwd=asdasd; 信任的连接 Driver={SQL Server}; Server=Aron1; Database=pubs; Trusted_Connection=yes; 提示输入用户名和密码 oConn.Properties( Prompt ) = adPromptAlwaysoConn.Open Driver={SQL Server}; Server=Aron1; DataBase=pubs; OLE DB, OleDbConnection (.NET) 标准安全 Provider=sqloledb; Data Source=Aron1; Initial Catalog=pubs; User Id=sa; Password=asdasd; 信任的连接 Provider=sqloledb; Data Source=Aron1; Initial Catalog=pubs; Integrated Security=SSPI; (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) 提示输入用户名和密码 oConn.Provider = sqloledb oConn.Properties( Prompt ) = adPromptAlwaysoConn.Open Data Source=Aron1; Initial Catalog=pubs; IP地址连接管道 Provider=sqloledb; Data Source=00,1433; Network Library=DBMSSOCN; Initial Catalog=pubs; User ID=sa; Password=asdasd; (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default)) SqlConnection (.NET) 标准安全 Data Source=Aron1; Initial Catalog=pubs; User Id=sa; Password=asdasd; - or - Server=Aron1; Database=pubs; User ID=sa; Password=asdasd; Trusted_Connection=False (both connection strings produces the same result) 信任的连接 Data Source=Aron1; Initial Catalog=pubs; Integrated Security=SSPI; - or - Server=Aron1; Database=pubs; Trusted_Connection=True; (both connection strings produces the same result) (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000) IP地址连接管道 Data Source=00,1433; Network Library=DBMSSOCN; Initial Catalog=pubs; User ID=sa; Password=asdasd; (DBMSSOCN=TCP/IP instead of Named Pipe