Informix

Expand all | Collapse all

.Net Provider connecting to MS SQL Server

  • 1.  .Net Provider connecting to MS SQL Server

    Posted Tue August 10, 2021 08:50 PM
    Folks,

    Unfortunately, we need to migrate from Informix (12.10.FC14) to MS SQL Server.

    One of our developers is doing some very preliminary experiments.

    We opened a tech support case to get assistance with acquiring and setting up a .Net Provider.  We are working with a very helpful tech, and he pointed us to the IBM DB2 SDK that we are now using with a DRDA connection.

    But, we are having difficulty with DATE, TIME, and CLOB/BLOB data types.  The developer doing the experimenting believes that the problems lie with Informix because, as he says, DATE, TIME and CLOB/BLOB types are standard ANSI types, and that MS SQL Server easily transfers those types from other databases (such as Oracle and MySQL).  But cannot do so from Informix.

    I am not very familiar with databases other than Informix, so am a bit out of my league.

    We had earlier tried to use the 4.50 CSDK, but had difficulties installing it.  The tech suggested we use the DB2 SDK to get the .NET Provider from it.

    We do expect to meet with the tech from tech support again, soon.  But, it never hurts to also seek out additional knowledgeable sources.

    Does anyone have an opinion concerning the most suitable .NET Provider for Informix 12.10.FC14?  Or any tips on migrating the Informix DATE type.  I am not expecting to find a painless migration from Informix DATETIME type, but was surprised to hear from the developer that DATE didn't work.

    Thank you for any comments.

    DG

    ------------------------------
    David Grove
    ------------------------------


  • 2.  RE: .Net Provider connecting to MS SQL Server

    Posted Wed August 11, 2021 02:58 AM
    Hi David.

    You can connect the two directly and migrate data using SQL which is simpler and faster:

    https://www.oninitgroup.com/faq-items/making-microsoft-sql-linked-server-and-informix-work

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 3.  RE: .Net Provider connecting to MS SQL Server

    Posted Wed August 11, 2021 01:10 PM
    Thank you, Doug.

    I have passed this along to the developer who is working on this.

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 4.  RE: .Net Provider connecting to MS SQL Server

    Posted Wed August 11, 2021 08:04 AM
    The problem is the DB2 .NET provider. DB2's data types are different that Informix types so some types are problematic with that driver.

    Use the Informix CSDK. 

    For information sake, why are you porting away from Informix? The cost of doing that is not usually worth it?

    Art





  • 5.  RE: .Net Provider connecting to MS SQL Server

    Posted Wed August 11, 2021 01:37 PM
    Hi Art,

    We were trying the DB2 .NET provider at the suggestion of the tech support engineer.  Neither we nor the tech (who got online with us in a shared screen meeting) could find the .NET provider in the Informix CSDK.

    After distilling down comments received publicly and privately, I have suggested to the developer that we "reboot" and start again, using OLEDB from CSDK 4.50.FC6.  (If we can find it-- Fix Central seems to have only 4.10.* series; and that other marketing page seems not to have 4.50.FC6-- only 4.50.FC5.  The link on the IIUG home page goes to the marketing page [which lacks FC6].  I always have trouble trying to find the latest Informix CSDK.  I still don't know where to find 4.50.FC6.)

    We are moving away from Informix for a combination of technical and political reasons.

    Technically, it is mainly a matter of human resources.  Informix used to be used by various other State of Alaska agencies.  But, now, our agency is the only one left, I think.  (There might be one other, but I haven't had contact with them for years, so don't know for sure.)  In our agency, I am the "last man standing".  No one else has any knowledge, experience, training, or even any exposure to Informix.  The younger developers haven't even heard of it.  They say stuff like, "Informix?  What's that?"  So, there's no one in the pipeline, so to speak, and that puts the agency at risk.  When they wanted to hire, they couldn't find anyone suitable, without having to move someone up from the Lower 48.  In addition, our hardware is another technical challenge.  We run Solaris on Sun (my fingers don't like to type "Oracle") SPARC hardware.  I'm the only one left familiar with that environment.  It is obsolete, and needs to be replaced, and the decision was made that our agency will move to all Windows hardware, rather than having multiple platforms.

    Politically, we face the lack of Informix mindshare.  No one (at the decision-making levels) has heard of Informix.  And, at the developer level, there are some who are actively hostile, continually whispering in management's ear that "real companies use real databases, like Oracle or MS SQL Server."

    So, the decision was made to replace our existing hardware with Windows machines and to migrate to SQL Server.

    That's it in a nutshell.

    DG

    ------------------------------
    David Grove
    ------------------------------



  • 6.  RE: .Net Provider connecting to MS SQL Server

    Posted Wed August 11, 2021 02:03 PM
    David:

    The Informix .NET provider for .NET versions 2.0, 3.0, & 3.5 as well as the .NET provider for .NET versions 4.0 & 4.5 are included in the CSDK beginning with the later (aka current) release of the CSDK v4.10 as well as the current CSDK v4.50.

    Unfortunately because IBM can't manage to manage their own web sites, the CSDK v4.50FC5 & .FC5 are on the server download pages rather than where they belong, on the CSDK download pages. I reported this to IBM over a month ago, but apparently it has not been corrected yet. Try looking there where you would download the Server Development Edition.

    I know you know this, but your agency could do Informix training! Lester and I still do that! Unfortunate that the Community will be losing you and your agency!

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 7.  RE: .Net Provider connecting to MS SQL Server

    Posted Wed August 11, 2021 02:24 PM
    Thank you, Art, for your helpful information.

    "...IBM can't manage to manage their own web sites..."
    Too true.  I just heard from Tech Support, and they told me that the website from which to download 4.50.FC6 is down, but that they had opened a ticket to get it back up!

    Anyway, we have 4.50.FC5 and 4.10.FC14, so we should be able to "take it from the top" and start over attempting to connect to SQL Server with either OLEDB or .NET CORE.

    Regarding training... Indeed, you and Lester do an awesome job.  I had at least one class from Lester way back in the 1998 - 2001 era.

    The State has become so tight with funds that it is no longer possible to do any training, let alone conferences.  Their plan is to centralize everything (remove all developers and support from individual agencies and run everything from a single management authority), and either virtualize everything or put it all in the cloud because of the magic savings that will provide.  I don't perceive that performance is really being considered (I could be wrong) because, at the end of the day, we're the government, and whatever we provide will be what people (and other agencies get, and use, and "love").   I mean, it's not like they have other options, eh?

    I will now go and wash out my cynical mouth with soap.

    DG

    ------------------------------
    David Grove
    ------------------------------