IBM.Data.DB2.iSeries DLL

[maxcoats]

Any thoughts on this?

[sdanyliv]

@RoyC-Retail-Assist, can you help in this? Main problem that we have no testing environment for iSeries.

[RoyC-Retail-Assist]

@maxcoats - can you give me some details of what you are doing when you get the issue? what is the structure of the table you are trying to access etc.

[MaceWindu]

@RoyC-Retail-Assist could you confirm that recent linq2db.linqpad release works for you with iseries?

[maxcoats]

I've actually had the same issue using the linqtodb4iseries provider but was able to fork and patch it to work for me.

[MaceWindu]

I think I know the reason. For some reason we ship iseries v13 assembly with linqpad integration, but it expects v12. As quickfix try to remove or replace it with v12 assembly under c:\ProgramData\LINQPad\Drivers\DataContext\ root well, IBM should learn how to version their assemblies

[maxcoats]

[MaceWindu]

Even if it is not the reason - we should remove IBM.Data.DB2.iSeries.dll from linqpad integration and use version from GAC

[RoyC-Retail-Assist]

I'm getting a different problem when it is populating the tables.

I'll get the source and try to triage what is going on but it won't be until Monday.

[MaceWindu]

That's strange. It's one of fixes in 2.5.1 integration. Maybe you use previous version? If it is recent version - fill issue here with bad generated code sample

[maxcoats]

c:\ProgramData\LINQPad path does not contain a drivers directory for me.

[MaceWindu]

Well, maybe linqpad stores them somewhere else on your machine.
for me it's
c:\ProgramData\LINQPad\Drivers\DataContext\4.0\linq2db.LINQPad (f19f8aed7feff67e)\IBM.Data.DB2.iSeries.dll
c:\ProgramData\LINQPad\Drivers\DataContext\5.0\linq2db.LINQPad (f19f8aed7feff67e)\IBM.Data.DB2.iSeries.dll

[maxcoats]

After driver change to v12 same error :(

[MaceWindu]

I will install iseries provider tomorrow and try to debug it tomorrow without database.
Could you provide some details on versions you use to confirm that we all work with same versions:

• linqpad
• linq2db.linqpad
• iSeries Access for Windows driver

[maxcoats]

linqpad v5.31.00
linq2db.linqpad v2.5.1

[RoyC-Retail-Assist]

@maxcoats The iSeries provider has been tested against iAccess V 7 Release 0 SI55797. I'm guessing that XML column type was introduced after V6.

@MaceWindu I'll do some debugging later this evening on the LinqPad stuff as I would expect it to work ok on my machine.

[maxcoats]

Ahh, sorry I missed that. Will have to try and build with my patched version of linqtodb4iseries.

Thanks everyone!

[maxcoats]

Confirmed this is straight from IBM's website
https://www-01.ibm.com/support/docview.wss?uid=isg3T1027163

The 7.1 .NET Provider includes these enhancements:

Support for the IBM i XML data type
Support for longer SQL schema names
New property to configure the ConcurrentAccessResolution
Support for multi-row UPDATE, DELETE, and MERGE using the iDB2Command.AddBatch method
Class interfaces and technical information is now integrated with Visual Studio

[MaceWindu]

Glad to hear that it is solved.
@RoyC-Retail-Assist It would be great if you could update your provider readme to mark v7.1 as min version requirement, or even do it in code to throw exception with explanatory text.