[Mono-bugs] [Bug 69607][Maj] Changed - [Odbc] Memory problems with OdbcDataReader.

bugzilla-daemon@bugzilla.ximian.com bugzilla-daemon@bugzilla.ximian.com
Wed, 17 Nov 2004 17:36:33 -0500 (EST)


Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by sebastien.robitaille@croesus.com.

http://bugzilla.ximian.com/show_bug.cgi?id=69607

--- shadow/69607	2004-11-17 16:06:12.000000000 -0500
+++ shadow/69607.tmp.22112	2004-11-17 17:36:33.000000000 -0500
@@ -87,6 +87,69 @@
 
 ------- Additional Comments From bmaurer@users.sf.net  2004-11-17 16:06 -------
 THis is probably a gc problem.
 
 How do I get a database with odbc on linux? Can you give quick setup 
 instructions?
+
+------- Additional Comments From sebastien.robitaille@croesus.com  2004-11-17 17:36 -------
+Hi Ben,
+
+Thanks for your quick response...
+
+FYI, to access a database on Linux with ODBC, you will need two 
+things:
+unixODBC (www.unixODBC.org) 
+and an ODBC driver for your database (I use freeTDS for Sybase) 
+For a list of supported drivers, see: 
+http://www.unixodbc.com/drivers.html
+
+Once unixODBC and your driver are installed on your machine, you 
+will have to configure unixODBC: 1) to use your database driver, 2) 
+to access your database server.
+
+1) This can be done by editing the <...>/etc/odbcinst.ini file and 
+by adding a section for your driver in this file. 
+
+Ex.
+
+[MyTDSDriver]
+Description = MyTDSDriver
+Driver      = /usr/lib/libtdsodbc.so
+Setup       = /usr/lib/libtdsodbc.so
+FileUsage   = 1
+CPTimeout   =
+CPReuse     =
+
+
+2) Add a ".odbc.ini" file to your home directory. This file must 
+contain the DNS information for your database (server name, port, 
+etc.).
+
+Ex.
+
+[MyDSN]
+Description     = MyDSN
+Driver          = MyTDSDriver
+Servername      = MyServerName
+Server          = MyServerName
+Address         = 192.168.1.101
+Port            = 4101
+Database        = sebastienr_syb99
+TDS_Version     = 5.0
+Language        = us_english
+TextSize        =
+Domain          =
+PacketSize      =
+
+
+After that, to open your ODBC connection with mono, you will have to 
+use a connection string similar this one:
+
+DSN=MyDSN;UID=sa;PWD=sa;
+
+NOTE: You also may have to change the default "remap dll" line for 
+ODBC in the mono config file 
+from: <dllmap dll="odbc32.dll" target="libodbc.so" />
+to: <dllmap dll="odbc32" target="libodbc.so" />
+
+Sébas