Informix support?

Posts   
 
    
billb
User
Posts: 50
Joined: 09-Jul-2004
# Posted on: 10-Sep-2004 16:54:43   

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.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Sep-2004 17:08:55   

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.

Frans Bouma | Lead developer LLBLGen Pro
billb
User
Posts: 50
Joined: 09-Jul-2004
# Posted on: 10-Sep-2004 19:33:01   

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.

jtgooding
User
Posts: 126
Joined: 26-Apr-2004
# Posted on: 10-Sep-2004 21:34:11   

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

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 10-Sep-2004 22:03:50   

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)...

Frans Bouma | Lead developer LLBLGen Pro
krusso
User
Posts: 5
Joined: 30-Apr-2004
# Posted on: 04-Oct-2004 20:01:55   

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. wink

Kenneth Russo USCA5

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 04-Oct-2004 21:17:22   

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.

Frans Bouma | Lead developer LLBLGen Pro
bmcintyre
User
Posts: 10
Joined: 29-Jul-2004
# Posted on: 27-Jun-2005 20:28:29   

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

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 27-Jun-2005 20:52:58   

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.

Frans Bouma | Lead developer LLBLGen Pro
billb
User
Posts: 50
Joined: 09-Jul-2004
# Posted on: 06-Oct-2005 23:42:45   

I understand, but this makes me a sad panda. cry

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.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 07-Oct-2005 10:30:29   

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... simple_smile

Frans Bouma | Lead developer LLBLGen Pro