search

jonpryor / dblinq2007

Automatically exported from code.google.com/p/dblinq2007
0 stars 0 forks source link

Ingres database read error / FIX Provided #279

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Passing a parameter, causes the error in a DbLinq query to Ingres
2.
3.

What is the expected output? What do you see instead?
Ingres.Client.IngresException: Local variable/parameter ':custtag' can only be 
used within a database procedure

What version of the product are you using? On what operating system?
Latest svn version reading from an Ingres database

Please provide any additional information below.

The following FIX should work... please can you implement this asap.

The problem occurs in IngresVendor.cs 137/138

//string paramName = "?" + paramAttrib.Name; //eg. '?param1' MYSQL
string paramName = ":" + paramAttrib.Name; //eg. '?param1' PostgreSQL

Ingres uses a '?' for parameters not a ':' The wrong line is commented out

Original issue reported on code.google.com by scullyp...@hotmail.co.uk on 24 Aug 2010 at 10:36

GoogleCodeExporter commented 9 years ago 
Hi,

Problem solved with driver Ingres.net ingres-10.1.0-113-gpl-win-x86-DotNet

Original comment by maxime.r...@gmail.com on 17 Jun 2011 at 11:54

Attachments: