是一个关于VB联连SQL2000的代码。我试过以下几个方法。
1。
'实时错错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] 未找到指定的SQL server
'以下是代码
'========================================================
Dim strConn As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String 'Access 2000的連接
' strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\North.mdb;Persist Security Info=False"
'SQL Server2000的連接
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=sa;Data Source=ksd"
pubConn.Open strConn
rsTable.CursorLocation = adUseClient
strSQL = "select * from TableName"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rsTable
'==========================================================================2
'实时错错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] 未找到指定的SQL server
'以下是代码
Private Sub Form_Load()
Dim Cn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
If Cn.State = 0 Then Cn.Open "Provider=SQLOLEDB;data Source=newsql;Initial Catalog=ksd;User Id=sa;Password=sa"
End Sub
'============================================================================
3
'实时错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] SQL Server 不存在或拒绝访问。
'以下是代码
Private Sub Form_Load()
Dim Cn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
If Cn.State = 0 Then Cn.Open "Provider=SQLOLEDB;data Source=127.0.0.1;Initial Catalog=ksd;User Id=sa;Password=sa"
End Sub
'================================================================
我的SQL实例叫NewSql 数据库名叫ksd 用户sa 密码sa
数据表:ksb
现在Newsql的服务管理器正在运行。帮帮忙呀。2
1。
'实时错错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] 未找到指定的SQL server
'以下是代码
'========================================================
Dim strConn As String
Dim pubConn As New ADODB.Connection
Dim rsTable As New ADODB.Recordset
Dim strSQL As String 'Access 2000的連接
' strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\North.mdb;Persist Security Info=False"
'SQL Server2000的連接
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=sa;Data Source=ksd"
pubConn.Open strConn
rsTable.CursorLocation = adUseClient
strSQL = "select * from TableName"
rsTable.Open strSQL, pubConn, adOpenDynamic, adLockOptimistic
Set DataGrid1.DataSource = rsTable
'==========================================================================2
'实时错错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] 未找到指定的SQL server
'以下是代码
Private Sub Form_Load()
Dim Cn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
If Cn.State = 0 Then Cn.Open "Provider=SQLOLEDB;data Source=newsql;Initial Catalog=ksd;User Id=sa;Password=sa"
End Sub
'============================================================================
3
'实时错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] SQL Server 不存在或拒绝访问。
'以下是代码
Private Sub Form_Load()
Dim Cn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
If Cn.State = 0 Then Cn.Open "Provider=SQLOLEDB;data Source=127.0.0.1;Initial Catalog=ksd;User Id=sa;Password=sa"
End Sub
'================================================================
我的SQL实例叫NewSql 数据库名叫ksd 用户sa 密码sa
数据表:ksb
现在Newsql的服务管理器正在运行。帮帮忙呀。2
解决方案 »
- 【聚会!!!】召唤广州附近的朋友,一起FB一下吧!
- picture中鼠标点击曲线,显示坐标呢(50分小谢)
- 判断字段是否存在
- 奇怪~~~有2个窗体MDIForm1和Form1,Form1设置为它的子窗体,但检测到Form1的父句柄却不是MDIForm1的句柄,为什么呀?
- 如何在Listview中加载PictureBox????
- 请问:双击托盘图标隐藏托盘窗口如何实现?
- 一个问题!类似netants的菜单~~~~
- 注册表相关
- 免费给你做广告!!
- how to handle the printer control?
- 如何在VB中直接打开IE浏览器,并访问某地址!急!
- 请问高手:combobox怎样判断输入的内容与item的内容相同?
'SQL Server2000的連接
strConn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa; password=sa;Data Source=ksd"
提示'实时错错误 '-2147467259(80004005)'
'[DBNETLIB][connectionopen (connect()).] 未找到指定的SQL server
Set adocon1 = New ADODB.Connection
sql = "Provider=SQLOLEDB.1;User ID=用户名;password=密码;Initial Catalog=数据库名;Data Source=服务器名或IP
adocon1.ConnectionTimeout = 10
adocon1.Open sql
Set DataGrid1.DataSource = rsTable
DataGrid1.refresh
Set adocon1 = New ADODB.Connection
sql = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ksd;Data Source=localhost pwd=sa"
adocon1.ConnectionTimeout = 10
adocon1.Open sql