RE: [Webware-discuss] odbc permission

[Geoffrey T. <gta...@na...>]

Stefan Kuzminski wrote:
> hi,  I'm calling SQL server with mxODBC ( using a DSN I defined in the
> Windows 'Data Sources (ODBC)' control panel applet )  from my 
> psp page, it
> works ok with the webkit.cgi and the appserver, but I get an 
> error with the
> oneshot.cgi, maybe because of the permissions and user that 
> the http server
> ( apache in this case ) runs the cgi script with?   Anyone 
> worked around
> this before?

In the Services control panel, you can specify a user account for Apache to
run under, instead of having it run under the System account.  If that
account can access your SQL Server, then you should be all set.  (I'm
assuming you're using NT or 2000.)

There may be some security concerns from doing this.  But assuming we're
talking about a development machine and not a production machine, you
probably don't need to worry about that.

- Geoff