vb6 我要连接两个字符串 uid=sa和;pwd=111 第二个有分号没法连,请高手帮解决一下
解决方案 »
- 如何让应用程序不获得焦点
- 大家帮帮我,谢谢!!
- 菜鸟求助 用SQL的查询
- 关于VB打包的几个基础问题
- 我用一个mscomm控件读取com1的数据然后加到数据库请问我这里出了什么问题了!!分可以多给!!希望高手指导!有原文件
- 在VB中怎么调用存储过程啊?
- 用JET40进行连接ACCESS2000数据库出现错误,请指教!(急)
- 关于VB连接ACESS数据库 来实现查询功能!
- 关于水晶报表8.0,crack解密 的问题?
- 简单问题,怎样获取控件datagrid用户选择的行,或者说取得焦点的行!该控件对应是一个ACC表,取得所选择的数据库纪录更好!
- 初学API 请教各位大侠几个小问题~
- 急!vb的报表控件!
b = ";111"
c = a & b
用 "&" 连接就可以了
Private Sub Form_Unload(Cancel As Integer)
Dim server As String, uid As String, pwd As String, database As String, temp As String
server = getinifile(sysfile, section, "a8")
uid = getinifile(sysfile, section, "a6")
pwd = getinifile(sysfile, section, "a7"
database = getinifile(sysfile, section, "a2")
connectstr = "driver={SQL Server};server=" & server
temp = ";uid=" & uid
MsgBox temp '这个显示都正常
connectstr = connectstr & temp
MsgBox connectstr '这个显示就没连接到后面
connectstr = connectstr & temp
If Len(pwd) > 0 Then connectstr = connectstr & ";pwd=" & pwd
connectstr = connectstr + ";database=" + database
MsgBox (connectstr)
End Sub我要的结果connectstr = "driver={SQL Server};server=192.168.20.5;uid=sa;pwd=****;database=hlyddd"
Dim Connectstr As String
Pwd = "****"
Server = "192.168.20.5"
Database = "hlyddd"
Connectstr = "driver={SQL Server};server=" & Server
Uid = "sa"
Temp = ";uid=" & Uid
MsgBox Temp
Connectstr = Connectstr & Temp
MsgBox Connectstr
'Connectstr = Connectstr & Temp
If Len(Pwd) > 0 Then Connectstr = Connectstr & ";pwd=" & Pwd
Connectstr = Connectstr + ";database=" + Database
MsgBox (Connectstr)End Sub我把你的代碼折分後運行,最後的結果和你要的結果一樣"connectstr = "driver={SQL Server};server=192.168.20.5;uid=sa;pwd=****;database=hlyddd""你的:
pwd = getinifile(sysfile, section, "a7"
這行應該在後面加")" MsgBox Connectstr
'Connectstr = Connectstr & Temp
這第二排的應該注解掉最好加句下"Dim Connectstr As String "
调用 server = getinifile(sysfile, section, "a8") 后 server 的应该仅仅包括正确的内容(比如"a8")而不是带有其它非预期的字符。
a = "aaa;aa"
b = ";aaa"
c = a & B
c结果还是"aaa;aa"
我的代码是
a = "driver={SQL Server};server=192.168.20.5"
b = ";uid=sa"
c = a & b
刚试了一下,我以前代码放在form_unload里就是不行,刚把代码移到form_load里就可以了,不知啥原因,搞不懂了。
是否为常量或定常字符串?