Re: [Help-glpk] [Fwd: GMPL table stmt]

[xypron . glpk]

> IM014:1:0:[Microsoft][ODBC Driver Manager] The specified DSN contains an
> 
> architecture mismatch between the Driver and Application

You are trying to use a 32bit DSN from a 64 bit executable or vice versa.

Make sure the bitness of the used components matches.

Best regards

Heinrich Schuchardt

http://www.xypron.de

Am 28.06.13 um 00:47 schrieb Andrew Makhorin

> -------- Forwarded Message --------
> 
> From: technical forestry services <address@hidden>
> 
> To: address@hidden
> 
> Subject: GMPL table stmt
> 
> Date: Fri, 28 Jun 2013 10:06:35 +1200
> 
> 
> 
> Hello
> 
> 
> 
> I have been trying to get GMPL to read an SQLite3 database using the
> 
> following syntax.
> 
> 
> 
> set I ;
> 
> set J ;
> 
> set S dimen 2;
> 
> 
> 
> param c{i in I, j in J} ;
> 
> param d{i in I, j in J} ;
> 
> 
> 
> # table statement creates indexed parameters c[i, j] and d[i, j]
> 
> # and set S comprising (string) indices (i, j)
> 
> table tbl IN "iODBC"
> 
> 'DSN=SQLite3 Datasource'
> 
> 'SELECT id, srce, dest, dist, cost '
> 
> 'FROM Ytij':
> 
> S <- [srce, dest], d~dist, c~cost ;
> 
> 
> 
> data ;
> 
> set I := Seattle San-Diego ;
> 
> 
> 
> set J := New-York Chicago Topeka ;
> 
> end ;
> 
> 
> 
> There seems to be an issue with the table statement in that the code
> 
> will compile OK
> 
> and by adding GMPL printf and display statements will correctly list the
> 
> database contents
> 
> during the compile phase.  However during any Build phase I get the
> 
> following error message:
> 
> 
> 
> Reading tbl...
> 
> Failed to connect
> 
> 
> 
> The driver reported the following diagnostics whilst running
> 
> SQLDriverConnect
> 
> IM014:1:0:[Microsoft][ODBC Driver Manager] The specified DSN contains an
> 
> architecture mismatch between the Driver and Application
> 
> Test_glpk_sqlite3.mod:27: error on opening table tbl
> 
> MathProg model processing error
> 
> >Exit code: 1    Time: 0.228
> 
>   
> 
> I have tried a couple of SQLite-ODBC drivers without success:
> 
> 1) sqliteodbc.exe available at www.ch-werner.de/sqliteodbc (installs
> 
> with (System) DSN=SQLite3 Datasource).    
> 
> 2)sqlite odbc driver as part of SQLite2009 Pro Enterprise Manager
> 
> (installs with (System) DSN=DSN_SQLite2010Pro).  
> 
> SQLite2009 Pro Manager is available at
> 
> www.sqlite.org/cvstrac/wiki?p=ManagementTools   . 
> 
> 
> 
> Changing the driver has no effect as the same error is reported during
> 
> the Build phase.
> 
> 
> 
> I attach the database that I attempted to read from.
> 
> 
> 
> If you can shed any light on the issue I would be extremely grateful.
> 
> 
> 
> If you require further information don't hesitate to make contact.
> 
> 
> 
> Would you please acknowledge receipt of this E-mail.
> 
> 
> 
> Regards
> 
> 
> 
> LRB
> 
> 
> 
> _______________________________________________
> 
> Help-glpk mailing list
> 
> address@hidden
> 
> https://lists.gnu.org/mailman/listinfo/help-glpk