[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