?
解决方案 »
- 请教问题
- vb编程怎么从无线数据采集器获取数据?
- 为什么总是提示错误???
- 急,我用IE访问某个网页只需5、6秒,为什么在vb中用api:InternetReadFile访问,需要4、5分钟呢?谢谢
- 各位大侠救命,我在vb的Project菜单找不到添加Data Report(报表)的菜单项,
- 高手进来 !!
- foreverforyou(为情所困) 问题还没解决 !!
- 分多得用不了,问一个简单的。如何将平面的数据结构转换为树状的?
- win2008x64开发的vb6.exe如何在win2003x86下使用?
- 如何在程序代码中加载主窗体的ICO,在网上查了些资料,但没找到,麻烦大家了。
- 实时通讯的数据保存问题
- 对数据库操作中的模糊查询问题!
With CN
If .State = adStateOpen Then .Close
.Mode = adModeReadWrite
.CursorLocation = adUseClient
.ConnectionString= "Provider=SQLOLEDB.1;password=;Persist Security Info=False;User ID=sa;Initial Catalog=" & Str_Data & ";Data Source=" & Str_Server
.Open
End With
Str_Data 是你的數據庫名稱,Str_Server 是你的服務器名稱試一下
dim iConcStr$
dim iDb as Adodb.Connection '定义数据库对象
dim iRe as Adodb.Recordset '定义表对象'数据库连接字符串
iConcStr = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=用户名;Password=密码;Initial Catalog=数据库名"'创建数据库及表对象
set iDb=new Adodb.Connection
set iRe=new Adodb.Recordset'打开数据库
iDb.open iConcstr'打开表
iRe.open "表名",iDb'''''''''''''''
'你的处理操作
''''''''''''''''关闭表及数据库
iRe.close
iDb.close'释放对象
set iRe=nothing
set iDb=nothing
dim rs as new adodb.recordset
dim selectsql as string
selectsql="Provider=SQLOLEDB.1;UID=sa;Pwd=;server={sql server};database=数据库名;"
rs.open selectsql
-------------------
我想这样行吧!
最后还要设置好数据源!
driver={SQLServer};server=127.0.0.1;database=databasename"
'函数名:CreateSqlConn
'参数: DbConnection ADODB连接,ServerName 服务器名,DBname 数据库名,UserID 登录用户名,UPw 登录密码,Timerout 连接超时
'返回值:TRUE 连接成功.FALSE 连接失败.
'例: CreateSqlConn p_cnn,"CJH","cjherp001","sa","123",15
'
Public Function CreateSqlConn(ByRef DbConnection As ADODB.Connection, _
ServerName As String, _
DbName As String, _
UserID As String, _
UPw As String, _
Optional Timerout As Long = 15) As Boolean
Dim ReturnVal As Boolean On Error Resume Next If DbConnection.State = adStateOpen And Not IsEmpty(adStateOpen) Then
DbConnection.Close
End If
'/连接1
DbConnection.Provider = "MSDASQL.1"
DbConnection.ConnectionString = "Driver={SQL Server};Server=" & ServerName & ";DataBase=" & DbName & ";Uid=" & UserID & ";Pwd=" & UPw & ";PWD=" & UPw & ";APP=" & App.Path & ";WSID=" & UserID & ";Connect Timeout=" & Timerout & ";"
'/--------------------------------------------------------------------------------------------
'/连接2
'/ DbConnection.Provider = "SqloleDB.1"
'/ DbConnection.ConnectionString = "Database=" & DBname & ";Server=" & ServerName & ";Uid=" & UserID & ";Pwd=" & UPw & ";Connect Timeout=" & Timerout & ";"
'/---------------------------------------------------------------------------------------------
DbConnection.ConnectionTimeout = Timerout
DbConnection.CommandTimeout = Timerout
DbConnection.Open
DoEvents
If Err.Number = 0 Then
DbStyle = "SQL"
ReturnVal = True
Else
Err.Clear
DbStyle = ""
ReturnVal = False
End If
CreateSqlConn = ReturnVal
End Function