Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Sql and ASP

Author  Topic  amir Starting Member 12 Posts Posted - 2001-02-19 : 11:20:13 I get this error message : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AMIR\IUSR_AMIR'. /Project7/1.asp, line 11 when I try to run a simple script : <% set con = server.CreateObject("adodb.connection") con.Open "dsn=forum" set rs = server.CreateObject("adodb.recordset") rs.Open "customers",con,3,3 if con.State = 1 then Response.Write "hellow" else Response.Write "hi" end if %> it is quite obvious that the script itself does not generate the error but the connection. can someone tell me what to do ? thank's a lot