topic Re: Access SAS 9.2 using a JDBC connection ? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91140#M19262 <HTML><HEAD></HEAD><BODY><P>You can only make a jdbc connection if your site has SAS/Share licensed and setup.</P></BODY></HTML> Tue, 24 Sep 2013 15:55:21 GMT FriedEgg 2013-09-24T15:55:21Z Access SAS 9.2 using a JDBC connection ? https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91139#M19261 <HTML><HEAD></HEAD><BODY><P>How can I access SAS 9.2 using JDBC connection?</P><P></P><P>I have installed the<A href="http://support.sas.com/demosdownloads/license.jsp?productID=110265"> jdbc drivers for Windows</A>&nbsp; but I don't know where they can be found on the file system and how they can be called by a third party tool. </P><P></P><P>What ports are required to be opened?</P><P></P><P>What is the JDBC syntax to access SAS (Metadata server ?)</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Tue, 24 Sep 2013 06:53:30 GMT https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91139#M19261 apolodor 2013-09-24T06:53:30Z Re: Access SAS 9.2 using a JDBC connection ? https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91140#M19262 <HTML><HEAD></HEAD><BODY><P>You can only make a jdbc connection if your site has SAS/Share licensed and setup.</P></BODY></HTML> Tue, 24 Sep 2013 15:55:21 GMT https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91140#M19262 FriedEgg 2013-09-24T15:55:21Z Re: Access SAS 9.2 using a JDBC connection ? https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91141#M19263 <HTML><HEAD></HEAD><BODY><P>Thanks for this hint but my question was quite different...</P></BODY></HTML> Wed, 25 Sep 2013 06:47:22 GMT https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91141#M19263 apolodor 2013-09-25T06:47:22Z Re: Access SAS 9.2 using a JDBC connection ? https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91142#M19264 <HTML><HEAD></HEAD><BODY><P>Take a look at the JDBC Cookbook for syntax and examples of using the drivers.&nbsp; Can you give more specific details of what you are trying to accomplish, otherwise cannot provide specific help.</P><P></P><P></P><P><A href="http://support.sas.com/documentation/cdl/en/jdbcref/59666/PDF/default/jdbcref.pdf" title="http://support.sas.com/documentation/cdl/en/jdbcref/59666/PDF/default/jdbcref.pdf">http://support.sas.com/documentation/cdl/en/jdbcref/59666/PDF/default/jdbcref.pdf</A></P></BODY></HTML> Wed, 25 Sep 2013 15:39:35 GMT https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91142#M19264 FriedEgg 2013-09-25T15:39:35Z Re: Access SAS 9.2 using a JDBC connection ? https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91143#M19265 <HTML><HEAD></HEAD><BODY><P>Found this page with useful info: <A href="http://support.sas.com/demosdownloads/000355/readme_108274.html">http://support.sas.com/demosdownloads/000355/readme_108274.html</A><A title="http://support.sas.com/demosdownloads/000355/readme_108274.html"> </A><A title="http://support.sas.com/demosdownloads/000355/readme_108274.html"> </A></P><P></P><P>I am trying to access SAS data using a third party tool.</P></BODY></HTML> Thu, 26 Sep 2013 07:44:30 GMT https://communities.sas.com/t5/SAS-Programming/Access-SAS-9-2-using-a-JDBC-connection/m-p/91143#M19265 apolodor 2013-09-26T07:44:30Z