BookmarkSubscribeRSS Feed
PabloJ
Fluorite | Level 6

Hi all, 


I am not able to connect to "Kx kdb+ q" server through SAS.


I can connect via isql command from linux server where is SAS installed but when I try to connect trhough SAS I get the following error: 

 
ERROR: CLI error trying to establish connection: [unixODBC][q][ODBC]host:port
ERROR: Error in the LIBNAME statement.

I tried with a "Libname" sentence. 

libname kxtmp odbc datasrc=MyDSN UID=xxxx PWD='xxxxxxxx';
 

Can anyone help me to solve this? 
qodbc3 driver is compatible with sas environment? 

Thanks in advance

 


1 REPLY 1
ChrisNZ
Tourmaline | Level 20
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 874 views
  • 0 likes
  • 2 in conversation