Re: sql connection

Dale E. Reed Jr. ( (no email) )
Tue, 20 May 1997 22:38:12 -0700 ()

On Tue, 20 May 1997, David Kerr wrote:

> Any sql guru
>
> We are trying to configure odbc connectivity from our web server back to
> the sql database.
>
> The web box is a stand alone machine and is part of the nt domain.
>
> We are able to connect with desktop executable's but no cgi/isapi/idc
> functions seems to be able to connect to the sql server. Basically anytime
> we try to access the sql database from a browser it doesn't work.
>
> If i am running sql trace, i never see it even attempt to connect.

Make sure your ODBC DSN is a SYSTEM DSN. That could be a big factor.
Also make sure you verify security information. We use Cold Fusion all
the tim eon the Emerald database and its very easy to setup with the
CF Admin.

Dale