Oracle DSN Less Connection String

[udeman webforumsuser@macromedia.com]

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!!!

[danilocelic]

"udeman" [email]webforumsuser@macromedia.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]