Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    20

    Unanswered: vba-connection oracle

    hi guys, i want to connect my vba application to oracle db, i try with this code, but i have problems.
    my oracle is a 7.3..

    Public Sub ApriConn2()
    ConnStr = "ODBC;DSN=ISC.ISCWEB;DATABASE=DITTALDM;"
    ConnStr = ConnStr & "UID=" & sigla & ";"
    ConnStr = ConnStr & "PWD=" & sigla & ";"
    'strCnn = "driver={Microsoft ODBC For Oracle}; server=ISC;" & _
    '"uid=DITTALDM;pwd=DITTALDM:database=DITTALDM"
    Set cnn = New ADODB.connection
    cnn.Open strconn
    End Sub

    i know is very old, but...that is it .-)

  2. #2
    Join Date
    Oct 2004
    Posts
    3
    Use this connectionstring.

    Cnn.ConnectionString = "Provider=MSDAORA;Data Source=meh_magma;" & _
    "User ID=username; Password=password"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •