Is there any command that will cause perl to list out the properties of the
dsn it is attempting to use? Apache is running as www, and if I am logged
in as www, I can connect to the database via the commandline, so I'm
wondering if it isn't using the proper dsn. Any thoughts?
on 5/24/01 9:50 AM, Sterin, Ilya at [EMAIL PROTECTED] wrote:
> The permissions for a web user connecting is as www or nobody, so you want
> to make sure that you grant the right permissions for that DSN.
>
> Ilya Sterin
>
>
> -----Original Message-----
> From: Justin Kelley
> To: [EMAIL PROTECTED]
> Sent: 05/24/2001 10:04 AM
> Subject: Web Connection Error (Desperate)
>
> For about a year I've had a working connection from Mandrake Linux to
> MS-SQL
> 7 on NT using the DBI and Openlink's bridge. A few days ago my company
> changed offices and so the ip's on the two machines have changed. Now,
> I
> can connect via the commandline 'perl index.cgi' just fine, it will
> bring
> back results easily, however from the web, it brings back the db error
>
> [208.131.80.17] Couldn't connect to database: [OpenLink][ODBC]RPC:
> Program
> unavailable (SQL-08004) [OpenLink][ODBC]Connection rejected by data
> source
> (SQL-08004)(DBD: db_login/SQLConnect err=-1) at
> /home/httpd/cgi-bin/W1CCode.cgi line 726.
>
> Does anyone have any ideas as to why this would work from the
> commandline
> but not the web? I'm losing visitors quickly and my site has been down
> for
> two days now, so any help would be /greatly/ appreciated.
>
>
> ---------------------------------
> Justin Kelley
> Webmaster
> Pixelmation Internet Technologies
> [EMAIL PROTECTED]
>
