I'm going to be developing a solution for a shop that is strictly Informix (and I have no power to change that). What is the liklihood that LLBLGen will support Informix as it is now? If that probability is low, what's the liklihood of it being supported in the near future?

Thanks.

billb wrote:

I'm going to be developing a solution for a shop that is strictly Informix (and I have no power to change that). What is the liklihood that LLBLGen will support Informix as it is now? If that probability is low, what's the liklihood of it being supported in the near future?

Thanks.

It does not support informix as it is now. If 'near' future is within 2 months the chance is there, as far as I know IBM did release an Informix .NET provider, however it depends also on the fact if it is fairly easy to write a driver for Informix. Writing a driver, DQE and templates costs about 3 to 4 days.

I think 2 months will qualify as 'near future'. I'm just feeling out the possibility so that I know if I can use LLBLGen when I spec out this project.

Thanks for the quick response.

Otis wrote:

billb wrote:

I'm going to be developing a solution for a shop that is strictly Informix (and I have no power to change that). What is the liklihood that LLBLGen will support Informix as it is now? If that probability is low, what's the liklihood of it being supported in the near future?

Thanks.

It does not support informix as it is now. If 'near' future is within 2 months the chance is there, as far as I know IBM did release an Informix .NET provider, however it depends also on the fact if it is fairly easy to write a driver for Informix. Writing a driver, DQE and templates costs about 3 to 4 days.

Informix Cleint SDK 2.81 RC3 contains the ADO.NET provider, in general it performs faster than the ODBC/OLE DB providers, but I have had issues with it on version 7 of Informix and the parameters for stored procedures and a few other minor issues.

My next 2 months of work is to migrate Informix data over to SQL Server to incorporate a new line of business we became responsible for.

John

jtgooding wrote:

Informix Cleint SDK 2.81 RC3 contains the ADO.NET provider, in general it performs faster than the ODBC/OLE DB providers, but I have had issues with it on version 7 of Informix and the parameters for stored procedures and a few other minor issues.

In the ado.net newsgroup I also saw some people having problems with it. OleDB has a disadvantage that it doesn't support all the ADO.NET features (like SavePoints in transactions)...

Informix support would be great. I have a project coming up that will target a largish (~250 tables) Informix db and there just isn't much on the market that works with Informix. I can talk to it now through ODBC (playing with their native provider), but would like to move away from manual CRUD code.

Already own LLBLGenPro if that helps.

Kenneth Russo USCA5

I'll add informix to the list of drivers which will be getting a driver in the comming 2/3 weeks. First up is DB2, then sybase and mysql. If everything goes as smooth as the access driver, I expect to have time left for informix and postgresql.

I did not see Informix in the list of supported databases drivers, we're you able to get it to work ?

The list of drivers was larger in the past though it turned out not a lot of people were waiting for new drivers, but for new features, so we shifted from more drivers to more features. That's still the policy and I think it was a wise move.

Informix is not currently considered for v1.x and also for launch of v2.0 it's not on the list of supported drivers. Perhaps later.

I understand, but this makes me a sad panda.

Otis wrote:

The list of drivers was larger in the past though it turned out not a lot of people were waiting for new drivers, but for new features, so we shifted from more drivers to more features. That's still the policy and I think it was a wise move.

Informix is not currently considered for v1.x and also for launch of v2.0 it's not on the list of supported drivers. Perhaps later.

It's always sad to see a sad panda, but I have no real promisses to offer you at this point. Keep hoping though, perhaps...