davidrobin
Feb 12th, 2001, 09:06 AM
I am told by colleague the following page is giving the
80040E4d
error beacuse I am using integrated security and Windows NT4 does not pass the users information over the network. It will be using the currently logged in user for the server IIS is running on. Is this correct and how do I get around it without compromising the users security details.
<%@ Language=VBScript %>
<HTML>
<HEAD>
<title>Results</title>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<%
dim SQL
dim objRS
SQL = "select code from staff"
SET objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=qlsdat;Data Source=isproduction"
SET objRs = objConn.Execute(SQL)
%>
<BODY>
<p>Staff</p>
<table border=3>
<% while not objRs.EOF %>
<TR>
<td><% =objRs.Fields("code").Value %></td>
</tr>
<% objRs.MoveNext
Wend %>
</table>
</BODY>
</HTML>
Any additional information will be greatly appreciated.
80040E4d
error beacuse I am using integrated security and Windows NT4 does not pass the users information over the network. It will be using the currently logged in user for the server IIS is running on. Is this correct and how do I get around it without compromising the users security details.
<%@ Language=VBScript %>
<HTML>
<HEAD>
<title>Results</title>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<%
dim SQL
dim objRS
SQL = "select code from staff"
SET objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=qlsdat;Data Source=isproduction"
SET objRs = objConn.Execute(SQL)
%>
<BODY>
<p>Staff</p>
<table border=3>
<% while not objRs.EOF %>
<TR>
<td><% =objRs.Fields("code").Value %></td>
</tr>
<% objRs.MoveNext
Wend %>
</table>
</BODY>
</HTML>
Any additional information will be greatly appreciated.