Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Unanswered: Oracle connection string

    Hi everyone,

    How can I specify a connection string for an Oracle database without a DSN. I want to use the Oracle driver. However, I cannot figure out how to specify it.

    I know I can specify it to use the Microsoft driver as:
    Driver={Microsoft ODBC for Oracle}; Server=server.db; Uid=name; Pwd=pass;

    However, my stored procedures do not work with this driver. I would like to use the Oracle driver. What is the driver connection string for using it?

    Thanks,
    Pankaj

  2. #2
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    Maybe you should try http://www.connectionstrings.com/?

  3. #3
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35
    Ya, but they only show how to use the Microsoft ODBC drivers.

    Thanx,
    Pankaj

  4. #4
    Join Date
    Sep 2003
    Location
    CA
    Posts
    38
    hope this helps
    jdbc: oracle:thin:@(DESCRIPTION=" +
    "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ec t-sun.ecst.csuchico.edu)" +
    "(PORT=1521)))(CONNECT_DATA=(SID=ecstDB)(SERVER=DE DICATED)

  5. #5
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    You're right.

    Maybe this will work:
    Driver={Oracle in OraHome9i};SID=your_sid;HOST=your_host;PORT=your_p ort;Uid=username;Pwd=password"
    Of course ,,Oracle in OraHome9i'' is my driver's name - you have to enter yours...
    Last edited by HrabiaGrzegorz; 07-08-04 at 04:06.

  6. #6
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35
    Hi,

    Thanks for replying. This, of course works. However, I will have to install this thing on a remote machine and I will not have the exact OraHome param. I do not know why Oracle does this. Why can they not use a specific string for 9i drivers? Why do you have to use Oracle in <<oraHomeName>>. This just seems stupid, unless I am missing something.

    Sincerely,
    Pankaj

Posting Permissions

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