vbscript通过ODBC访问mySQL

 vbscript通过ODBC访问mySQL

先安装mysql-connector-odbc-3.51.12-win32

脚本写法如下
Set cn = CreateObject("ADODB.Connection")
             strCn = "driver=MySQL ODBC 3.51 Driver;" & _
                                     "server=127.0.0.1;" & _
                                     "database=12355;" & _
                                     "uid=root;" & _
                                     "pwd="
cn.Open strCn

str = "set names 'latin1'"
cn.Execute str
str = "insert into  cti_record(SessionId,RecordFile) values('" & strSessionId  & "','" & strRecordFile1  & "')"

'msgbox str

cn.Execute str