Set g_conn = Server.CreateObject("ADODB.Connection") Dim ServerName As String, DBname As String, UserName As String, strPwd As String
Dim strDBPath As String ServerName = "localhost"
DBname = "题库"
UserName = "sa"
strPwd = ""
strDBPath = App.Path & "\题库.mdb" With g_conn
'If DBType = DBAccess Then
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password='';" & "Data Source =" & _
strDBPath '(为什么这一行有错?)
'Else
'连接SQLServer
'.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=True;" & _
' "User ID=" & UserName & ";Initial Catalog=" & DBname & _
' ";Data Source=" & ServerName & ";pwd=" & strPwd
'End If
.Open
End With为什么ConnectionString那一行有错呢?
解决方案 »
- Adress in used --------------------- 着急!!!
- &0表示八进制数,&h表示十六进制数,二进制数怎么表示,此外(VB里面有二进制字段吗?)
- 在线等待——
- 数据库的问题,如何把一个数据库中的某个表倒入到另一个数据库中!
- ASP代码转换成VB代码以后,提示溢出
- 怎么在程序运行时改变鼠标图标
- 如何在CAD中撰写汉字
- 用bitblt函数,把一个图形(比窗口大),画到一个窗体中,用me.picture=me.image后使用paintpiture方法把它改变大小/尺寸放到一个picturebox中,但是搬过去的只有form显示的部分,如何解决???
- Syntax error (missing operator) in query expression 'cilentity<>'superman' and sex=''女'''____这是错误提示,该怎么样改呢?
- 关于VB播放背景音乐
- SELECT * FROM TB1 WHERE [C:\TB2.MDB;PWD=123].NO=TB1.NO
- ccrpProgressBar如何使用
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath