VB6 (-2146500594) Automation error
Posted on 2009-04-16
I have an application build in VB6 that works fine on every computer but one. The process where the error occurred is an Import that use a .xls file to pass information to an Oracle DB, using Access to create a temporal "database" to process the information.
On my PC the process imports successfully 50,000 items in 2 hours and a half. I have a computer with WindowsXP, 4GB of RAM and a local connection of 1,000 Mega Bits with Access 97 installed. I use Oracle11 and the computer where the Oracle Server is installed is only used for this.
The person that is having the problem is importing the same .xls file with 50,000 items but the process take FOREVER and fails after 9 hours with the (-2146500594) Automation error.
I am discarding that is a problem with the data (.xls file) since I'm able to do it without any problem in my computer. The person that is having this problem has a similar computer than mine, with the exception that his Oracle Server is not exclusive and he has so much information than me on his server, and he has Access 2003 installed on his computer.
I think that is a problem with a lost connection or something like that due to the import with him takes so many hours.
Any ideas of how can I solve this?