ADODB.Connection(0x800A0E78) [英] ADODB.Connection (0x800A0E78)
问题描述
原始的ConnectionString在MSSQL 2000工作加入WTO要求:
提供商= SQLOLEDB.1;持续安全信息= TRUE;用户ID = XXXXXXXX;初始目录= IntranetApps;数据源= MS;使用过程为prepare = 1;自动翻译= TRUE;数据包大小= 4096;工作站ID = datawriter;密码= XXXXXXXX';
块引用>这不是在2008年MSSQL工作新的ConnectionString:
Provider=SQLNCLI10;Server=PR-NB-CIS011\\SQLEX$p$pSS;Database=IntranetApps;Uid=XXXXXXXX;Pwd=XXXXXXXX;
块引用>我tryed改变提供商SQLNCLI10.1,没有供应商,...
在过去我解决了同样的问题,但地狱,我现在不记得了。我的事情,有需要安装一些供应商,但我现在可以找到关于它的什么都没有。
有code女巫抛出异常:
this.connection =新的ActiveXObject(ADODB.Connection);
this.connection.ConnectionString = this.conString;
尝试{
this.connection.Open;
}
赶上(E){
回复于(Chyba PRI pripojeni呐分贝。);
返回false; // pokud dojdeķchybe PRI pripojovaniķdatabazi,小唐FCE vraci假的,真正的jinak
}
解决方案如果这真的是一个连接字符串的问题,您应该:
- 研究基础
- 创建一个零长度whatever.udl文件,从命令行启动它;那么你可以玩弄的参数,测试连接,然后从剪贴板粘贴连接字符串
- 尝试
;数据源= PR-NB-CIS011 \\ SQLEX $ P $干燥综合征;
而不是;服务器= PR-NB -CIS011 \\ SQLEX $ p $干燥综合征;
Original connectionstring whitch working on MSSQL 2000:
Provider=SQLOLEDB.1; Persist Security Info=True; User ID=XXXXXXXX; Initial Catalog=IntranetApps; Data Source=MS; Use Procedure for Prepare=1; Auto Translate=True; Packet Size=4096; Workstation ID=datawriter; Password=XXXXXXXX';
New connectionstring which not working on MSSQL 2008:
Provider=SQLNCLI10;Server=PR-NB-CIS011\SQLEXPRESS;Database=IntranetApps;Uid=XXXXXXXX;Pwd=XXXXXXXX;
I tryed change provider to SQLNCLI10.1, without provider, ...
Once in past i solved same problem, but hell, i don't remember it now. I thing that there was needed install some provider, but i can find nothing about it now.
There is code witch throw exception:
this.connection = new ActiveXObject("ADODB.Connection"); this.connection.ConnectionString = this.conString; try { this.connection.Open; } catch(e){ Response.write("Chyba pri pripojeni na db."); return false; // pokud dojde k chybe pri pripojovani k databazi, pak fce vraci false, jinak true }
解决方案If this really is a connection string problem, you should:
- study the basics
- create a zero length "whatever.udl" file and start it from command line; you can then twiddle the parameters, test the connection, and paste the connection string from the clipboard
- try
";Data Source=PR-NB-CIS011\SQLEXPRESS;"
instead of";Server=PR-NB-CIS011\SQLEXPRESS;"
这篇关于ADODB.Connection(0x800A0E78)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!