topic SAS ODBC local server initiate from a program running as Windows Service in SAS Procedures

SAS ODBC local server initiate from a program running as Windows Service

dougcrites — Thu, 10 Jul 2025 12:10:37 GMT

I have the 9.4 SAS ODBC driver installed and running in local mode.

For programs where I start from a Windows command, all works fine.

But if the program is running as a Windows service, the connection just hangs... The SAS ODBC local server does not get invoked.

I am using the following where the ODBC server parameters have this startup command:

initstmt %sasodbc(sassvr) -icon -nologo

Does anyone know if this is able to work with programs running as a service?

Is there some other parameter to add? I tried adding -nosplash , but does not make any difference.

SASKiwi — Thu, 10 Jul 2025 21:14:24 GMT

A Windows service typically runs under the Windows system account. Try running it with your own user account instead to see if that helps.

dougcrites — Fri, 11 Jul 2025 14:14:58 GMT

Thank you for the suggestion. I tried it but still can't get the connection to work.

SASKiwi — Fri, 11 Jul 2025 21:57:54 GMT

I suggest you raise a Tech Support track for this as it requires further investigation.