VBScript 直接连接Oracle数据库
'----------------------------------------------------
' Connect to oracle instance without tnsnames.ora
'-----------------------------------------------------
Dim strCon: strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=10.88.46.10)(PORT=11601))" & _
"(CONNECT_DATA=(SERVICE_NAME=hesit))); uid=apps;pwd=appsapps;"
'Dim strCon: strCon = "Driver={Microsoft ODBC for Oracle}; " & _
' "CONNECTSTRING=CCMDBT; uid=readall;pwd=read;"
Dim oCon: Set oCon = WScript.CreateObject("ADODB.Connection")
Dim oRs: Set oRs = WScript.CreateObject("ADODB.Recordset")
oCon.Open strCon
Set oRs = oCon.Execute("select * from cper.hr_oa_salary_temp where rownum < 2")
While Not oRs.EOF
WSCript.Echo oRs.Fields(0).Value
oRs.MoveNext
Wend
oCon.Close
Set oRs = Nothing
Set oCon = Nothing
vbs连接sql server vbs连接oracle
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章