strConnection = _T("Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=test");

解决方案 »

  1.   

    ODBC:
    oConn.Open "Driver={Oracle ODBC Driver};" & _
               "Dbq=myDBName;" & _
               "Uid=myUsername;" & _
               "Pwd=myPassword"OLEDB:
    oConn.Open "Provider=OraOLEDB.Oracle;" & _
               "Data Source=MyOracleDB;" & _ 
               "User Id=myUsername;" & _
               "Password=myPassword"
    see more at
    http://www.able-consulting.com/ADO_Conn.htm
      

  2.   

    saucer的星星又涨了,希望常来这里啊
      

  3.   

    1、Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=timecard;Data Source=bosweb;Extended Properties=""2、Provider=MSDAORA;Password=timecard;User ID=timecard;Data Source=bosweb