I post the following on the off-chance it saves some time for anyone who may be having the same problem.
I was connecting to an Oracle (10g) database using the instructions here: http://mono-project.com/Oracle, and everything was going swimmingly until I had to use a connection string as per the instructions at "Connection String Format using TNS network description which does not use a tnsnames.ora file". I.e. using a connection string that looked like this: string connectionString = "User ID=user;Password=password;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521))(CONNECT_DATA = (SID = database)(SRVR=DEDICATED)))"; Under MS.NET this would work ok, but under Mono it would throw the following: Unhandled Exception: System.ArgumentException: Connection parameter not supported: 'database)(SRVR' at System.Data.OracleClient.OracleConnection.SetProperties (System.Collections.Specialized.NameValueCollection parameters) [0x00000] at System.Data.OracleClient.OracleConnection.SetConnectionString (System.String connectionString, Boolean persistSecurity) [0x00000] at System.Data.OracleClient.OracleConnection..ctor (System.String connectionString) [0x00000] at (wrapper remoting-invoke-with-check) System.Data.OracleClient.OracleConnection:.ctor (string) With hindsight it's annoyingly obvious that by wrapping the data source in quotes solves the problem, i.e. string connectionString = "User ID=user;Password=password;Data Source= \' (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521))(CONNECT_DATA = (SID = database)(SRVR=DEDICATED))) \' "; -- View this message in context: http://www.nabble.com/Solved%3A--Oracle-Client-Connection%3A-Connection-parameter-not-supported-tp20087966p20087966.html Sent from the Mono - General mailing list archive at Nabble.com. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
