[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: glpk xypron
Subject: Re: [Help-glpk] Testing glpk-4.26-tab
Date: Fri, 29 Feb 2008 18:53:11 +0100

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

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

For MySQL ODBC drivers both for Linux as well as for Windows are available at

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 

For downloads see and

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


-------- 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
> 02) MSYS installation using MSYS-1.0.10.exe (from
> 03) Building gmp from gmp-4.2.1-MSYS-1.0.11.tar.bz2 (from
> (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
> 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

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! 
Ideal für Modem und ISDN:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]