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? --- [EMAIL PROTECTED] wrote: > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] 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: > [EMAIL PROTECTED] > ReportedBy: [EMAIL PROTECTED] > QAContact: [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/mono-bugs > _______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list