Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Ingres database read error / FIX Provided #279

Open
GoogleCodeExporter opened this issue Apr 24, 2015 · 1 comment
Open

Ingres database read error / FIX Provided #279

GoogleCodeExporter opened this issue Apr 24, 2015 · 1 comment
Labels
auto-migrated

Comments

@GoogleCodeExporter
Copy link 

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
Copy link
Author 

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:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
auto-migrated
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@GoogleCodeExporter