SQL SERVER 2000连接字符串

不带端口:Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=QySign;Data Source=127.0.0.1

 

带端口：Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=QySign;Data Source=127.0.0.1,1433;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=QYIS-V;Use Encryption for Data=False;Tag with column collation when possible=False

 

  strConn := 'Provider=SQLOLEDB.1;';
  strConn := strConn + 'Password=' + m_ini.ReadString('db','password','') + ';';
  strConn := strConn + 'Persist Security Info=True;';
  strConn := strConn + 'User ID=' + m_ini.ReadString('db','username','') + ';';
  strConn := strConn + 'Initial Catalog=;' + m_ini.ReadString('db','dbname','') + ';';
  strConn := strConn + 'Data Source=' + m_ini.ReadString('db','server','') + ';';
  strConn := strConn + 'Use Procedure for Prepare=1;';
  strConn := strConn + 'Auto Translate=True;';
  strConn := strConn + 'Packet Size=4096;';
  strConn := strConn + 'Workstation ID=QYIS-V;';
  strConn := strConn + 'Use Encryption for Data=False;';
  strConn := strConn + 'Tag with column collation when possible=False';

 

各字段参考说明的网址

http://www.orsoon.com/article/article_1291.html