Re: Problem with reading Access DB using OleDBDataReader -
01-27-2009
, 10:19 AM
I think if you are performing web operations on a production server you
should use a server based database like sql server instead of a file
based system like Access. I don't think Access can handle many
concurrent web connections since it is a file based database.
Also, as long as you are writing your code in C#, you may want to try
using an oleDB DataAdapter (or better a sqlDataAdapter with sql server)
instead of a command object. And if you do migrate to a sql server
(2005 and higher) you can use linq Sql (Visual Studion 2008).
Rich
*** Sent via Developersdex http://www.developersdex.com *** |