Re: make wxw & odbc

Am So, den 18.07.2004 schrieb Kevin Gordon um 8:47:
> I am still experimenting Mike. 
> *******************************************************************************************************
> linuxpro Debug # ./wxnet-run Dbgrid2.exe
> 
> Unhandled Exception: System.DllNotFoundException: odbc32
> in <0x00053> (wrapper managed-to-native) 
> System.Data.Odbc.libodbc:SQLAllocHandle 
> (System.Data.Odbc.OdbcHandleType,intptr,intptr&)
> in <0x000ad> System.Data.Odbc.OdbcConnection:Open ()
> in <0x0004f> (wrapper remoting-invoke-with-check) 
> System.Data.Odbc.OdbcConnection:Open ()
> in <0x00b1c> wx.Samples.MyFrame:.ctor 
> (string,System.Drawing.Point,System.Drawing.Size)
> in <0x00094> wx.Samples.DBGRID:OnInit ()
> in <0x00040> (wrapper native-to-managed) wx.Samples.DBGRID:OnInit ()
> in (unmanaged) (wrapper managed-to-native) wx.App:wxApp_Run (int,string[])
> in <0x00004> (wrapper managed-to-native) wx.App:wxApp_Run (int,string[])
> in <0x00021> wx.App:Run ()
> in <0x00031> wx.Samples.DBGRID:Main ()
> ****************************************************************************************************
> The code I am using is derived from Dbgrid.cs (the sample). I modified it to 
> use Npgsql and that is running successfully. Previously I have used unixODBC 
> and wxWindows with the wxWindows Db sample. Thus I have the DSN previously 
> used. I am now trying to use the Dbgrid.cs (for Npgsql) modified back to 
> ODBC. This is really the original Dbgrid.cs file modified to access a 
> database created by me. Questions: What do I need to do to use unixODBC on 
> Mono.net plus wx.NET?
> Many thanks for your help

You have to make a link in /usr/lib or /usr/local/lib to your libodbc.so
(libodbc.so.1, libodbc.so.1.0.0 or whatever it is called)

ln -s libodbc.so libodbc32.so 
or
ln -s libodbc.so.1 libodbc32.so 

Otherwise mono can't find the odbc lib...

For setting up unixODBC use a tool like gODBCConfig...
(for postgresql use Driver=/usr/<local/>lib/postgresql/lib/psqlodbc.so
and Setup=/usr/<local/>lib/odbc/libodbcpsqlS.so)

Hope that helps...

-- 
Regards
Alexander Olk



-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click