数据库连接字符串大全.docVIP

1.SQL Server?(1)ODBC?Driver={SQL Server};Server=Chris;Database=pubs;Uid=sa;Pwd=sa?Driver={SQL Server};Server=Chris;Database=pubs;Trusted_Connection=yes;?oConn.Properties(Prompt) = adPromptAlways?oConn.Open Driver={SQL Server};Server=Chris;DataBase=pubs;?(2)OLEDB,OLEDBConnection(.net)?Provider=sqloledb;Data Source=Chris;Initial Catalog=pubs;User Id=sa;Password=sa;?Provider=sqloledb;Data Source=Chris;Initial Catalog=pubs;Integrated Security=SSPI;?(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)?oConn.Provider = sqloledb?oConn.Prope