在线急救!!!!ado如何通过Ip地址连接SQLserver数据库 问题如题,就是连接传该如何写 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 楼上的怎么写,我这样写的Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=CDFBserver;Data Source=192.168.1.1,不行。 还有一个问题,如果我不用ip连接,直接用数据库名连接,配置界面配置的连接可以连接,把连接串拷出来再程序里面去不能连接,我的代码如下:constr:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=CDFBserver;Data Source=JSINFO-ZD'; SQLQLADOConnection.Connected:=false; SQLQLADOConnection.ConnectionString:=constr; SQLQLADOConnection.Connected:=true; procedure TForm1.Button1Click(Sender: TObject);begin ADOConnection1.Connected:=false; ADOConnection1.ConnectionString:= 'Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=model;Data Source=127.0.0.1'; ADOConnection1.Connected:=true;end; 我这样写: SQLQLADOConnection.Connected:=false;constr:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=CDFBserver;Data Source=JSINFO-ZD'; SQLQLADOConnection.ConnectionString:=constr; SQLQLADOConnection.Connected:=true;还是会报错,是:尚未调用CoInitialize to:darkie28(小二黑) ,我是本机的ip connectionstring:='Provider=SQLOLEDB.1;Password='+varpass+';Persist Security Info=True;'+'User ='+varLOGINID+';InitialCatalog='+vardatabase+';DataSource='+serverIp+';Use Procedure for Prepare=1;' + 'Auto Translate=true;Packet Size=4096;Use Encryption for'+' Data=False;Tag with column collation when possible=False'; connectionstring:='Provider=SQLOLEDB.1;Password='+yourpwd+';Persist Security Info=True;'+'User ='+yourloginid+';InitialCatalog='+yourdatabase+';DataSource='+yourserverIP+';Use Procedure for Prepare=1;' + 'Auto Translate=true;Packet Size=4096;Use Encryption for'+' Data=False;Tag with column collation when possible=False'; 尚未调用CoInitialize====================你是在某个Thread里面使用的? 我是在Thread里面调用连接的有什么问题吗? delphi的spinEdit 有没有通用的异常处理类? 数据库备份和线程的问题。急! 条码打印! ShellTreeView和ShellListView的AutoRefresh属性导致的问题。。。求助 看见星星了 有关ADO组件问题 如何储存和恢复一个对象(只管 Publish 了的属性) 问点Memo的小问题 高手请进怎样由一个硬盘卷标label得到硬盘盘符。 为什么用Insert插入不了数据的 指针问题请教高手。100分答谢
constr:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=CDFBserver;Data Source=JSINFO-ZD';
SQLQLADOConnection.Connected:=false;
SQLQLADOConnection.ConnectionString:=constr;
SQLQLADOConnection.Connected:=true;
begin
ADOConnection1.Connected:=false;
ADOConnection1.ConnectionString:= 'Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=model;Data Source=127.0.0.1';
ADOConnection1.Connected:=true;
end;
SQLQLADOConnection.Connected:=false;
constr:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=CDFBserver;Data Source=JSINFO-ZD'; SQLQLADOConnection.ConnectionString:=constr;
SQLQLADOConnection.Connected:=true;
还是会报错,是:尚未调用CoInitialize
'User ='+varLOGINID+';InitialCatalog='+vardatabase+';DataSource='+serverIp+';Use Procedure for Prepare=1;' + 'Auto Translate=true;Packet Size=4096;Use Encryption for'+
' Data=False;Tag with column collation when possible=False';
'User ='+yourloginid+';InitialCatalog='+yourdatabase+';DataSource='+yourserverIP+';Use Procedure for Prepare=1;' + 'Auto Translate=true;Packet Size=4096;Use Encryption for'+' Data=False;Tag with column collation when possible=False';
====================
你是在某个Thread里面使用的?