Re: [Help-glpk] Testing glpk-4.26-tab

[glpk xypron]

Hello Ted,

ODBC is a technology allowing to communicate to a lot of different data bases 
like Oracle, MySQL and Microsoft SQL Server, etc. ODBC drivers are availabe for 
data bases both in Linux and Windows. For an overview see

http://en.wikipedia.org/wiki/Call_Level_Interface

ODBC creates portability because their is no need to integrate a separate 
driver into GLPK for every data base out in the market. 

You could argue, why did I put native MySQL support into glpk at all.

For SQLite an ODBC for driver both for Linux and Windows is available at 
http://www.ch-werner.de/sqliteodbc/

For MySQL ODBC drivers both for Linux as well as for Windows are available at 
http://dev.mysql.com/downloads/connector/odbc/.

After installing the database driver You will have to set up a data source. In 
Windows 2003 Server this is the way to set up an ODBC data source:

>From the start menu choose 
Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC)

If You want to be the sole user of the data source, add a "User DSN".
If other users on Your computer shall use the data source, add a "System DSN".

After pressing the the "Add" button, select the driver for the data base (in 
Your case SQLite) and press the "Finish" button.

Now enter the details like user name, password, database.

For Linux two major implementations of ODBC are iODBC and unixODBC. The 
configure file I supplied supports iODBC. Need it be, I could add support for 
unixODBC too.

To setup data sources for iODBC You have to edit the files /etc/odbc.ini and 
/etc/odbcinst.ini.

For downloads see
http://www.iodbc.org/ and 
http://www.unixodbc.org/

If You mean by portability, how to carry data base content from one system to 
another, an easy way is to dump the data base to SQL files and to import these 
into the other system.

Best regards

Xypron

-------- Original-Nachricht --------
> Datum: Fri, 29 Feb 2008 08:18:09 -0800 (PST)
> Von: Ted Poe <address@hidden>
> An: address@hidden
> Betreff: Re: [Help-glpk] Testing glpk-4.26-tab

> ...and here are my notes if you want to do the same using MinGW.
> 
> Thanks, Xypron.  What I realized, at the end of all of this, is that
> ODBC immediately takes away portability because of the requirement to
> link the MySQL database using ODBC.  So far, for portability, we have
> CSV and xBase.  Yours and Andrew's coding skills are far above mine in
> this area.  Would anyone care to comment on the feasibility of adding
> sqlite?  It, too is cross-platform, and it is portable.
> 
> Thanks to both of you, again, for all of the effort.
> 
> Ted
> 
> =======
> 
> Notes on building GLPK under MinGW:
> 
> 01) MinGW installation (incl. mingw-w32-make) (as per
> http://www.mingw.org/MinGWiki/index.php/SmartQuickStart)
> 02) MSYS installation using MSYS-1.0.10.exe (from
> http://sourceforge.net/project/showfiles.php?group_id=2435)
> 03) Building gmp from gmp-4.2.1-MSYS-1.0.11.tar.bz2 (from
> http://sourceforge.net/project/showfiles.php?group_id=2435) (configure,
> make, make install)
> 04) NOTE: in MSYS environment, /usr is linked to /
> 05) Configure glpk with: env CPPFLAGS=-I/usr/local/include
> LDFLAGS=-L/usr/local/lib ./configure --enable-gmp --enable-odbc32
> 06) make 
> 07) On my system, I had to run regedit to delete odbccp32.cpl key in
> HKEY_CURRENT_USER\Control Panel\don’t load
> 08) Download and install ODBC driver for MySQL from
> http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32
> 09) Start mysql (I had already created the glpk database using
> transp.sql)
> 10) In ODBC control Panel/System DSN, add a new data source using the
> MySQL ODBC 3.51 Driver (Data Source Name=glpk, User=glpk, Password=gnu,
> Database=glpk)
> 11) cd examples
> 12) glpsol -m transp_odbc.mod -o transp_out.txt
> 
> 
> 
> _______________________________________________
> Help-glpk mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-glpk

-- 
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer