PC Review


Reply
Thread Tools Rate Thread

ADO parameter object fails with AS400 when used in Windows XP

 
 
=?Utf-8?B?anIyMTEy?=
Guest
Posts: n/a
 
      5th Apr 2006
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADO parameter object fails with AS400 when used in Windows XP =?Utf-8?B?anIyMTEy?= Microsoft Excel Programming 0 5th Apr 2006 07:36 PM
passing any object as parameter to a function which takes Object class as parameter and fetching the members at runtime Ram Microsoft VB .NET 5 11th Oct 2005 08:24 PM
Windows update fails, freezes, fails to logon on hotmail, fails to send mail from outlook express, windows update errors, router settings, "MTU , Partial Loss of Internet Connection, and Performance" stevan Windows XP General 0 9th Aug 2004 07:08 PM
asp.net oledb command parameter error calling an as400 program Manuel Arroba Microsoft ASP .NET 0 28th Jun 2004 10:50 AM
Accessing Reference Object Parameter from COM Object Bala Microsoft C# .NET 0 22nd Jan 2004 10:29 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:35 AM.