Question DataAdapter

[Kristof Bonnast]

All,

I'm using the DataAdapter from IBM iSeries to connect to our AS/400.
When I fill the dataadapter, all my string values are converted into
Binary values. The response from IBM is to upgrade our AS/400 OS
(can't do that, because I'm not the only one using this) or read via a
DataReader and convert all strings via a the toString method (which
loses the power of the dataadapter).

Does anyone have an idea on how to fix this ?
I'm really getting desperate on this issue !


Thx in advance,

Kristof Bonnast

 

[Sahil Malik]

Kristof,

You can write your own data adapter, all you need to do is Implement
IDataAdapter, and inside that you can use a datareader. I know that's a lot
of work, but shudda used Sql Server. (Never too late to change).

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Kristof Bonnast]

Hello Sahil,

Won't this slow down the response time? Or is the default DataAdapter
working on the same concept.

Changing to SQLServer is not really an option. I'm accessing the AS/400
because our ERP system (JDEdwards) uses this

I'll try your suggestion. Thanx very much !


Kristof

 

[Sahil Malik]

Way back a friend told me that DataAdapter uses DataReader inside, I have
never been able to verify that statement.

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[WJ]

Hello Sahil,

Won't this slow down the response time? Or is the default DataAdapter
working on the same concept.

Yes it does. Because it is not ADO.Net native. IBM may help you to come up
with a good provider like that of Oracle.

John