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 PROTECTED]
