[Mono-bugs] [Bug 694047] New: ODBC parameters not working

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=694047

https://bugzilla.novell.com/show_bug.cgi?id=694047#c0


           Summary: ODBC parameters not working
    Classification: Mono
           Product: Mono: Class Libraries
           Version: 2.10.x
          Platform: Other
        OS/Version: Windows XP
            Status: NEW
          Severity: Normal
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: mono-bugs at lists.ximian.com
        ReportedBy: test051102 at hotmail.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---
           Blocker: ---


User-Agent:       Mozilla/5.0 (Windows NT 5.1; rv:2.0.1) Gecko/20100101
Firefox/4.0.1

I am using Mono to access an Oracle db using ODBC.

I have created a simple application which works as follows:

(1) There is a TextBox which allows to enter a part number, a button next to
the TextBox and a GridView/SqlDataSource. The GridView has it's SelectCommand
property set to an sql query which contains an ODBC parameter ('?').

(2) When the button is hit, the form is submitted and the '?' in the query is
replaced with the corresponding form field.

This works without flaws using Windows/ .Net Framework. It fails completely
under Windows XP/ Mono. The example demonstrates a very nice method to create a
simple search engine without writing a single line of code. VS2008 allows to
create such an application graphically. However the generated query must be
edited afterwards (brackets must be removed) because it's optimized for MS-Sql.

Reproducible: Always

Steps to Reproduce:
1. Create an oracle database which contains a simple table with two rows
PART_NO and DESCRIPTION
2. Modify Web.config to correctly access the db using ODBC
3. Run the example application
4. Enter a part number and hit the button
Actual Results:  
The GridView does not display anything when beeing run under win32/ Mono.

Expected Results:  
A GridView should appear which displays the found DESCRIPTION/ PART_NO
combination. This is the case when beeing run under WinXP/ .Net Framework.

-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.