Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. amegahed3

    [ODBC Microsoft Access Driver] System Resource Exceeded

    Hi Hap, That is the thing. I tried asking experts in GLPK, and they were not able to help me, as the problem is related to ODBC/Access connection issues, that take a large amount of memory and so my GLPK code crashes before it's finished. So, my question was if there is a way that I can close...
  2. amegahed3

    [ODBC Microsoft Access Driver] System Resource Exceeded

    Here is part of my code (but put in mind that it is a GLPK code). Also, the file d2.dsn that I call has only the lines I posted above. Here is the part from my code (it is basically the exact same as my whole code, except that my code is a bit bigger, but that sample contains all distinct...
  3. amegahed3

    [ODBC Microsoft Access Driver] System Resource Exceeded

    Hi Hap, Thanks a lot for your reply. I have the following questions, please: 1. Could you please specify exactly where I should write that code? 2. how to run it? 3. How would I call it each time I need to read or write to the database? 4. In the code, I don't see any reference to the...
  4. amegahed3

    [ODBC Microsoft Access Driver] System Resource Exceeded

    Hi all, I connect to Access from an open source optimization language (GLPK) through ODBC, in order to read some data, which I use as model inputs in GLPK and then I make the GLPK writes outputs back to Access. I use Access 2007 and windows xp.This has been working pretty well, but now for a...
  5. amegahed3

    Writing Values back to a database

    Well, after MANY trials and asking different people, I was able to get the correct code. Here it is for anyone's reference: table x3_iii {j in TF, k in C, p in P, t in T: x3[j,k,p,t]>0} OUT 'ODBC' 'FileDSN=.\d2.dsn' 'UPDATE ((Channels a INNER JOIN ChannelPeriodProducts b' 'ON a.ChannelID...
  6. amegahed3

    Writing Values back to a database

    Hi All, I'm trying to write values back to an access database from an open source mathematical programming language (called glpk) using ODBC. I succeeded in doing so in most variables except one. The problem is described below: The following code gets an error when writing the data: \begin...

Part and Inventory Search

Back
Top