![]() I need to create an identical copy of sashelp.class on Azure.Ĭreate table azure.class like sashelp.class Where I copy sashelp.class to my Azure database. Libname azure odbc NOPROMPT=”Driver=ODBC Driver 11 for SQL Timeout=30 ” schema= īelow I have made an example. This has only worked for me when I use one of the new ODBC-drivers for Microsoft SQL-server eg. ![]() Here you can eg find the connection string for an ODBC connection and use it in your libname statement for SAS. As shown below you need to choose ‘View SQL Database connection strings’. It is possible to get different connection strings for your SQL-database on Azure. On the server you go to the Configure-tab and enter the IP-adress that has to access the SQL-server. It is on this server, that you need to open for the different IP that need access to the SQL-server.Īs shown below you go to the Servers-tab and click on the server where you want to change the firewall settings. When you create an SQL-server database it will also create a virtual server.The servername for the virtual server is the “funny” name eg. This post shows how it is possible to connect to an SQL-server server/database (PaaS) in Windows Azure from SAS.įirst of all you need to create a SQL-server database. Hector on Disable fair sharing in Windows Server.Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator - Boot Panic on How to install and configure DB2 ODBC driver. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |