sex offender?
----- Original Message -----
From: "Stephan" <[EMAIL PROTECTED]>
To: "ActiveServerPages" <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 10:44 PM
Subject: Connection Problem
> Why is this application trying connect to IUSR_STEPHAN account for
> authenication when I am passing the connection string? When I run query
> analyzer I am able to connect to the database. The Password has been
> removed for obvious purposes.
>
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <html>
> <head>
> <title>Untitled Document</title>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> </head>
>
> <body>
> <%
> strConn = "Driver={SQL Server}; Server=stephan\local;
> Database=Offender; UID =Offender_User; PWD=Password goes hear not part of
> the error;"
>
> Set conPubs = Server.CreateObject("ADODB.Connection")
> conPubs.ConnectionString = strConn
> conPubs.Mode = adModeReadWrite
> conPubs.CursorLocation = adUseClient
> conPubs.IsolationLevel = adXactBrowse
> conPubs.Open
> response.write "connected"
>
> conPubs.close
>
> %>
> </body>
> </html>
>
> This the Error I get:
>
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'STEPHAN\IUSR_STEPHAN'.
> /SexOffender/connection2.asp, line 17
>
>
>
> Thanks,
> Stephan
>
> ---
> You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
>
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
