set oracle connectiong

来源:互联网 发布:淘宝网聊天工具是啥 编辑:程序博客网 时间:2024/05/16 04:55

Set con=createobject("adodb.connection")
        con.open "DRIVER={Oracle in
OraHome92};SERVER=CESHI;UID=CND_TEST;PWD=CND;DBQ=CESHI;DefaultDir=C:/Progra­m
Files/Common Files/ODBC/Data Sources/cnd_test.dsn;"
        Set rs=createobject("adodb.recordset")
        sql="select
manualcode,babyname,sex,birthday,nativedetail,fathername,mothername
from chr_bornregister  where fathername='"&MyFather&"'"

        rs.Open sql,con,1,3

原创粉丝点击