I haven't incorporated a specific informix ADO.NET data provider as I don't have one.
If you have one then you can copy the MSSQLConnection and MSSQLDatabase classes to InformixConnection and InformixDatabase, make the relevant changes for using the Informix ADO.NET provider and you will have direct access.
Alternatively, you can point me in the right direction for getting the ADO.NET data provider and I'll write the support for you (it'll take less than an hour to do).
- Richard
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I installed on a different machine and it worked OK.
I've updated CVS to include preliminary support for informix now. There are a few things to note.
1. The current HEAD branch in CVS is still being worked on and some things may be broken.
2. The database mapping has changed. Instead of using class="CxxxDatabase" you must now use provider="provider.dll" (ie provider="AF_Informix.dll")
3. I have no idea about some of the informix syntax and I've based the provider on the MSSQL one. I'll need some information about how to get identity values, parameter usage in queries etc.
4. Extra XML mapping options for the database. You can set the service and host settings for the connection string via the <param /> tags.
Ideally I would love it if you could have a go at using the new provider and telling me what needs fixing. Let me know if I need to explain anything further.
- Richard.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Real world things have gotten in the way over the last week and I had some trouble with the download from IBM.
I'm actually going to split out the providers from the main persistence framework so that I don't need to worry about redistribution of the variosu providers so the change will take a little more time to get completed due to the plumbing changes I'm doing.
Sorry for the delay.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is Informix 9.4 supported with AtomsFramework?
Only via ODBC at this stage.
I haven't incorporated a specific informix ADO.NET data provider as I don't have one.
If you have one then you can copy the MSSQLConnection and MSSQLDatabase classes to InformixConnection and InformixDatabase, make the relevant changes for using the Informix ADO.NET provider and you will have direct access.
Alternatively, you can point me in the right direction for getting the ADO.NET data provider and I'll write the support for you (it'll take less than an hour to do).
- Richard
You can find a .NET data provider for Informix on IBM's website (as you know Informix was bought by IBM a couple of years ago). The provider is part of the Client Software Development Kit. Its free to download (but for testing of course you need an Informix database). You can find the SDK on:
http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2004-12-28+15%3A33%3A23.044014R&S_TACT=104CBW71&S_CMP=&s=
regards,
Guy
Thanks,
I'll get it and update the software in the next day or so.
What is the status?
Guy
Grrr. I can install all the providers but the .net one. That just gives me some wierd error.
Can you email me the .dll and I'll see if I can get it to work from there.
Thanks.
Never mind.
I installed on a different machine and it worked OK.
I've updated CVS to include preliminary support for informix now. There are a few things to note.
1. The current HEAD branch in CVS is still being worked on and some things may be broken.
2. The database mapping has changed. Instead of using class="CxxxDatabase" you must now use provider="provider.dll" (ie provider="AF_Informix.dll")
3. I have no idea about some of the informix syntax and I've based the provider on the MSSQL one. I'll need some information about how to get identity values, parameter usage in queries etc.
4. Extra XML mapping options for the database. You can set the service and host settings for the connection string via the <param /> tags.
Ideally I would love it if you could have a go at using the new provider and telling me what needs fixing. Let me know if I need to explain anything further.
- Richard.
Hi Guy,
Real world things have gotten in the way over the last week and I had some trouble with the download from IBM.
I'm actually going to split out the providers from the main persistence framework so that I don't need to worry about redistribution of the variosu providers so the change will take a little more time to get completed due to the plumbing changes I'm doing.
Sorry for the delay.