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

    Unanswered: connection access/oracle

    hi guys
    help me please...
    I want to connect my access applicaton to oralce, but i have a error: TNS: no listener, but my name service (my TNS )is ISC!

    ConnStr = "DSN=DITTALDM;" & _
    "TNS=ISC;" & _
    "UID=DITTALDM;" & _
    "PWD=DITTALDM;"
    Set cnn = New ADODB.connection
    If (cnn = Null) Then
    MsgBox ("errore")
    Else
    cnn.Open ConnStr
    End If
    End Sub


    My Data source Name is DITTALDM
    My TNS is ISC
    My UID is DITTALDM
    My PWD is DITTALDM


    thanks fr

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Once again ... Check out the ODBC driver for Oracle at: http://www.connectionstrings.com/
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Nov 2003
    Posts
    20
    sorry guy i try all afternoon and i look araund internet... may be i realy stupid!!!
    but.. nothing nothing nothing

    if you can halp me...I kiss you .-)

Posting Permissions

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