SQL在XP系统中连接的问题。。。急急急

[guanxt2009abc]

在xp系统中， 出现Unable to load SQL Server OLEDB provider resource DLL.The application cannot continue,该怎么处理，谢谢啦！！！

[Tiger_Zhao]

大概对应的 OLEDB Provider 没有安装。
比如本机只有 3.5 的而你要用 4.0 的。

[guanxt2009abc]

好像不行！那还是要说声谢谢~

[vbman2003]

你尝试在这个系统上设置连接SQL SERVER的ODBC,看看能不能成功...

[饮水需思源]

1，安装SQL2000SP4
2，如果是其他机器访问XP的SQL，则需要关闭防火墙
3，在控制面板中手工配制ODBC

[帝企鹅已被占用]

看看
http://itdevcorner.blogspot.com/2007/07/unable-to-load-sql-server-oledb.html
简要：
To connect to SQL Server using Oledb method, Windows uses two files: SQLOLEDB.DLL and SQLOLEDB.RLL. The first one is the one who's in charge to make the connection, the second is file that is used by the first one. Both must be there and are in the same folder. The error message means that your program find the sqloledb.dll but is missing the sqloledb.rll.


So, you might want to search you HDD for "sqloledb.*" Most likely you will find them in several folders. By default they are in C:\Program Files\Common Files\System\Ole Db but your program may looking for in Windows System directory. If you have sqloledb.dll in your windows system path but none of sqloledb.rll then all you have to do is just copy the file sqloledb.rll into your Windows System folder. This should work.