ODBC Problem!

[MyaTiX]

I have just installed a new IIS Server and implemented
security restrictions on it using the IIS Lockdown tool.

I am now getting an Internat Server Error 500 when I try
and open the site even though when I test the ODBC
connection in the ODBC administrator it works fine. Can
anyone tell me what this might be!

It the asp page loads fine as long as I don't connect to
the database.

Thanks for any help!

[Ray at]

First find out what the error is.
[url]http://www.aspfaq.com/2109[/url]

Ray at work

"MyaTiX" <bloggs@hotmail.com> wrote in message
news:0c2401c3619a$a8f51e00$a601280a@phx.gbl...

> I am now getting an Internat Server Error 500

[Ray at]

Don't use a DSN, and instead, use a connection string as such:

objYourADODBConnectionObject.Open ""Provider=sqloledb;Data
Source=YourSQLServer;Initial Catalog=YourDatabase;User
Id=SQLUsername;Password=ThePassword;"
([url]www.connectionstrings.com[/url])

Or, if you cannot use a SQL login and have to use NT authentication, see
here. [url]http://support.microsoft.com/?id=306586[/url]

Your ODBC connection that works fine when you're logged in is using your
credentials.

Ray at work


"MyaTiX" <bloggs@hotmail.com> wrote in message
news:0caa01c3619f$c74ecb30$a601280a@phx.gbl...

> I recieve the following error!
>
> ODBC_SQL_Server_Driver][SQL_Server]
> Login_failed_for_user_'(null)'._Reason:_Not_associ ated_with
> _a_trusted_SQL_Server_connection.
>
> I presume this means I need to give the IUSR account
> access writes to odbc in some way!
>
> How do I solve this error?
>
> Thanks!
>