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.