用 adodc 生成连接字符串阿
解决方案 »
- queryunload中已经写了判断代码,我如何用代码强行退出程序呢?
- 再次散分,迎接本命年,哈哈.................
- 如何将用四字节十六进制表示的浮点小数转换成一个浮点数并保存至一个Single变量中
- 请问哪里有flash转换成其它格式的代码或控件例如转换成AVI MPWG WMV等!
- 有关vbSplitter控件的问题
- vb中DLL如何编写?
- 自制控件难吗?
- 所谓的 流技术 就是分批读取一部分的数据? 有什么需要注意的地方?
- 大问题,不然也过不了年了!!!!
- 二进制文件问题
- 这道程序很难嘛,为什么没人来阿!!帮帮忙,谢谢了各位大侠!!!
- SOS==大虾们帮我看看这段代码,如何获得当前用户==SOS
Set rs = CreateObject("ADODB.Recordset")
cn.Open "Provider=MS Remote;Data Source=pubs;Remote Server=http://192.168.1.173;UID=admin;PWD=;" rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM Authors", cn
pubs是数据服务器上的一个系统DSN.
1、是否可以PING通。
2、你登陆服务器是用什么验证的,你登陆的用户是否有足够的权限。
strCn = strCn & "Persist Security Info=True;"
strCn = strCn & "User ID=USER;"
strCn = strCn & "Password=11111;"
strCn = strCn & "Initial Catalog=MyDB;"
strCn = strCn & "Data Source=202.222.22.2"
Set cn = New ADODB.Connection
cn.Open strCn
.....注: MyDB为数据库名。
Set cn = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset") cn.Open "Provider=MS Remote;Data Source=pubs;Remote Server=http://192.168.1.173;UID=admin;PWD=;"'连 接通过 rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM Authors", cn'这里出现INTERNET服务器错误请ljren_t(立志)看看
------------------------------------------------------------
1.MS Remote - Access (Jet)
i)ODBC DSN:
oConn.Open "Remote Server=http://carl2;" & _
"Remote Provider=MSDASQL;" & _
"DSN=AdvWorks;" & _
"Uid=admin" & _
"Pwd=;" ii)OLE DB Provider:
oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://carl2;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\somepath\mydb.mdb;", _
"admin", "" iii)OLE DB Provider自定义事务对象
oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://carl2;" & _
"Handler=MSDFMAP.Handler;" & _
"Data Source=MyAdvworksOLEDBConnectTag;" 2.MS Remote - SQL Server
i)ODBC DSN:
oConn.Open "Remote Server=http://carl2;" & _
"Remote Provider=MSDASQL;" & _
"Network Library=DBMSSOCN;" & _
"DSN=Pubs;" & _
"Uid=sa" & _
"Pwd=;" ii)OLE DB Provider
oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://carl2;" & _
"Remote Provider=SQLOLEDB;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=carl2;" & _
"Initial Catalog=pubs;" & _
"User ID=sa;" & _
"Password=;"
http://www.csdn.net/expert/topic/342/342151.shtm
"Provider=MSDASQL.1;DRIVER={SQL Server};Server=服务器名;UID=USER;PWD=111111"
注意:服务器名不能用IP地址,只能用计算机名
IP 机器名 如202.222.22.2 RemoteMachRemoteMach为远程机器名文件编辑完后,ADO连接语句为:
"Provider=MSDASQL.1;DRIVER={SQL Server};Server=RemoteMach;UID=USER;PWD=111111"
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=jd;Data Source=192.168.0.2
Public SqlCommand As New ADODB.Command '定义 SQL 命令
Dim adoDateTime As New ADODB.Recordset '获取 NT-SERVER 时间
'**********Data Source=192.168.0.2 '*****后写IP地址
Public Function OpenConnection() As String '打开数据库
On Error GoTo SQLConErr
With adoCN
.CursorLocation = adUseClient
.Provider = "sqloledb"
.Properties("Data Source").Value = cNtServerName
.Properties("Initial Catalog").Value = cDatabaseName
.Properties("User ID") = cSQLUserName
.Properties("Password") = cSQLPassword
.Properties("prompt") = adPromptNever
.ConnectionTimeout = 15
.Open
If .State = adStateOpen Then
adoDateTime.Open "select getdate()", adoCN, adOpenStatic, adLockOptimistic
cServerDate = Format(adoDateTime(0), "yyyy-mm-dd")
cServertime = Mid(adoDateTime(0), 10)
Else
MsgBox "数据库连接失败,请找系统管理员进行检查 !", 16, cProgramName
End
End If
End With
SqlCommand.ActiveConnection = adoCN
SqlCommand.CommandType = adCmdText
Exit Function
SQLConErr:
Select Case Err.Number
Case -2147467259
MsgBox "找不到指定的SQL Server服务器或者数据库不存在,请重新设置!", vbExclamation
F_SetSystem.Show 1
Case -2147217843
MsgBox "指定的SQL Server数据库用户不存在或口令错误,请重新设置!", vbExclamation
F_SetSystem.Show 1
Case Else
MsgBox "数据环境连接失败,请找系统管理员进行检查 !", 16, cProgramName
End Select
OpenConnection
End Function
strCn = "Provider=SQLOLEDB.1;"
strCn = strCn & "Persist Security Info=True;"
strCn = strCn & "User ID=USER;"
strCn = strCn & "Password=11111;"
strCn = strCn & "Initial Catalog=MyDB;"
strCn = strCn & "Data Source=202.222.22.2"
Set cn = New ADODB.Connection
cn.Open strCn
.....注: MyDB为数据库名。