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

[dougcrites]

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]

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]

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

[SASKiwi]

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