Greetings,
I know the user-contributed Informix drivers aren't officially supported, but if anyone reading this forum has had success using them, I'd appreciate any help you could give.
I'm trying to get the "Rene" drivers working using LLBLGen Pro 1.0.2005.1 Final July 6th, 2006 (I believe the forums indicate that the drivers don't support version 2+) with Visual Studio 2005 / .NET 2.0.
For some reason, I had to remark lines 120 and 138 in InformixDBDriver.cs to get the driver to compile.
// base.DBTypesAsProviderType[(int)InformixDbTypes.Collection] = IfxType.Collection.ToString();
// base.DBTypesAsProviderType[(int)InformixDbTypes.RowRef] = IfxType.RowRef.ToString();
Only other change I made was removing and re-adding the reference to SD.LLBLGen.Pro.DBCoreDrive (which came up broken for me when I opened the project) After remarking these lines and adding the reference, I was able to get both the driver and the DQE to compile. I copied the drivers into C:\program files\Solutions Design\LLBLGen Pro\Drivers\Informix and the DQE to C:\program files\Solutions Design\LLBLGen Pro\RuntimeLibraries\DotNet20
I copied the Templates in with the driver and couldn't find a driver.config file in the SVN so I created this one:
<?xml version="1.0" encoding="utf-8" ?>
<!-- Informix Database driver settings. -->
<databaseDriver>
<name>Informix Driver</name>
<assemblyFilename>SD.LLBLGen.Pro.DBDrivers.InformixDBDriver.dll</assemblyFilename>
<namespace>SD.LLBLGen.Pro.DBDrivers.Informix</namespace>
<className>InformixDBDriver</className>
<driverID>9FC4A233-5D7C-47a8-A228-2BE44C51792F</driverID>
<dynamicQueryEngineNamespace>SD.LLBLGen.Pro.DQE.Informix</dynamicQueryEngineNamespace>
<templatesRootFolder>Templates</templatesRootFolder>
</databaseDriver>
I used the GUID for the assembly for the driverID (is that correct?) and copied this and the other information from the AssemblyInfo.cs file.
When I try to select this as the driver for a new project in LLBLGenPro, I get this error:
The Informix driver can not be loaded due to an exception....
The format of 'SD.LLBLGen.Pro.DBDrivers.InformixDBDriver.dll' is invalid along with a stack trace. I haven't found a good way to cut'n'paste the trace from the LLBLGen message box that alerts me to it but here's the highlights:
The exception occured in System.Reflection.Assembly.nLoad called (indirectly) from SD.LLBLGen.Pro.ApplicationCore.DBDriverHelper.CreateDBDriverInstance
There's some calls in between those things. I don't think the details of the trace are important here, but let me know if they are and I can type the full stack trace.
Any help is much appreciated.
--Rudy