Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    53

    Talking Unanswered: Linking Oracle to Access with DSN

    Hello Everyone,

    I'm truly stuck.

    My small Access database is linked to mulitple tables in my large Oracle database.

    I want to have the Oracle database update the Access Database on a daily basis.

    This works great for my needs, but I want to do it "behind the scenes" multiple times daily.

    I set up the Access Database to launch multiple times daily using the autoexec feature to set off the job.

    The problem I have is that it prompts me for my Oracle Database (DSN)Password each time it connects to Oracle.

    Is there a way I can code around this prompt. I have coded a module to run at autoexec that is connecting to my Oracle Database when the job runs, but I still am prompted for the password when the update query runs.

    I am using the following code in my module.

    Dim oConn as New Connection

    oConn.Open "DSN=mySystemDSN;" & _
    "Uid=myUsername;" & _
    "Pwd=myPassword

    (I have tested this by creating a recordset)


    Thanks for any help you can offer
    Jason
    Jason

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    62

    Thumbs up

    What about setting the password at he time of creation of the DSN
    in ODBC ?
    In your code, just don't specify the user name and password.
    Just specify the DSN.
    Last edited by Rushi; 01-07-04 at 07:34.
    Regards,

    Rushi

  3. #3
    Join Date
    Jan 2004
    Posts
    53

    Talking

    Originally posted by Rushi
    What about setting the password at he time of creation of the DSN
    in ODBC ?
    In your code, just don't specify the user name and password.
    Just specify the DSN.
    That would be great!
    I cannot find where to specify in the builder/wizard.

    Thanks
    Jason

Posting Permissions

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