Driver ODBC Microsoft Access] Impossibile aprire altre tabelle.

Question

sul pc (xp con un processore vecchio elento) dell'ufficio eseguo senza errori il progetto java lanciato con eclipse, invece sul pc di casa (w7 64 con processore i7) l'esecuzione dura un decimo ma non carica tutte le righe in tabella scartandone alcune con il seguente errore

il programma legge un file xml e carica i dati in access suddivinendolo in 7 tabelle.

percentualmente solo 2 sono interessate quasi per il 90% delle righe.  

Driver ODBC Microsoft Access] Impossibile aprire altre tabelle.

Non riesco a trovare dove si deve configurare qualcosa che elimini l problema

Il progetto ed anche eclipse così come il db access è su un disco esterno per cui si lancia proprio fisicamnete lo stesso eseguibile e si trattano gli stessi dati sullo stesso db access 2007

Grazie

Dopo alcune prove posso aggiungere che ;

1) le righe non inserite nelle tabelle di access 2007 non sono sempre le stesse

2) se rallento le operazioni per esempiomettendo sottotrace il driver gli errori diminuiscono in generale, scompaiono completamente per le tabelle con meno inserimenti

3) i vodici errore sono -1311 s1001

4)gli errori sono solo tra le prime 10.000 righe

5) se isolo il gruppo contenente alcuni scarti lo carica tranquillamente

6) se invece prendo un gruppo + consistente come le prime 2000 righe ancora segnala gli errori

ne deduco che ci deve essere qualche cosa da configurare tipo buffer pool o simile o nel driver o su access

Qualcuno ha avuo esperienze simili?

Grazie

Answer 1

Sorry, we're not able to support in Italian.  You're welcome to ask the question in English.

thanks.

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 2

I developed a little project with java on office  pc (XP with a slow and old processor ) and everything works flawlessly.

I launched the project with eclipse, the project reads an xml file and loads the data into different tables in Access 2007, running time is 68 minutes

Then I took the external drive at home and I run the same project on my home PC (64 w7 i7 processor) running time is 12 minutes but discards some lines with the following error

Driver ODBC Microsoft Access] Impossibile aprire altre tabelle (Could not open any more tables)

The program reads an xml file and loads the data in seven Table.

the two PCs have the same version of java eclipse and access

2 tables load 90% of the lines (about 280 000 rows each).

1) the discarded lines are not always the same

2) if I slow down operations such as putting a trace driver, errors in general decrease, disappearing completely for tables with fewer entries

3) error codes are -1311 s1001

4) the errors are only one of the first 10,000 rows

5) If I isolate the group containing the waste, these lines are loaded correctly

6) if instead I take a group like the first 2000 lines still reports errors

I conclude that there must be something to set buffer pool or the like or the driver or access

Someone avuo similar experiences?

Thanks

Answer 3

Might ask them in a java programming forum. From your description I'm guessing you're running up against some limit for access objects. Running a faster processor the connection object may not have time to close them.

http://blogs.office.com/b/microsoft-access/archive/2006/06/05/access-2007-limits.aspx

 

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

Answer 4

Thankyoufor the suggestion

I use tables are 7
1) months (12 items)
2) days (365 items)
3) hours (12 items per day)
4) the schedule of events (1 event every six seconds for a period of 3 days(date time sensor and watts))
the other 3 are the counters then contain the numbers of total
Everything, therefore well below the limits of the database

I did another test on another pc (w7 i5 processor) the result is that discards fewer elements, and totally different
I found how to configure the buffers the driver treads.
changing values​​, changing also the errors but do not disappear

I'll try to post on the forum java

in the meantime I have downloaded mysql

thanks

Answer 5

I'd be somewhat concerned about the speed and shear number of iterations and the delicacy of the access jet db engine. If you're going to stay with access backend you might ask them here about what you're doing.

 http://answers.microsoft.com/en-us/office/forum/office_2007-access

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows]

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.