Your SAS programs, embedded in web apps and elsewhere

Remote connect to informix client

Reply
N/A
Posts: 1

Remote connect to informix client

Hi Friends,

My applicaton requires to fetch the data from informix database but i dont have informix client on my system. I tried to connect to informix remotely from the informix client which is located at other system using rsubmit as well as using RSPT but i was getting the below error.

Using rsubmit:

options sascmd="sas";

%let sashost=nnnn.shn.com;

signon sashost;

rsubmit sashost;

proc sql;

connect to informix as abc (user='userid' using='passwd' server=inormix-server-name);

select * from connection to abc

(select count(*) from db_table);

quit;

ENDRSUBMIT;

ERROR: The product with which the engine INFORMIX is associated is either not

       licensed for your system or the product license has expired. Please

       contact your SAS installation representative.

ERROR: A Connection to the informix DBMS is not currently supported, or is

       not installed at your site.

Using RSPT:

proc sql;

connect to remote as abc(server=sashost dbms=informix dbmsarg=(user='userid' using='passwd' server=inormix-server-name));

select * from connection to abc

select count(*) from dagent);

ERROR: A Connection to the INFORMIX DBMS is not currently supported, or is

not installed at your site.

Can someone please look into this and help me out regarding the same

Ask a Question
Discussion stats
  • 0 replies
  • 435 views
  • 0 likes
  • 1 in conversation