ERROR IN DLL ON ADVANCED SERVER NOT WIN2K PROFESSIONAL

[iteach2]

I have two pages

page 1

<%
Dim rs, data_source, frmValue, strcon, strvalue

data_source = &quot;essex&quot;

strvalue=Request.Form(&quot;datainfo&quot

Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot
rs.Open &quot;tblContent&quot;, data_source, 1, 2
rs.Filter = &quot;id = '1'&quot;
rs(&quot;content&quot=strvalue
rs.Update
rs.Close
Set rs = Nothing
%>
--------------------------------------------

page 2

<%
set cn = server.CreateObject(&quot;adodb.connection&quot

cn.Open &quot;dsn=essex&quot;

set rs = server.CreateObject(&quot;adodb.recordset&quot

rs.Open &quot;SELECT * FROM tblContent&quot;,cn
%>



Both pages worked fine on Windows 2000 Professional but on Advanved Server 2000, I got &quot;error in dll&quot; message that points to the (rs.Open &quot;tblContent&quot;, data_source, 1, 2) on page 1 and (cn.Open &quot;dsn=essex&quot on page 2. Any ideas why this is happening??

 

[GabeC]

It sounds like you may have a problem with MDAC and ADO.

Please post the entire error you are receiving. Check the server's event log to see if this gives you any clues to what is happening.

Thanks,

Gabe

 

[iteach2]

OK, but I have to wait till I go back to work-next week-to generate the error...Advanced Server is at work . .
^
(---)