https://communities.sas.com/t5/Developers/connect-ODBC-dsn-via-libname-function/m-p/2608#M1648 Hi!<BR /> If you are using SAS in a Stored Process, remember that your library should be defined in the metadata. When you define your data libraries in the metadata, they do not have to be SAS libraries, there is a way to define ODBC libraries. You should contact Tech Support for help in setting up the metadata.<BR /> <BR /> If you are NOT using SAS in a Stored Process, then this documentation on ODBC has an example of a LIBNAME statement on page 7:<BR /> <A href="http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_odbc_7365.pdf" target="_blank">http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_odbc_7365.pdf</A><BR /> <BR /> There is some setup that has to be done before you can just use the LIBNAME statement, however. So, again, Tech Support is your best bet for help with this setup.<BR /> <BR /> Good luck!<BR /> <BR /> cynthia<BR /> <BR /> To contact Tech Support, refer to: <A href="http://support.sas.com/techsup/contact/index.html" target="_blank">http://support.sas.com/techsup/contact/index.html</A> Fri, 23 Mar 2007 16:50:18 GMT Cynthia_sas 2007-03-23T16:50:18Z https://communities.sas.com/t5/Developers/connect-ODBC-dsn-via-libname-function/m-p/2607#M1647 Hi All,<BR /> Just do me ur favor, anyone know 'any code' that we can use to connect ODBC (dsn) via libname function. <BR /> Thank Fri, 23 Mar 2007 16:02:22 GMT https://communities.sas.com/t5/Developers/connect-ODBC-dsn-via-libname-function/m-p/2607#M1647 deleted_user 2007-03-23T16:02:22Z https://communities.sas.com/t5/Developers/connect-ODBC-dsn-via-libname-function/m-p/2608#M1648 Hi!<BR /> If you are using SAS in a Stored Process, remember that your library should be defined in the metadata. When you define your data libraries in the metadata, they do not have to be SAS libraries, there is a way to define ODBC libraries. You should contact Tech Support for help in setting up the metadata.<BR /> <BR /> If you are NOT using SAS in a Stored Process, then this documentation on ODBC has an example of a LIBNAME statement on page 7:<BR /> <A href="http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_odbc_7365.pdf" target="_blank">http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_odbc_7365.pdf</A><BR /> <BR /> There is some setup that has to be done before you can just use the LIBNAME statement, however. So, again, Tech Support is your best bet for help with this setup.<BR /> <BR /> Good luck!<BR /> <BR /> cynthia<BR /> <BR /> To contact Tech Support, refer to: <A href="http://support.sas.com/techsup/contact/index.html" target="_blank">http://support.sas.com/techsup/contact/index.html</A> Fri, 23 Mar 2007 16:50:18 GMT https://communities.sas.com/t5/Developers/connect-ODBC-dsn-via-libname-function/m-p/2608#M1648 Cynthia_sas 2007-03-23T16:50:18Z