[Mono-list] An Oracle connection issue of running Prism on Linux with mono

[Jason Lin]

Hello,

I would like to convert win32 Delphi 5 to Delphi Prism and then let it run
with mono on Linux.
Two environmants are listed below.
Windows environment: Windows 2003 + Delphi Prism + Oracle 9i Client
Linux environmant: Radhat Enterprise Linux 4.6 + mono 1.9 + Oracle 9i Client

Test procedure:
A. To complete DB connection with Prism.
1.Add DataNewSource ->select Oracle Database -> enter user name / pwd ->
Test OK
2.Draw field names to Main Form and then Prism creates BindingSource &
TableAdapter
3.This program can connect to database.

B.To copy the executable file to Redhat Linux but it can't connect to
database.
<connectionStrings>
<add name="DBTest.Properties.Settings.ConnectionString"
connectionString="Data Source=tst3;Persist Security Info=True;User
ID=abc;Password=xyz;Unicode=True"
providerName="System.Data.OracleClient" />
</connectionStrings>

Error massage:
** (<unknown>:10151): WARNING **: Missing method
System.Data.OracleClient.OracleParameter::.ctor(string,OracleType,int,ParameterDirection,string,DataRowVersion,bool,object)
in assembly
/opt/mono-1.9.1/lib/mono/gac/System.Data.OracleClient/2.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll,
referenced in assembly /home/oracle/DBTest.exe

Unhandled Exception: System.MissingMethodException: Method not found:
'System.Data.OracleClient.OracleParameter..ctor'.
at DBTest.DataSet1TableAdapters.C_COMPANY_CODE_TTableAdapter.get_Adapter ()
[0x00000]
at DBTest.DataSet1TableAdapters.C_COMPANY_CODE_TTableAdapter.Fill
(DBTest.C_COMPANY_CODE_TDataTable dataTable) [0x00000]
at DBTest.MainForm.MainForm_Load (System.Object sender, System.EventArgs e)
[0x00000]
at System.Windows.Forms.Form.OnLoad (System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnLoadInternal (System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnCreateControl () [0x00000]
at System.Windows.Forms.Control.CreateControl () [0x00000]
at System.Windows.Forms.Control.WmShowWindow (System.Windows.Forms.Message&
m) [0x00000]
at System.Windows.Forms.Control.WndProc (System.Windows.Forms.Message& m)
[0x00000]
at System.Windows.Forms.ScrollableControl.WndProc
(System.Windows.Forms.Message& m) [0x00000]
at System.Windows.Forms.ContainerControl.WndProc
(System.Windows.Forms.Message& m) [0x00000]
at System.Windows.Forms.Form.WndProc (System.Windows.Forms.Message& m)
[0x00000]

C.Another Prism program that isn't a database application can run on Linux
well.

Would someone give me some suggestions about the distribution of Linux and
the version of Oracle? Should I install any packages for database connection
after installed mono?
Which distribution of Linux and which version of Oracle client should I use
to run Prism on Linux?


-- 
View this message in context: http://www.nabble.com/An-Oracle-connection-issue-of-running-Prism-on-Linux-with-mono-tp22877920p22877920.html
Sent from the Mono - General mailing list archive at Nabble.com.