topic qodbc3 connection in SAS Programming https://communities.sas.com/t5/SAS-Programming/qodbc3-connection/m-p/545162#M150798 <P>Hi all,&nbsp;</P><P><BR />I am not able to connect to "Kx kdb+ q" server through SAS.</P><P><BR />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:&nbsp;</P><DIV class="dijitBorderContainer dijitContainer row-fluid dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer row-fluid dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer dijitLayoutContainer dojoDndTarget sasStudioTabsParentContainer dojoDndContainerOver"><DIV class="dijitTabContainer dijitTabContainerTop dijitContainer dijitLayoutContainer tabStrip-disabled sasStudioTabsTabContainer sasStudioTabsTabContainerVertical sasStudioTabsTop dijitBorderContainer-child dijitBorderContainer-dijitTabContainerTop dijitBorderContainerPane dijitAlignCenter"><DIV class="dijitTabPaneWrapper dijitTabContainerTop-container dijitAlignCenter"><DIV class="dijitTabContainerTopChildWrapper dijitVisible"><DIV class="dijitBorderContainer dijitContainer sasStudioTabsTabContainerChild dijitTabPane dijitTabContainerTop-child dijitTabContainerTop-dijitBorderContainer dijitLayoutContainer"><DIV class="dijitBorderContainer dijitContainer dijitBorderContainer-child dijitBorderContainer-dijitBorderContainer dijitBorderContainerPane dijitAlignCenter dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer dijitLayoutContainer dojoDndTarget dojoDndContainerOver"><DIV class="dijitTabContainer dijitTabContainerTop dijitContainer dijitLayoutContainer tabStrip-disabled taskTabContainer dijitBorderContainer-child dijitBorderContainer-dijitTabContainerTop dijitBorderContainerPane dijitAlignCenter"><DIV class="dijitTabPaneWrapper dijitTabContainerTop-container dijitAlignCenter"><DIV class="dijitTabContainerTopChildWrapper dijitVisible"><DIV class="dijitBorderContainer dijitContainer dijitTabPane dijitTabContainerTop-child dijitTabContainerTop-dijitBorderContainer dijitLayoutContainer"><DIV class="dijitBorderContainer dijitContainer dijitBorderContainer-child dijitBorderContainer-dijitBorderContainer dijitBorderContainerPane dijitAlignCenter dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter"><DIV class="sasError">&nbsp;</DIV><DIV class="sasError">ERROR: CLI error trying to establish connection: [unixODBC][q][ODBC]host:port</DIV><DIV class="sasError">ERROR: Error in the LIBNAME statement.<BR /><BR />I tried with a "Libname" sentence.&nbsp;<BR /><BR />libname kxtmp odbc datasrc=MyDSN UID=xxxx PWD='xxxxxxxx';</DIV><DIV class="sasError">&nbsp;</DIV><DIV class="sasError"><BR />Can anyone help me to solve this?&nbsp;<BR />qodbc3 driver is compatible with sas environment?&nbsp;</DIV><DIV class="sasError"><BR />Thanks in advance</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>&nbsp;<BR /><BR /><BR /></P> Fri, 22 Mar 2019 09:39:58 GMT PabloJ 2019-03-22T09:39:58Z qodbc3 connection https://communities.sas.com/t5/SAS-Programming/qodbc3-connection/m-p/545162#M150798 <P>Hi all,&nbsp;</P><P><BR />I am not able to connect to "Kx kdb+ q" server through SAS.</P><P><BR />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:&nbsp;</P><DIV class="dijitBorderContainer dijitContainer row-fluid dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer row-fluid dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer dijitLayoutContainer dojoDndTarget sasStudioTabsParentContainer dojoDndContainerOver"><DIV class="dijitTabContainer dijitTabContainerTop dijitContainer dijitLayoutContainer tabStrip-disabled sasStudioTabsTabContainer sasStudioTabsTabContainerVertical sasStudioTabsTop dijitBorderContainer-child dijitBorderContainer-dijitTabContainerTop dijitBorderContainerPane dijitAlignCenter"><DIV class="dijitTabPaneWrapper dijitTabContainerTop-container dijitAlignCenter"><DIV class="dijitTabContainerTopChildWrapper dijitVisible"><DIV class="dijitBorderContainer dijitContainer sasStudioTabsTabContainerChild dijitTabPane dijitTabContainerTop-child dijitTabContainerTop-dijitBorderContainer dijitLayoutContainer"><DIV class="dijitBorderContainer dijitContainer dijitBorderContainer-child dijitBorderContainer-dijitBorderContainer dijitBorderContainerPane dijitAlignCenter dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter dijitContentPaneSingleChild"><DIV class="dijitBorderContainer dijitContainer dijitLayoutContainer dojoDndTarget dojoDndContainerOver"><DIV class="dijitTabContainer dijitTabContainerTop dijitContainer dijitLayoutContainer tabStrip-disabled taskTabContainer dijitBorderContainer-child dijitBorderContainer-dijitTabContainerTop dijitBorderContainerPane dijitAlignCenter"><DIV class="dijitTabPaneWrapper dijitTabContainerTop-container dijitAlignCenter"><DIV class="dijitTabContainerTopChildWrapper dijitVisible"><DIV class="dijitBorderContainer dijitContainer dijitTabPane dijitTabContainerTop-child dijitTabContainerTop-dijitBorderContainer dijitLayoutContainer"><DIV class="dijitBorderContainer dijitContainer dijitBorderContainer-child dijitBorderContainer-dijitBorderContainer dijitBorderContainerPane dijitAlignCenter dijitLayoutContainer"><DIV class="dijitContentPane dijitBorderContainer-child dijitBorderContainer-dijitContentPane dijitBorderContainerPane dijitAlignCenter"><DIV class="sasError">&nbsp;</DIV><DIV class="sasError">ERROR: CLI error trying to establish connection: [unixODBC][q][ODBC]host:port</DIV><DIV class="sasError">ERROR: Error in the LIBNAME statement.<BR /><BR />I tried with a "Libname" sentence.&nbsp;<BR /><BR />libname kxtmp odbc datasrc=MyDSN UID=xxxx PWD='xxxxxxxx';</DIV><DIV class="sasError">&nbsp;</DIV><DIV class="sasError"><BR />Can anyone help me to solve this?&nbsp;<BR />qodbc3 driver is compatible with sas environment?&nbsp;</DIV><DIV class="sasError"><BR />Thanks in advance</DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV><P>&nbsp;<BR /><BR /><BR /></P> Fri, 22 Mar 2019 09:39:58 GMT https://communities.sas.com/t5/SAS-Programming/qodbc3-connection/m-p/545162#M150798 PabloJ 2019-03-22T09:39:58Z Re: qodbc3 connection https://communities.sas.com/t5/SAS-Programming/qodbc3-connection/m-p/545631#M150974 <P>Have you tried using the <FONT face="courier new,courier">noprompt</FONT> option?</P> <P>&nbsp;</P> <P>Have you tried using the <FONT face="courier new,courier">filedsn</FONT> option ? See:</P> <P><A href="http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p0bu3zsz1a08ton1msxdx1jo45np.htm" target="_blank">http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p0bu3zsz1a08ton1msxdx1jo45np.htm</A></P> <P>&nbsp;</P> <P>Have you read the similar questions and answers here? Like:</P> <P><A href="https://communities.sas.com/t5/SAS-Procedures/LIBNAME-ODBC-with-NOPROMPT-option-on-Unix/td-p/199696" target="_blank">https://communities.sas.com/t5/SAS-Procedures/LIBNAME-ODBC-with-NOPROMPT-option-on-Unix/td-p/199696</A></P> Sun, 24 Mar 2019 21:09:39 GMT https://communities.sas.com/t5/SAS-Programming/qodbc3-connection/m-p/545631#M150974 ChrisNZ 2019-03-24T21:09:39Z