System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]未找到指定的 SQL Server。
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at ResvHotelCRS.CssConn.HandleData(String sqlstring, DataSet& resultds, String tablenm, String& errstr) in F:\windowsclass\RevHotelCRS\ResvHotelCRS\ResVHotelConn.cs:line 71
这个数据库我是可以连上的不晓得为啥有这个错误
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at ResvHotelCRS.CssConn.HandleData(String sqlstring, DataSet& resultds, String tablenm, String& errstr) in F:\windowsclass\RevHotelCRS\ResvHotelCRS\ResVHotelConn.cs:line 71
这个数据库我是可以连上的不晓得为啥有这个错误
<appSettings>
<add key="DatabaseConnection" value="Provider=SQLOLEDB;server=192.0.0.49;uid=sa;pwd=masterkey;database=xinyu;Connect Timeout=10"/>
</appSettings>
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=192.0.0.49;Initial Catalog=xinyu;Persist Security Info=True;User ID=sa;Password=masterkey" providerName="System.Data.SqlClient"/>
</connectionStrings>
我这么写的,没有错呀
请用 SqlClient ,具有最佳的性能,
不要用 OleDb192.0.0.49 ???
F:\windowsclass\RevHotelCRS\ResvHotelCRS\ResVHotelConn.cs:line 71
一定有问题
===========
别人的一个类,封装了
不晓得,但是在别人那都没有问题
就我这有问题
=========================
好像是别的错我再找找
ResVHotelConn.cs:line 71列
现在改了这个就好了,但是之前一直不报错,后来改过一次以后突然报错了。谢谢大家,结贴了