Multiple database access

  • Thread starter Thread starter James Jenkins
  • Start date Start date
J

James Jenkins

Hi,
I am new, I have a c# app that uses a mdb file for holding statistics,
these stats are dumped into the mdb from one process every minute, and
obtained from another process periodically ( at the users call) which then
returns the stats. Do I have to worry that there will be an access problem
at some stage? - should I be adding something to the connection string? -
Any help would be good, also i have a second issue, Can I fill a dataAdapter
with datarows as opposed to datatables - I need to gather stats from this
mdb, but at the moment I have to enumerate the ExecuteScalar() - and then
call the command again.. Any advice would be great - TIA


James
 
James Jenkins said:
Hi,
I am new, I have a c# app that uses a mdb file for holding statistics,
these stats are dumped into the mdb from one process every minute, and
obtained from another process periodically ( at the users call) which then
returns the stats. Do I have to worry that there will be an access problem
at some stage?
Click to expand...
--It depends on volume but if you're running it every minute, I'm guessing
that you'll probably be ok. That depends on the load (if each update takes
10 minutes then you probably will have a problem) but if it's just a typical
query run every minute, access can probably handle it (although I have a
strong bias against access b/c if the volume gets too big, switching dbs is
a pain in the a33 so doing it in SQl server or Oracle from the get go is
preferable IMHO)
- should I be adding something to the connection string? -
--I don't follow you here, like what?
Any help would be good, also i have a second issue, Can I fill a
dataAdapter with datarows as opposed to datatables
Click to expand...
--dataAdapters do the filling and all a DataTable is is a collection of
DataRows, a dataSet a collection of DataTables. I'm not sure I follow you on
the distinction here on filling rows vs tables, what's the desired
difference?
- I need to gather stats from this
mdb, but at the moment I have to enumerate the ExecuteScalar() - and then
call the command again..
Click to expand...
--You can use a DataTable, change the values of the rows and then call
update. in the 2.0 framework you can set the updateBatchSize which allows
you to batch the queries (provided your db supports it) and this will have a
potential performance benefit. Is this what you're asking?
Any advice would be great - TIA
--If moving data is the primary objective here, remember that ADO.NET's
disconnected architecture isn't really designed to be a data transfer
mechanism although it certainly works as one. but the benefits of having
things disconnected are minimized if you're just moving data around,
particularly between two databases on the same server instance. DTS might
be a better mechanism for what you're describing if I understand you
correctly.
 
¤ Hi,
¤ I am new, I have a c# app that uses a mdb file for holding statistics,
¤ these stats are dumped into the mdb from one process every minute, and
¤ obtained from another process periodically ( at the users call) which then
¤ returns the stats. Do I have to worry that there will be an access problem
¤ at some stage? - should I be adding something to the connection string? -
¤ Any help would be good, also i have a second issue, Can I fill a dataAdapter
¤ with datarows as opposed to datatables - I need to gather stats from this
¤ mdb, but at the moment I have to enumerate the ExecuteScalar() - and then
¤ call the command again.. Any advice would be great - TIA

The following should help:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/default.aspx?scid=kb;en-us;303528


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top