着急啊

Question

With conn
        .ConnectionString = "driver=" & Driver & ";server=" & Server & ";uid=" &UID";pwd=" & PWD & ";database= " & Database
        .Open
    End With为什么连接不上呢? 变量                    Driver = SQL Server
                                          Server = ZYQIIY
                                          UID    = ""
                                          PWD    = ""
                                          Database=book_info
而直接用值连接就可以,如下面:
.ConnectionString = "driver=SQL Server;server=ZYQIIY;uid=;pwd=;database=book_info"
请高手解答
请用变量写出来好吗? 
"driver=SQL Server;server=ZYQIIY;uid=;pwd=;database=book_info"
这样也是对的,只是换成变量就不对了?为什么呢?

Answer 1

"driver='" & Driver 
加单引号试试了，记得前后都加

Answer 2

没道理呀
先debug.print看看语句有没有错

Answer 3

这样就行了：.ConnectionString = "driver=" & Driver & ";server=" & Server & ";uid=" & UID & ";pwd=" & PWD & ";database= " & Database