oledb连接字符串连接slqserver05该怎么写

Question

<connectionStrings>
    <add name="oledbconsql" connectionString="Provider=SQLOLEDB.1;Data Source=localhost;user id=sa;password=test;initial catalog=Inspur"/>
</connectionStrings>
[DBNETLIB][ConnectionOpen (Invalid Instance()).]无效的连接。 用的是oleDB连接，请教上面连接字符串连接sqlserver2005哪里不对，为何连接不上？

Answer 1

Set   conn   =   New   ADODB.Connection
conn.open();

Answer 2

connectionString="Provider=SQLOLEDB.1;Data Source=localhost;user id=sa;password=test;initial catalog=Inspur"红色部分,你可以改为:127.0.0.1,你建立的连接实例,./SQLEXPRESS,等

Answer 3

未在本地计算机上注册“127.0.0.1”提供程序。 
未在本地计算机上注册“./SQLEXPRESS”提供程序。 

Answer 4

1.<add key="sql2005" value="server=172.180.1.909;database=dain;User ID=srw;password=srw"/>
2.<connectionStrings>
<add name="drainConnectionString" connectionString="Data Source=172.180.1.202;Initial Catalog=dain;Persist Security Info=True;User ID=srw;Password=srw" providerName="System.Data.SqlClient"/>
</connectionStrings>

Answer 5

OleDbDataAdapter custDA = new OleDbDataAdapter();
DataTable dtTerritories = new DataTable("Territories");
          
ADODB.Connection adoConn = new ADODB.Connection();
ADODB.Recordset adoRS = new ADODB.Recordset();adoConn.Open(@"Provider=SQLOLEDB;Initial Catalog=msdb;Data Source=daikai;User ID=sa;Password=123456;", "", "", -1);我這樣聯過,測試可用
把這個寫在config里
Provider=SQLOLEDB;Initial Catalog=msdb;Data Source=daikai;User ID=sa;Password=123456;
就意上面紅色的參數,一定要加!

Answer 6

<connectionStrings>
    <add name="oledbconsql" connectionString="Provider=SQLOLEDB.1;Data Source=.;user id=sa;password=test"/>
</connectionStrings>

Answer 7

Data Source=.;Initial Catalog=db;Persist Security Info=True;User ID=sa;Password=sa" providerName="System.Data.SqlClient"红色地方是你SQL2005的实例名

Answer 8

www.connectionstrings.com
这个网站有几乎所有数据库的连接字符串写法。

Answer 9

Defaut.aspx文件
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Web.Configuration;public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            OleDbConnection con = new OleDbConnection(WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
            con.Open();
            OleDbDataAdapter da = new OleDbDataAdapter("Select * From aspnet_Profile", con);
            DataSet ds = new DataSet();
            da.Fill(ds, "srcTable");
            GridView1.DataSource = ds.Tables["srcTable"];
            GridView1.DataBind();
        }
    }
}
web.config文件
<connectionStrings>
    <add name="oledbconsql" connectionString="Provider=SQLOLEDB.1;Data Source=localhost;user id=sa;password=test;initial catalog=Inspur"/>
</connectionStrings>在红色部分报错：
行 20:             con.Open();
详细错误：
[DBNETLIB][ConnectionOpen (Invalid Instance()).]无效的连接。 
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Invalid Instance()).]无效的连接。源错误: 
行 18:         {
行 19:             OleDbConnection con = new OleDbConnection(WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
行 20:             con.Open();
行 21:             OleDbDataAdapter da = new OleDbDataAdapter("Select * From aspnet_Profile", con);
行 22:             DataSet ds = new DataSet();
 源文件: e:\Sources\ASPNET\Examples\Test_OLEDB\Default.aspx.cs    行: 20 堆栈跟踪: 
[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Invalid Instance()).]无效的连接。]
   System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +233
   System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +87
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +49
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
   System.Data.OleDb.OleDbConnection.Open() +19
   _Default.Page_Load(Object sender, EventArgs e) in e:\Sources\ASPNET\Examples\Test_OLEDB\Default.aspx.cs:20
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45
   System.Web.UI.Control.OnLoad(EventArgs e) +80
   System.Web.UI.Control.LoadRecursive() +49
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743 
帮忙调试下先谢谢了

Answer 10

搞定了，共享下给大家：
<add name="LocalSqlServer" connectionString="Provider=SQLNCLI;Server=\SQLEXPRESS;Database=MLDN;Uid=sa; Pwd=test;"/>