I think we're going to have to get a DB2 server setup around here to figure this one out.  Basically, the BOMapper uses the GetSchema() method of the OleDbConnection object to enumerate the "databases" and "tables" but appearantly, the collections are different when getting the schema.  It's going to take some testing, but I'll keep you posted.

Thanks Ben, I am going to move ahead with my current need without Strataframe as I have a tight timetable but being able to use SF with our AS400 clients is srill very important to us. I appreciate you looking into it. If you need anything from me to help you, please let me know.

Keith Chisarik

No problem.  We've got an inside contact at IBM that might be able to hook us up... if not, I believe they have a "personal" version of DB2 that you can install for free.

Finding it tough to give up considering I am finding that the speed of the DataDirect provider is easily 20x the OLE one.



Here are some more details of the errors I am getting trying to use the DataDirect provider in the BO Mapper.



I called their support and they confirmed that the DB2 provider is correctly registered in the GAC and the machine.config, which I tend to believe since everything works using the native .NET tools. Perhaps I am doing something wrong that the shots will illustrate.



DataDirect says they are more than willing to do anything to help, including talk to you guys.














Keith Chisarik

not sure why the first image doesnt show, here it is again.





Keith Chisarik

Just post the images as attachments.  I don't know why they aren't showing up.

they did 15 minute ago



Anyhow I used DbProviderFactories.GetFactoryClasses() to make sure I had the right registered name. It is registered as "DataDirect DB2 Data Provider", which I tried with no luck, same error.



Here are the images again. Thanks.




Keith Chisarik

Well, I don't think that your provider is correct.  I will have to investigate what the provider would be for this type of connection source, but an example is this:

Visual FoxPro = VFPOLEDB.1 OR VFPOLEDB

Microsoft Jet 4.0 OLE DB Provider = Microsoft.Jet.OLEDB.4.0

Notice that the provider will not accept spaces.  It is looking for the COM class name in most cases.

DataDIrect had me try DDTek.DB2..........

Keith Chisarik

Well, that is much closer to a provider name since it is in COM class name or program ID format.