DATAFlux 2.7 Oracle Direct Connection error

[SalmanSohail]

Hello Everyone,

When I tried to connect Oracle TSN directly from DataFlux 2,7 Studio.  I get errors:

However, if try the same on Toad DATA studio, I can see the Oracle DATAbase Connected.

1. Oracle Connection String on SAS Data studio

libname oralib1 oracle path="(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XYZ.SARIYAGROUP.ORG) (PORT=1521)) (CONNECT_DATA= (SID=HSP)))"

2. I tried second method Oracle Connection String in SAS Data studio

"(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=XYZ.SARIYAGROUP.ORG) (PORT=1521)) (CONNECT_DATA= (SID=HSP)))"

Any suggestions are highly appreciated.

[LouGalway_sas]

Your example looks like you are writing a SAS libname statement, but your subject mentions DataFlux.

If you are trying to write a libname statement in SAS Studio make sure you have all the required components of the libname statement.  You example seem to be missing the user= and pw= components.  Here is an example from the SAS documentation:

This example connects to Oracle without updating the TNSNAMES.ORA file.

libname x oracle user=myusr1 pw=mypwd1 
  path="(DESCRIPTION= 
          (ADDRESS_LIST=
            (ADDRESS= (PROTOCOL=TCP)(HOST=pinkfloyd)(PORT=1521))
             )
              (CONNECT_DATA= 
       "  	     (SID=alien)
       "   )
       " )
       " ";

If you would like additional information you can use this link:

http://go.documentation.sas.com/?docsetId=acreldb&docsetTarget=p1qft7bzdij79zn1bxh59mc3w8xj.htm&docs...

If you trying to connect to Oracle from SAS Data Management Studio (Datafulx) then you can find more information here:

http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.6/dmpdmsug/Content/dfU_T_DataConnOver.ht...

Good Luck!

[SalmanSohail · Accepted solution]

The last five lines showing lots of (") open and close apostrophes, is that required?

 "       (SID=alien)
       "   )
       " )
       " ";

[LouGalway_sas]

Yes, according to the documentation.