Professional Web Applications Themes

Oracle DSN Less Connection String - Macromedia Dreamweaver

Greetings.... Okay so far Dreamweaver MX connection to Oracle has left an awful bitter taste in my mouth.... I am trying a DSN Less Oracle connection...... I am using connection strings in various applications for Oracle other than Dreamweaver and they work fine.......but in Dreamweaver MX, the same connection string gives me an "ORA-12154: TNS: could not resolve service name" error. My page DOES WORK when I hand code the connection, but when I use the custom connection string panel from the Application panel, I get the error "ORA-12154: TNS: could not resolve service name". I have tried several different ...

  1. #1

    Default Oracle DSN Less Connection String

    Greetings....

    Okay so far Dreamweaver MX connection to Oracle has left an awful bitter taste in my mouth....
    I am trying a DSN Less Oracle connection......
    I am using connection strings in various applications for Oracle other than Dreamweaver and they work fine.......but in Dreamweaver MX, the same connection string gives me an "ORA-12154: TNS: could not resolve service name" error.

    My page DOES WORK when I hand code the connection, but when I use the custom connection string panel from the Application panel, I get the error "ORA-12154: TNS: could not resolve service name".

    I have tried several different connection strings which work in all of the applications I work in, but they simply don't work in Dreamweaver MX....

    Here is the connection string....
    Provider=MSDAORA.1;Password=test;User ID=test;Data Source=test;Persist Security Info=True

    I used the word "test" in place of user id, password, and datasource.......
    In the connection name, I used the datasource name....so, in this case...."test"

    I also checked off, "Using driver on this machine", and I've tried, "Using driver on testing server"...
    neither works.....

    I've also downloaded patch 6.1 because I was at the end of my obvious solutions.....

    I am stumped.....I'm sure it's something I'm doing wrong, but it sure is not obvious whatever
    it is.......any help would be so much appreciated.......thanks, and always....dreamon!!!



    udeman webforumsuser@macromedia.com Guest

  2. #2

    Default Re: Oracle DSN Less Connection String

    "udeman" [email]webforumsusermacromedia.com[/email] wrote:
    > Here is the connection string....
    > Provider=MSDAORA.1;Password=test;User ID=test;Data Source=test;Persist Security Info=True
    This page:
    [url]http://www.dwteam.com/Articles/ado/index.asp[/url]
    Lists a different ODBC dsn-less connection string.

    Can't help any further than that, sorry.

    --
    Enjoy,
    Danilo Celic

    | Extending Knowledge, Daily
    | [url]http://www.CommunityMX.com/[/url]

    danilocelic Guest

Similar Threads

  1. DSN connection and Oracle 9i
    By eerrty in forum Coldfusion Server Administration
    Replies: 0
    Last Post: March 25th, 02:12 PM
  2. Connect to Oracle DB using Connection String
    By CFRAM in forum Coldfusion Database Access
    Replies: 4
    Last Post: February 20th, 03:14 AM
  3. OLEDB COnnection String to Oracle
    By Jon Spartan in forum ASP Database
    Replies: 5
    Last Post: July 31st, 10:19 PM
  4. Replies: 1
    Last Post: July 17th, 03:23 PM
  5. Oracle ADO connection
    By Beaux in forum Oracle Server
    Replies: 1
    Last Post: December 6th, 07:45 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139