11-17-2012 12:51 AM
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.
11-18-2012 02:17 PM
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:
connect to odbc (noprompt = "server=MySQLserver;DRIVER=SQL Server;Trusted Connection=yes;DATABASE=Mydatabase;" readbuff = 32767);
If you want more specific help then you need to provide details of how you connect to your SQL Server database.