Re: .NET provider to MS Visual Studio 2005

On Feb 20, 7:23 am, Bjarne Wilken Jensen <abr...@almbrand.dk> wrote: > Has any one got the IBM Informix 2.90 .NET Provider to work with MS Visual > Studio 2005? > Are trying to connect to and IDS 10.00.FC4 and 8.50.FC2/8.51.FC1 thru a > Integration Services Package > but I only get the possibility to make a OLEDB connection, which fails with > an sql error when used. Hi Bjarne, I have gotten the 2.90 TC5 .NET Provider to work in MS VS 2005 connecting to Informix v7.3. I am also using Integration Services and using OLEDB connections successfully. You didn't provided the sql error that you are getting so I'm just guessing here, but I had a problem with the DELIMIDENT setting. For OLEDB I need to set it to "y", for the .NET Provider I need to set it to "n". Supposedly, you can set the DELIMIDENT value in the .NET Provider connection string. I thought that was working then my laptop crashed and I now have a new one. On this laptop the .NET Provider does not seems to be using the DELIMIDENT value set on the connection string (I still need to do some further testing on this though.) By the way, the Informix OLEDB driver version that I am using is: File version: 2.90.0.12699 Product version: 2.90.TC3 Build Date: May 18 2006 12:14:09 If you provide the sql error message that you are getting maybe we can be of more assistance.