setabort;
end;
end;
然后在其中放入adoconnection,adodataset,和datasetprovider控件,分别取名为adoc,adods,dsp。设置好它们之间的连接关系,把adoc的连接字符串设为连接数据库“db1”,这是默认值,然后在adoc的beforeconnect事件中:
adoc.connectionstring:=connectstringa+'initial catalog='+dbname+';'+connectstringc;
这里的connectstringa和connectstringc是为了动态构建连接字符串,预先设置好的字符串常量,如下:
const
connectstringa='provider=sqloledb.1;password=2003;persist security info=true;user id=sa;';
connectstringb='initial catalog=db1;';
connectstringc='data source=server3;use procedure for prepare=1;auto translate=true;packet size=4096;workstation id=lxm;use encryption for data=false;tag with column collation when possible=false';
编译、安装这个com+。然后编写客户端程序调用它。