2. ASPRunnerPro General questions
  3. [SOLVED]  Jet Vs.ace In Db Connection
This topic is locked
[SOLVED]

 Jet Vs.ace In Db Connection

 		5/3/2013 1:19:10 PM
ASPRunnerPro General questions
M
 mitzi author

hi, as I don't have a huge database to test the performance I was realy interested if
one of these two connections would be preferred and why.
<%

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db\database.MDB") & ";Jet OLEDB:Database Password=;User ID="
%>
<%

strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("db\database.MDB") & ";Jet OLEDB:Database Password=;User ID="
%>
as you noticed i have and mdb file not .accdb
i would really appreacite if someone can enlighten me on this matter
the top line is generally used by ASPrunner in the dbconnection file. Scecond one i have found in some other apprlication..

i need to know which one of these strings are more popular on servers, and which one is faster to access data.
Sergey Kornilov admin 5/6/2013

I'm afraid this type of question cannot be answered in theoretical way. When you have a large database and are able to test the performance you can simply do that switching connection strings.