Sub 尝试VBA连接SQL()
excel是2010
sql 是 2008r2
代码如下
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim constr As String
Dim sqlstr As String
constr = "provider=sqlncli10.1;persist security info=false;initial catalog=yearsallshow;user id=sa;pwd=psw;data source=服务器名"
cnn.Open constr
sqlstr = "select * from total_pytj"
rs.Open sqlstr, cnn
Sheet2.Range("a1").CopyFromRecordset rs
rs.Close
cnn.Close
End Sub
问题到底出在哪里呢??
67表示主æºå°åé误ï¼ä½ ä¸é¢è¯å¥ä¸çãæå¡å¨åãè¦ä¿®æ¹æå¡å¨çæºå¨åãååæè IPå°åã
constr = "provider=sqlncli10.1;persist security info=false;initial catalog=yearsallshow;user id=sa;pwd=psw;data source=æå¡å¨å"
ææé误代ç çå«ä¹è§è¿æ¥ç½é¡µï¼ç½é¡µé¾æ¥
追é®æåæ¥æ¹å®äºï¼å¯æ¯åæ示é误代ç [2]
nitial catalog= æ¯åå®ä¾åï¼è¿æ¯æåæ¥create databaseèªå·±å»ºçæ°æ®åºçååå¢ï¼