1。
ADOConnection1.ConnectionString :=
'Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;' + #13 +
'Initial Catalog=Test;Data Source=CATFOX;Use Procedure for Prepare=1;' + #13 +
'Auto Translate=True;Packet Size=4096;Workstation ID=CATFOX;Use Encryption for Data=False;' + #13 +
'Tag with column collation when possible=False';
2。
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;
Initial Catalog=Test;Data Source=CATFOX;Use Procedure for Prepare=1;
Auto Translate=True;Packet Size=4096;Workstation ID=CATFOX;
Use Encryption for Data=False;Tag with column collation when possible=False
改成
Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=Test;Data Source=CATFOX;
Workstation ID=CATFOX;
其实连接数据库只要填写了服务器名、数据库名、用户名、密码就基本可以连接了,其他
的让系统总机默认