J
jr2112
I have been using VBA and ADO inside of Excel spreadsheets to upload data
into AS400 tables
for years now within Windows 2000 professional. I am now trying to use
Windows XP and these
same spreadsheets are crashing.
I have tried the following to troubleshoot the problem:
Changing the MDAC version referenced by the program from 2.5 to 2.6 to 2.7
to 2.8
Trying the program under office 2000 and office 2003
Changing the definition of numeric parameter objects from adDecimal to
adNumeeric,
changing the order of parameters objects,
changing the number of parameter objects even just 1.
Under windows XP none of these changes worked but they do work under windows
2000 pro.
I have also dealt with IBM support and they have found through trace files
when executing
the programs that the value being carried by the first parameter object
appears corrupt
whereas the values in the other objects are intact.
Has anyone experienced this problem?
If so have you foound a solution?
I would appreciate any help.
Cheers,
jr2112
into AS400 tables
for years now within Windows 2000 professional. I am now trying to use
Windows XP and these
same spreadsheets are crashing.
I have tried the following to troubleshoot the problem:
Changing the MDAC version referenced by the program from 2.5 to 2.6 to 2.7
to 2.8
Trying the program under office 2000 and office 2003
Changing the definition of numeric parameter objects from adDecimal to
adNumeeric,
changing the order of parameters objects,
changing the number of parameter objects even just 1.
Under windows XP none of these changes worked but they do work under windows
2000 pro.
I have also dealt with IBM support and they have found through trace files
when executing
the programs that the value being carried by the first parameter object
appears corrupt
whereas the values in the other objects are intact.
Has anyone experienced this problem?
If so have you foound a solution?
I would appreciate any help.
Cheers,
jr2112