can anyone help?

okay i have installed sql 2000 server dev and iis6.0 and i wrote a aspscript to connect to my database through the odbc dsn that i made andwhen i run the script it says this:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
/connect.asp, line 14
and here is the code that generated this:
<%@. Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<!--StartFragment -->
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=mssql"
If conn.errors.count = 0 Then
Response.write "Connected OK"
End If
%>
<P> </P>
</BODY>
</HTML>
could anyone help me or know what might be wrong?

You are not providing a user name. Search how to include a username for that connection. You prob just need to add the default username like 'admin' .|||well i have mysql to and when i type its dsn in it works??.....do i need to include it in the code you mean?
|||Is you username and password specified in the DSN?
Have you tried:
Conn.Open "DSN=NameofDSN;Uid=Username;Pwd=Password"

Can 32 bit webserver work with a 64 bit db server?

Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
server running W2K3 64 bit?
tia
--
MGYes. The SQL Client libraries do not care about the architecture of the
server they connect to. From the client point of view, all SQL Servers are
the same.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hurme" <michael.geles@.thomson.com> wrote in message
news:82AB06A7-DD7A-46D9-8F0C-F4934C8688C1@.microsoft.com...
> Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
> server running W2K3 64 bit?
> tia
> --
> MG

Can 32 bit webserver work with a 64 bit db server?

Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
server running W2K3 64 bit?
tia
MG
Yes. The SQL Client libraries do not care about the architecture of the
server they connect to. From the client point of view, all SQL Servers are
the same.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hurme" <michael.geles@.thomson.com> wrote in message
news:82AB06A7-DD7A-46D9-8F0C-F4934C8688C1@.microsoft.com...
> Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
> server running W2K3 64 bit?
> tia
> --
> MG