Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connect to Oracle 7.3.4 with Macromedia UltraDev MX.

372568Nov 19 2002
I am attempting to connect to an Oracle 7.3.4 database from Macromedia UltraDev MX.
I keep getting the following message during "Test Connection in DSN" in DW MX:

[NA000] [ORA-12154:] TNS:could not resolve service name
[IM006] [Microsoft][ODBC Driver Manager] Error for SQLSetConnectAttr-Call Driver. (0)

In SQL-LOG you found:
Dreamweaver 480-408 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
SQLPOINTER [Unknown attribute 1041]
ODBC driver for Oracle Version 2.573.7400.00 (MSORCL32.DLL)

It SHOULD work because I have already tested the following:

1. Set up the TNS entry for the database, and was able to connect to it via SQLPlus.
2. Set up the ODBC datasource, and was able to connect to it using the same DSN with Oracle ODBC Test utility.
3. Set up the ODBC datasource, and was able to connect to it using the same DSN with Oracle ODBC from Crystal-Report-Designer.
4. Connected to the Oracle server and Table from Microsoft-Access linking to the same DSN ODBC datasource.

----
System: Windows 2000 SP2 and MDAC 2.6 (SP2)
Driver: msorcl32.dll
tested with:
- Microsoft Data Access - ODBC-Treiber for Oracle Version: 2.573.6526.0
and
- Oracle ODBC-Treiber 8.01.07.00

Macromedia UltraDev Support wrote, this is problem of Oracle-Drivers for ODBC ??!

Any hints and thanks 4 help
Roland
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2002
Added on Nov 19 2002
3 comments
1,000 views