最近做的一个VB课程设计,用的是SQL数据库,并且代码中的SQL服务器名和密码都是我自己的,要交作业,我怕到老师机子上调试的时候出错,请问在我的代码中怎么写就可以获得别的机子上的SQL服务器名和登录密码?
这是我的数据库连接代码
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strconn As String
Dim sql As String
strconn = "provider=SQLOLEDB.1;server=GL-PC;persist security info=false;UID=sa;pwd=415024522;database=Drug"
conn.Open strconn
conn.CommandTimeout = 20
这是我的数据库连接代码
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strconn As String
Dim sql As String
strconn = "provider=SQLOLEDB.1;server=GL-PC;persist security info=false;UID=sa;pwd=415024522;database=Drug"
conn.Open strconn
conn.CommandTimeout = 20
Dim rs As New ADODB.Recordset
Dim strconn As String
Dim sql As String,UID as string,PWD as string
UID=txtUserName:PWD=txtPassword
strconn = "provider=SQLOLEDB.1;server=GL-PC;persist security info=false;UID=" & UID & ";pwd=" & PWD & ";database=Drug"
conn.Open strconn
conn.CommandTimeout = 20