topic Re: Scheduled job with OLAP connectivity in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Scheduled-job-with-OLAP-connectivity/m-p/129087#M10600 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">The usual way to force a database connection is to use the NOPROMPT option. This is how you do it via a CONNECT statement if you are using ODBC to connect to SQL Server and are using Windows authentification, assuming your SAS server runs on Windows:</SPAN></P><P></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 9pt;">connect to odbc (noprompt = </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple; font-size: 9pt;">"server=MySQLserver;DRIVER=SQL Server;Trusted Connection=yes;DATABASE=Mydatabase;"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 9pt;">&nbsp; readbuff = </SPAN><SPAN style="color: teal; font-size: 9pt; background: white; font-family: 'Courier New';"><STRONG>32767</STRONG></SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 9pt;">);</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; background: white; color: black; font-size: 10pt;">If you want more specific help then you need to provide details of how you connect to your SQL Server database.</SPAN></P></BODY></HTML> Sun, 18 Nov 2012 19:17:52 GMT SASKiwi 2012-11-18T19:17:52Z Scheduled job with OLAP connectivity https://communities.sas.com/t5/SAS-Enterprise-Guide/Scheduled-job-with-OLAP-connectivity/m-p/129086#M10599 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>I have an EGUIDE 4.3 project that has MSOLAP cube connectivity and a slice output to a dataset. When I run it as a scheduled job, it prompts me for the OLAP Cube connection information. Is there a way to "force" a connection for this project. The schedules job will not run until the connection information is supplied.</P><P></P><P>Thanks,</P><P>Chris</P></BODY></HTML> Sat, 17 Nov 2012 05:51:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Scheduled-job-with-OLAP-connectivity/m-p/129086#M10599 CPAZ 2012-11-17T05:51:16Z Re: Scheduled job with OLAP connectivity https://communities.sas.com/t5/SAS-Enterprise-Guide/Scheduled-job-with-OLAP-connectivity/m-p/129087#M10600 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">The usual way to force a database connection is to use the NOPROMPT option. This is how you do it via a CONNECT statement if you are using ODBC to connect to SQL Server and are using Windows authentification, assuming your SAS server runs on Windows:</SPAN></P><P></P><P><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 9pt;">connect to odbc (noprompt = </SPAN><SPAN style="font-family: 'Courier New'; background: white; color: purple; font-size: 9pt;">"server=MySQLserver;DRIVER=SQL Server;Trusted Connection=yes;DATABASE=Mydatabase;"</SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 9pt;">&nbsp; readbuff = </SPAN><SPAN style="color: teal; font-size: 9pt; background: white; font-family: 'Courier New';"><STRONG>32767</STRONG></SPAN><SPAN style="font-family: 'Courier New'; background: white; color: black; font-size: 9pt;">);</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; background: white; color: black; font-size: 10pt;">If you want more specific help then you need to provide details of how you connect to your SQL Server database.</SPAN></P></BODY></HTML> Sun, 18 Nov 2012 19:17:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Scheduled-job-with-OLAP-connectivity/m-p/129087#M10600 SASKiwi 2012-11-18T19:17:52Z