Last post Jan 30, 2015 08:51 AM by 7Mqm
Jan 15, 2015 08:19 AM|7Mqm|LINK
I need to take an old application and repoint it to the new database which is informix. I can't seem to find a way to connect to it. This is what I have so far:
<add name="IBM Informix .NET Data Provider" invariant="IBM.Data.Informix" description="IBM Informix Data Provider for .NET Framework 2.0" type="IBM.Data.Informix.IfxFactory, IBM.Data.Informix, Version=184.108.40.206, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
<add name="IBM Informix .NET Data Provider 3.0.0" invariant="IBM.Data.Informix.3.0.0" description="IBM Informix Data Provider 3.0.0 for .NET Framework 2.0" type="IBM.Data.Informix.IfxFactory, IBM.Data.Informix.3.0.0, Version=220.127.116.11, Culture=neutral, PublicKeyToken=7c307b91aa13d208"/>
Its an ODBC connection but I couldn't find a way to do that so I did this:
Protocol=onsoctcp;UID=uccxwallboard;Password=xxxxxx;Persist Security Info=true;
Authentication=Server" name="Queues" providerName="IBM.Data.Informix" />
It seems to work then I try to run a query and it says:
Exception Details: System.ArgumentException: Invalid argument
var selectCommand = db.Query(@"SELECT CSQName,ConvOldestContact,
FROM dbo.RTCSQsSummary where CSQName not in ('MIStestQueue','CSQ') order by CSQName");
Any ideas would be great.
Jan 16, 2015 02:48 AM|Glenn Saint|LINK
Hi there, what is the data type of your db (e.g. db.Query(...) )?
Check this out http://www.ibm.com/developerworks/data/library/techarticle/dm-1007dsnetids/ this shows how to connect your informix.
Hope that helps.
Jan 19, 2015 11:39 AM|7Mqm|LINK
I'm afraid not. I am looking for using an ODBC connection string in webmatrix.
Jan 30, 2015 05:22 AM|Luther.Lv|LINK
I am looking for using an ODBC connection string in webmatrix.
As for this issue, the best place to find what you're looking for is http://www.connectionstrings.com/. They have just about every way to connect to a datasource listed, from Access to ZIM.
Hope it can help you.
Jan 30, 2015 08:51 AM|7Mqm|LINK
I ended up just writing this in classic asp since the razor syntax didn't allow me to do it. The I referenced it in vbs script and ran it as a scheduled task. Works fine.