Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: permanent connection to ORACLE with pass & user

    I wanted to know if i can stablish a permanent connection to an oracle db, i've the DNS but i need that the db don't query me about user and passw.

    thnx, 4 all.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    What you want is a DSN-less connection. You should be able to find information on Microsoft.com. But the easiest way I have found to create one is to use a DSN to connect to the database. Then design the link that was created and view the properties of the Link. It will give you a warning that says you cannot make changes, but if you look at the Properties and the Description it will show you the connection string (which is the key). I don't remember, but I think if you use a DSN with User and Password it will show you the variable names to use. If not then I would try USER and PWD as typical variable names. You can use a macro to help you get the syntax correct.

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    Thnx for the answer, i forgot to say that i need to do it in a ms-access database... it's possible? using this information in microsoft page?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Check this site out: http://www.connectionstrings.com/

    It has some oracle connectors ...
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

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