Cannot create model using IBM DB2 for i .NET Provider

I've created a Data Connection to an "IBM i" server (previously known as AS400) in Visual Studio. I can open the connection, browse tables, and view table properties. However, when I drag a table over to the LightSpeed designer, it throws the following exception:

Exception while processing Server Explorer drag: System.IO.FileNotFoundException: Could not load file or assembly 'IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified.
File name: 'IBM.Data.DB2, Version=9.0.0.2, Culture=neutral, PublicKeyToken=7c307b91aa13d208'
   at Mindscape.LightSpeed.Generator.Extraction.ProviderFactory.CreateDB2Provider()
   at Mindscape.LightSpeed.Generator.Extraction.ProviderFactory.CreateProvider(ProviderType provider)
   at Mindscape.LightSpeed.Generator.Integration.LightSpeedDataSourceBase`1.GetProvider(IGenerationLog log, IDbDataTypeResolver typeResolver)
   at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, IDesignTimeNamingStrategy namingStrategy, ILightSpeedDataSource connection, IEnumerable`1 tableNames, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.DiagramDragDropHandler.<>c__DisplayClass6.<OnDragDrop>b__4(DragObject dragObject, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

I understand that it cannot find the IBM.Data.DB2.dll file, but what I don't understand is why it is looking for it in the first place. The actual DLL that it should be using is IBM.Data.DB2.iSeries.dll.

I don't know where to look next. Is this a Lightspeed configuration issue, or a Visual Studio configuration issue?

We have a dependancy on IBM.Data.DB2 for our DB2 provider. We dont have any binding to IBM.Data.DB2.iSeries. If that assembly is required to access the database server then LightSpeed is not going to be compatible.

Do you have IBM.Data.DB2 installed in the GAC? If not then copy it in place under your Designer folder e.g. C:\Program Files (x86)\Mindscape\LightSpeed\Tools\Designer

Jeremy

Hi Jeremy,

IBM.Data.DB2.dll is not included in the System i version of DB2. I guess LightSpeed isn't an option for us.

Thanks.