Oracle Connection Syntax

[MrStiffler]

I want to connect from an merc 6.5 to an Oracle Server on a different machine (both are Unix Soraris).

I work without mdq files. So on a simple output card of the map, i have a DBLOOKUP like this :

DBLOOKUP("SELECT * FROM mytable", "-DBTYPE ORACLE -CONNECT domain.server.com -USER myusername -PASSWORD myuserpassword" )

I always become a error code -1005, which means:
Failed to connect to the database

Is something with the sintax wrong ?
there is no other special input or output.
All this stuff work from a local NT pc !
can you help me ?
greets stiffler

 

[janhes]

You need to set the -T parameter to get a trace file to determin the cause of the failed connection. -T creates a .dbl trace file
Jan

 

[MrStiffler]

Okey thanks, i got this trace message:

<26820-351>: Validating the adapter command...
<26820-351>: Database type is Oracle
<26820-352>: Connecting...
<26820-352>: Host string: domain.host.com
<26820-352>: UserID : user
<26820-352>: Password : ****
<26820-352>: Error in: OCIServerAttach
Message : Error while trying to retrieve text for error ORA-12154

<26820-352>: Oracle connect failed.
<26820-352>: Returned status: (-1005) Failed to connect to the database

Do you have an idea what could be the problem ?

 

[janhes]

I think this is when the database isn't in your TNS names on the server

 

[BocaBurger]

Can you run SPLPlus from the Mercator/bin directory with the log in a pw you have in the map?

BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!