Connect to Oracle 7.3.4 with Macromedia UltraDev MX.
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