Microsoft.Jet.OLEDB.4.0 vs. Microsoft Access Driver

[mjay2004]

I've been getting a problem with asp error 0113 I know you can change the Server.ScriptTimeout but i was wondering if theres a difference when using these two drivers and if this could be also making my code get errors??? heres the codes for two simple pages which is best to use? <%@LANGUAGE=VBScript%> <% Dim adoCon Dim rs Dim strSQL Set adoCon = Server.CreateObject("ADODB.Connection") adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("jet.mdb") Set rs = Server.CreateObject("ADODB.Recordset") strSQL = "SELECT jet.* FROM jet" rs.Open strSQL, adoCon %> <% = rs("Text") %> <% rs.Close Set rs = Nothing adoCon.Close Set adoCon = Nothing %> or <%@LANGUAGE=VBScript%> <% dim Conn, sConnection, rs Set Conn = Server.CreateObject("ADODB.Connection") sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & Server.MapPath("jet.mdb") & ";" & _ "Persist Security Info=True" Conn.Open(sConnection) set rs = conn.Execute("SELECT * FROM jet") %> <% = rs("Text")%> <% rs.close Set rs = Nothing Conn.close Set Conn = Nothing %> Thanks

[Nino_1]

mjay2004 wrote: I've been getting a problem with asp error 0113 I know you can change the Server.ScriptTimeout but i was wondering if theres a difference when using these two drivers and if this could be also making my code get errors??? heres the codes for two simple pages which is best to use? I've used both at different times and have had some really strange errors while using the {Microsoft Access Driver} in the connection string, as far as what's different I don't know. I've had the best results using the JET connection engine string over the *.mdb. Just my $00.2 Nino