解决方案 »
- 请教:VB如何捕获(响应)excel自定义菜单
- asxToolbar 初始化时怎么按钮是隐藏的?
- 如何清空文本框中的内容?
- VB中如何调用系统中的程序(word excel)打开相应的文档?
- 如何在VB中调用VC制作的DLL,并传递自定义的结构数组??
- 请教用VB保存几个简单的数据怎么做?
- 在vb里面实现加载三维模型图
- 我在vb程序中如何得到web页上选中的内容?
- VB中 难道必须先LOAD 所有的FORM 才能得到FORMS.COUNT的值?
- vb 窗口中添加了一个tabtrips
- 如何快速检测到数据库是否能正常连接
- VsFlexgrid控件关联一张数据表后,如何实现用鼠标在VsFlexgrid控件上任意选取不连续的多条记录??
Set conn = New ADODB.Connection
Set Rs = New ADODB.Recordset
conn.CursorLocation = adUseClient
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=SBGL;Data Source=" & strServerName & " '连接局域网上ZHUXL主机上的SQL数据库
End Sub******************************
这样修改你的连接语句
Public sNeirong() As StringDeclare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" _
(ByVal lpApplicationName As String, _
ByVal lpKeyName As Any, _
ByVal lpDefault As String, _
ByVal lpReturnedString As String, _
ByVal nSize As Long, _
ByVal lpFileName As String) As LongPublic Function FlGetUserINI()
Dim lpOut As String * 128
Dim Ret As Long
Dim i As Integer
Dim sUser As String
Dim sKey As String
sIniFileDir = Trim(App.Path)
If Right(sIniFileDir, 1) <> "\" Then sIniFileDir = sIniFileDir & "\"
sIniFileDir = sIniFileDir & "HAS_SIM.INI"
For i = 0 To 1000
sKey = "KEY" & i + 1
Ret = GetPrivateProfileString("keshi", sKey, "", lpOut, 128, sIniFileDir)
sUser = FlLeftB(lpOut, Ret)
If sUser = "" Then
Exit Function
End If
ReDim Preserve sNeirong(i)
sNeirong(i) = sUser
NextEnd FunctionPublic Function FlLeftB(p1 As String, p2 As Long) As String
FlLeftB = StrConv(LeftB(StrConv(p1, vbFromUnicode), p2), vbUnicode)
End Function一个读取ini文件的例子 你参考下吧!~你去看看那2个api就知道什么意思了!~
Option Explicit
Public PstrConfArr(4) As String '1:User Name,2:Pssword,3:Database Name
Public PstrConfArr_Status(4) As String '1:User Name,2:Pssword,3:Database NamePublic Function MainSysOpening()
'On Error GoTo errMain:
Call PSubReadConf_Status
If Trim(PstrConfArr_Status(1)) = "0" Then
frmlogin.Show
Exit Function
Else
Call PSubReadConf PUserName = PstrConfArr(1)
PUserPassword = PstrConfArr(2)
PUserDbName = PstrConfArr(3)
Call PopenDBConnection
End If
End FunctionPublic Function PSubReadConf()
Dim rcStr As String Dim fso As New Scripting.FileSystemObject
Dim myTxt, i
Set myTxt = fso.OpenTextFile(Filename:=App.Path + "\dads.conf", IOMode:=ForReading)
With myTxt
i = 1
Do Until i > 3 '.AtEndOfStream
'Me.Controls("Text" & i).Text = .ReadLine
rcStr = .ReadLine
PstrConfArr(i) = StringEnDeCodecn(rcStr, 75)
'Debug.Print strConfArr(i)
i = i + 1
Loop
.Close
End With
End FunctionPublic Function PSubReadConf_Status()
Dim fso As New Scripting.FileSystemObject
Dim myTxt, i
Set myTxt = fso.OpenTextFile(Filename:=App.Path + "\Status.conf", IOMode:=ForReading)
With myTxt
i = 1
Do Until .AtEndOfStream
'Me.Controls("Text" & i).Text = .ReadLine
PstrConfArr_Status(i) = .ReadLine 'StringEnDeCodecn(rcStr, 75)
'Debug.Print strConfArr(i)
i = i + 1
Loop
.Close
End With
End FunctionPublic Function PopenDBConnection()
On Error GoTo errOpenBDConnection:
sSQL = "Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=" + Trim(PUserName) + ";Password=" + Trim(PUserPassword) + ";Data Source=" + Trim(PUserDbName)
ConnString = sSQL 'Save the Public connection string.
Conn.Open sSQL
frmLoginByUsers.Show
Exit Function
errOpenBDConnection:
MsgBox ("Database connection failed!" & vbCrLf & Err.Number & Err.Number & vbCrLf & Err.Description), vbCritical, " EnterpriseIQ System"
Exit Function
End Function