bb = "Provider=SQLOLEDB;User ID=" + userID + " ;PWD=" + passWord + " ;Initial Catalog=" + dbName + " ;Data Source=" + dbIP
MsgBox (bb)最后显示的结果是Provider=SQLOLEDB;User ID=sa 后面的字符串都没有显示出来,不知道怎么回事,请高手指点一下
MsgBox (bb)最后显示的结果是Provider=SQLOLEDB;User ID=sa 后面的字符串都没有显示出来,不知道怎么回事,请高手指点一下
解决方案 »
- 请问有没有比等号更快的判断两个字符串是否完全相同的方法?
- 一个网页下有若干个iframe,每个iframe下又有若干个数目不等的子iframe,每个子iframe下又有若干个数目不等的孙iframe,...如何枚举出全部的iframe?
- 用variant类型的变量数组接收串口的字节,每次到底能收到多少字节?(mscomm通讯问题)
- 请问怎么给另一个程序上的按钮发一个“显示”的消息?那个按钮为不可见
- Dao36+access2000数据库访问问题?
- 请问启动屏幕保护的问题,谢谢
- 快:tabstrip的selecteditem的背景色怎样改变?
- csdn2001微软版上的 VB PowerWrap1.7 哪位有注册机?帮帮忙呀
- vb中的多行文本框中获得自动文本,怎样把光标放在文本末尾?
- 关于WIN98系统的问题?
- 急求:vb中spread中设置两列行头 如何让两列行头 颜色不一样
- vb中shell的问题
很有可能你的
userID="sa"+chr(0)
错误报出来。
sqlstr = "select cMobilePhone from KzMembers where cEmailAddress in (" + Trim(email) + ")"
telephone = ""
'开始连接数据库操作
Set Conn = New ADODB.Connection
Set Rs = New ADODB.Recordset
MsgBox (userName)
MsgBox (passWord)
MsgBox (dbName)
MsgBox (dbIP)
Dim bb As String, cc As String, dd As String, ee As String
bb = "Provider=SQLOLEDB;User ID=" + userName + " ;PWD=" + passWord + " ;Initial Catalog=" + dbName + " ;Data Source=" + dbIP
MsgBox (bb)
在上面的代码中,一下几行都可以正常获得值
MsgBox (userName)
MsgBox (passWord)
MsgBox (dbName)
MsgBox (dbIP)
就是到bb= 这个字符串的时候出错了
sqlstr = "select cMobilePhone from KzMembers where cEmailAddress in (" + Trim(email) + ")"
telephone = ""
'开始连接数据库操作
Set Conn = New ADODB.Connection
Set Rs = New ADODB.Recordset
MsgBox (userName)
MsgBox (passWord)
MsgBox (dbName)
MsgBox (dbIP)
Dim bb As String, cc As String, dd As String, ee As String
bb = "Provider=SQLOLEDB;User ID=" + userName + " ;PWD=" + passWord + " ;Initial Catalog=" + dbName + " ;Data Source=" + dbIP
MsgBox (bb)
在上面的代码中,一下几行都可以正常获得值
MsgBox (userName)
MsgBox (passWord)
MsgBox (dbName)
MsgBox (dbIP)
就是到bb= 这个字符串的时候出错了
*******************************************
以上的代码是在一个
Public Function backTelephone(email As String, userName As String, passWord As String, dbName As String, dbIP As String) As String 的函数中包括的
而后面的几个参数是通过从.ini文件中读取过来了
'开始获取连接数据库的信息
GetPrivateProfileString "new", "username", "读取文件内容", myini, 255, "c:\loginfo.ini"
userName = Trim(myini) '用户名
' MsgBox (userName)
GetPrivateProfileString "new", "password", "读取文件内容", myini, 255, "c:\loginfo.ini"
passWord = Trim(myini) '密码
' MsgBox (passWord)
GetPrivateProfileString "new", "dbname", "读取文件内容", myini, 255, "c:\loginfo.ini"
dbName = Trim(myini) '数据库名称
' MsgBox (dbName)
GetPrivateProfileString "new", "ip", "读取文件内容", myini, 255, "c:\loginfo.ini"
dbIP = Trim(myini) '数据库服务器IP
'MsgBox (dbIP)结果就出现了在连接数据库的时候提示的错误
run-time error '-2147217843(80040e4d)'错误的行是
bb = "Provider=SQLOLEDB;User ID=" + userName + " ;PWD=" + passWord + " ;Initial Catalog=" + dbName + " ;Data Source=" + dbIP
而后面的几个参数是通过从.ini文件中读取过来了
'开始获取连接数据库的信息
GetPrivateProfileString "new", "username", "读取文件内容", myini, 255, "c:\loginfo.ini"
userName = Trim(myini) '用户名
userName=replace(userName,chr(0),"")
' MsgBox (userName)
GetPrivateProfileString "new", "password", "读取文件内容", myini, 255, "c:\loginfo.ini"
passWord = Trim(myini) '密码
passWord=replace(passWord,chr(0),"")
' MsgBox (passWord)
GetPrivateProfileString "new", "dbname", "读取文件内容", myini, 255, "c:\loginfo.ini"
dbName = Trim(myini) '数据库名称
dbName =replace(dbName ,chr(0),"")
' MsgBox (dbName)
GetPrivateProfileString "new", "ip", "读取文件内容", myini, 255, "c:\loginfo.ini"
dbIP = Trim(myini) '数据库服务器IP
dbIP =replace(dbIP ,chr(0),"")
'MsgBox (dbIP)
vb如果不用f8的话
很难调错的设置个断点儿,用F8自己跟一下吧