[Mono-dev] Bug 393920 - ORACLE: error connecting to database (X86-64)

[Daniel Morgan]

I have not tested System.Data.OracleClient on X86-64
in 64-bits mode.  

Could you have developed/tested using a 32-bit
machine?

Marshaling of data between the managed
System.Data.OracleClient and the OCI library could be
the source of the problem.  Particularly, with the
marshaling of unicode strings, integers, and enums.

Also, could you have funky embedded characters in your
username or password in your connection string.  It
maybe best to delimit your username and password with
a single-quote.

con.ConnectionString = "Data Source=somehost;User
ID='BOB';Password='SMITH#082';

Do you have an embedded double-quote or single-quote
in your username or password?

--- bugzilla_noreply at novell.com wrote:

> From: bugzilla_noreply at novell.com
> To: mono-bugs at lists.ximian.com
> Date: Fri, 23 May 2008 05:01:55 -0600 (MDT)
> Subject: [Mono-bugs] [Bug 393920] New: ORACLE: error
> connecting to database
> 	(X86-64)
> 
> https://bugzilla.novell.com/show_bug.cgi?id=393920
> 
> User pedro.spires at gmail.com added comment
>
https://bugzilla.novell.com/show_bug.cgi?id=393920#c1
> 
>            Summary: ORACLE: error connecting to
> database (X86-64)
>            Product: Mono: Class Libraries
>            Version: SVN
>           Platform: x86-64
>         OS/Version: RHEL 4
>             Status: NEW
>           Severity: Critical
>           Priority: P5 - None
>          Component: Sys.Data
>         AssignedTo:
> bnc-blr-team-mono at forge.provo.novell.com
>         ReportedBy: pedro.spires at gmail.com
>          QAContact: mono-bugs at lists.ximian.com
>           Found By: Development
> 
> 
> When i connect to database i get the following
> error:
> 
> Unhandled Exception:
> System.Data.OracleClient.OracleException: ORA-00604:
> error
> occurred at recursive SQL level 1
> ORA-01756: quoted string not properly terminated.
>   at
>
System.Data.OracleClient.Oci.OciGlue.CreateConnection
> (OracleConnectionInfo conInfo) [0x00000]
>   at
>
System.Data.OracleClient.OracleConnectionPoolManager.CreateConnection
> (OracleConnectionInfo info) [0x00000]
>   at
>
System.Data.OracleClient.OracleConnectionPool.CreateConnection
> ()
> [0x00000]
>   at
>
System.Data.OracleClient.OracleConnectionPool.GetConnection
> () [0x00000]
>   at System.Data.OracleClient.OracleConnection.Open
> () [0x00000]
>   at Altaia.GeoProbe.Program.IsRunning () [0x00000]
>   at Altaia.GeoProbe.Program.Main (System.String[]
> args) [0x00000]
> 
> the machine is a Dual-Core AMD Opteron(tm) Processor
> 8218
> Red Hat Enterprise Linux AS release 4 (Nahant Update
> 4)
> Linux 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT
> 2006 x86_64 x86_64 x86_64
> GNU/Linux
> 
> 
> This just happens in on this machine (production
> machine). It works well on
> development machine (32 bits Slackware 12) and on
> Windows Micosoft .NET 2.0
> 
> 
> I've done a little code to test:
> 
> 
> using System;
> using System.Data.OracleClient;
> 
> namespace Altaia.GeoProbe
> {
>     public class Program
>     {
>         public static int Main(string[] args)
>         {
>                 IsRunning();
>                 return 0;
>         }
> 
>         public static void IsRunning()
>         {
>             string conn = "Server=E29n.pt;User
> ID=xxxxx;Password=xxxxx;";
>             Console.WriteLine(conn);
>             OracleConnection connection = new
> OracleConnection(conn);
>             connection.Open();
>             connection.Close();
>         }
>     }
> }
> 
> This error doesn't allow our application to go in
> production.
> This is our first time using mono
> 
> The mono environment is installed on our user and
> not system wide.
> We had to install also pkg-config-0.22 and
> glib-2.16.3 in user area too.
> 
> I've tried mono version 1.9.1 and svn version
> 
> Please help, this problem is causing us some
> problems we didn't expect
> 
> Thanks
> 
> 
> -- 
> Configure bugmail:
> https://bugzilla.novell.com/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You are the QA contact for the bug.
> _______________________________________________
> mono-bugs maillist  -  mono-bugs at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-bugs
>