WinNT 4 Server and Database Connections

[Ovatvvon]

At work, we have a Windows NT 4 Server with Service Pack 6a installed. We're running our web site (internal) from it.

The .asp pages run perfect on there until I incorporate ADO to connect to our Access 97 database. When I include that, I'll be lucky to get the page to come up one time. If I go a second time, or any other computer tries to hit it after that initial time after boot-up, the page sits in transition....it never hit's the destination (or at least never appears to) and you wait indefinately.

I am curious if anyone else has ever come across this problem, and if so, how did you work around it...what would you recommend to try to fix this problem. We want to run most of our work from the site, and this is holding us up. The script works on another Windows 2000 server, so it's not the code.

Can anyone help? -Ovatvvon :-Q

 

[ToddWW]

See if this can shed any light on the subject.

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP

ToddWW

 

[Ovatvvon]

well, in all those cases they all got error messages. My problem is that I don't even get that. So I have no idea where to start...it just keeps sitting there as if it were still looking for the page...but it never times out.

The only way I can fix it is to take out the database connection string....and then reboot the server. (actually, it's not "connecting" that's the problem....it's just whenever I'm doing something with the connection...i.e. select, insert into, update, delete, etc.

-Ovatvvon :-Q

 

[ToddWW]

Well, let's take a look at one of your connections / database updates or select SQL's.

ToddWW

 

[Ovatvvon]

<%
dim conn, connstring, rs, sql, tempID
tempID = &quot;joe&quot;
Set conn = Server.CreateObject (&quot;ADODB.Connection&quot
connstring = &quot;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\inetpub\

http://wwwroot\myDatabase.mdb;&quot;

Set rs = Server.CreateObject (&quot;ADODB.Recordset&quot
sql = &quot;INSERT INTO logbook (id, date) VALUES ('&quot; & tempID & &quot;', '&quot; & now() & &quot;');&quot;
conn.Open connstring
conn.Execute(sql)
conn.Close
set conn = nothing
%>
<br>
Welcome <%= tempID%>
<br>




this is the basic database connection code. the rest of the code on the page is basic html.
-Ovatvvon :-Q