Re: [Pharo-project] connection to access databases

2010-07-20 Thread Germán Arduino
Not, ODBC is a package developed by Diego Gomez Deck and, as far as I know, the project on Squeaksource is owned by Frank Urbach and Benoit St Jean. 2010/7/20 Mariano Martinez Peck : > > > On Mon, Jul 19, 2010 at 9:07 PM, Stéphane Ducasse > wrote: >> >> Thanks eliot. >> Who is maintaining ODBC?

Re: [Pharo-project] connection to access databases

2010-07-20 Thread Mariano Martinez Peck
On Mon, Jul 19, 2010 at 9:07 PM, Stéphane Ducasse wrote: > Thanks eliot. > Who is maintaining ODBC? to commit the changes? > > I think Andreas. > On Jul 19, 2010, at 7:39 PM, Eliot Miranda wrote: > > > moduleName > > "Return the name of the module for this library" > > Smalltalk pl

Re: [Pharo-project] connection to access databases

2010-07-20 Thread Tudor Girba
Hi Eliot, Thanks for the suggestion. I did check the connection again and it seems that something was wrong with System-wide DSN. Everything seems to work properly with User DSN. Thanks everyone for all the help. Doru On 20 Jul 2010, at 00:13, Eliot Miranda wrote: Hi Doru, On Mon, Jul

Re: [Pharo-project] connection to access databases

2010-07-19 Thread Eliot Miranda
Hi Doru, On Mon, Jul 19, 2010 at 1:51 PM, Tudor Girba wrote: > Thanks Eliot. > > Indeed this allowed me to connect, but now I have problems executing even > simple queries. For example, when executing the following code, the > sqlAllocStmtConnection:statement: fails saying "Could not coerce > a

Re: [Pharo-project] connection to access databases

2010-07-19 Thread Tudor Girba
Thanks Eliot. Indeed this allowed me to connect, but now I have problems executing even simple queries. For example, when executing the following code, the sqlAllocStmtConnection:statement: fails saying "Could not coerce arguments": connection := ODBCConnection dsn: 'Test' user: '' passw

Re: [Pharo-project] connection to access databases

2010-07-19 Thread Stéphane Ducasse
Thanks eliot. Who is maintaining ODBC? to commit the changes? On Jul 19, 2010, at 7:39 PM, Eliot Miranda wrote: > moduleName > "Return the name of the module for this library" > Smalltalk platformName = 'Win32' ifTrue:[^'odbc32']. > Smalltalk platformName = 'unix' ifTrue:[^ 'lib

Re: [Pharo-project] connection to access databases

2010-07-19 Thread Eliot Miranda
moduleName "Return the name of the module for this library" Smalltalk platformName = 'Win32' ifTrue:[^'odbc32']. Smalltalk platformName = 'unix' ifTrue:[^ 'libodbc.so']. Smalltalk platformName = 'Mac OS' ifTrue:[^ 'libiodbc.dylib']. ^self error: 'Don''t know the ODBC library name' works for me. F

Re: [Pharo-project] connection to access databases

2010-07-19 Thread Tudor Girba
Hi, Thanks for all the pointers. I am now testing on Mac using the Actual driver: http://www.actualtech.com/product_access.php I managed to get it running, but now I have problems with the ODBC Pharo implementation because there seems to be no module for Mac: ODBCLibrary class>>moduleName

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Germán Arduino
Yes, Indeed, I mean, I used a driver to access, but can't remember now the brand, but I'm sure I not payed for it :) May be I used some trial version 2010/7/18 Levente Uzonyi : > > On Sun, 18 Jul 2010, Germán Arduino wrote: > >> Not, I'm not talking of propietary software. >> >> I'm talking o

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Levente Uzonyi
On Sun, 18 Jul 2010, Germán Arduino wrote: Not, I'm not talking of propietary software. I'm talking of one I used when helped Diego with the testing of the odbc package. Don't remember now, but may be this http://www.unixodbc.org/ ? ODBC is just an API, if you don't have a driver for yourdat

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Levente Uzonyi
On Sun, 18 Jul 2010, laurent laffont wrote: 2010/7/18 Levente Uzonyi On Sun, 18 Jul 2010, Germán Arduino wrote: Hi Tudor: Is as Levente says, you must define an ODBC source on a Windows PC (Alternatively on Unix you can use ODBC also). I don't know any free ODBC drivers for Access on u

Re: [Pharo-project] connection to access databases

2010-07-18 Thread laurent laffont
2010/7/18 Levente Uzonyi > On Sun, 18 Jul 2010, Germán Arduino wrote: > > Hi Tudor: >> >> Is as Levente says, you must define an ODBC source on a Windows PC >> (Alternatively on Unix you can use ODBC also). >> > > I don't know any free ODBC drivers for Access on un*x. I only know a driver > whic

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Germán Arduino
Not, I'm not talking of propietary software. I'm talking of one I used when helped Diego with the testing of the odbc package. Don't remember now, but may be this http://www.unixodbc.org/ ? About Mac, sorry, never touched a mac in all my life Cheers. 2010/7/18 Levente Uzonyi : > On Sun, 18

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Alexandre Bergel
No idea about that. But let us know if you succeed. Good luck, Alexandre On 17 Jul 2010, at 23:35, Tudor Girba wrote: > Hi, > > Is there a way to connect to a Microsoft Access database from Pharo? > > I have an mdb file of 300 Mb that I would need to analyze. > > Cheers, > Doru > > > -- >

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Levente Uzonyi
On Sun, 18 Jul 2010, Tudor Girba wrote: Hi, Thanks for the pointers. Levente, could you point me to this driver for mac? Sure: http://www.actualtech.com/product_access.php Note that I have no experience with it, but there's a trial version. Levente Cheers, Doru On 18 Jul 2010, at 20:3

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Tudor Girba
Hi, Thanks for the pointers. Levente, could you point me to this driver for mac? Cheers, Doru On 18 Jul 2010, at 20:34, Levente Uzonyi wrote: On Sun, 18 Jul 2010, Germán Arduino wrote: Hi Tudor: Is as Levente says, you must define an ODBC source on a Windows PC (Alternatively on Unix you

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Levente Uzonyi
On Sun, 18 Jul 2010, Germán Arduino wrote: Hi Tudor: Is as Levente says, you must define an ODBC source on a Windows PC (Alternatively on Unix you can use ODBC also). I don't know any free ODBC drivers for Access on un*x. I only know a driver which costs 4-5 times more than the windows OS it

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Germán Arduino
Hi Tudor: Is as Levente says, you must define an ODBC source on a Windows PC (Alternatively on Unix you can use ODBC also). Some examples on: http://wiki.squeak.org/squeak/2480 Cheers. Germán. 2010/7/18 Levente Uzonyi : > On Sun, 18 Jul 2010, Tudor Girba wrote: > >> Thanks Mariano! >> >> Indee

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Levente Uzonyi
On Sun, 18 Jul 2010, Tudor Girba wrote: Thanks Mariano! Indeed, if I load ConfigurationOfFFI first, everything loads well. I am a complete newbie in this area. Can anyone tell me what I should do next? I imagine that I should connect to an Access server. If yes, how would I do that? Also

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Tudor Girba
Thanks Mariano! Indeed, if I load ConfigurationOfFFI first, everything loads well. I am a complete newbie in this area. Can anyone tell me what I should do next? I imagine that I should connect to an Access server. If yes, how would I do that? Also, do I need anything else, like a C plug

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Mariano Martinez Peck
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba wrote: > Hi, > > I tried loading it, but I get : > "This package depends on the following classes: > ExternalLibrary > ExternalStructure" > > Can anyone tell me where to find these from? > This means that you need Metacello ;) Those classes are fro

Re: [Pharo-project] connection to access databases

2010-07-18 Thread Mariano Martinez Peck
On Sun, Jul 18, 2010 at 8:51 AM, Tudor Girba wrote: > From the webpage, it looks like Access is not among the supported backends. > > But, I would be happy to be wrong :). Does anyone have a more precise idea? > > SqueakDBX doesn't support Access but does ODBC. However, I think using the ODBC dri

Re: [Pharo-project] connection to access databases

2010-07-17 Thread Tudor Girba
From the webpage, it looks like Access is not among the supported backends. But, I would be happy to be wrong :). Does anyone have a more precise idea? Doru On 18 Jul 2010, at 02:14, Gabriel Brunstein wrote: Maybe squeakDBX, i don't know if it supports Access. On Sat, Jul 17, 2010 at 7

Re: [Pharo-project] connection to access databases

2010-07-17 Thread Tudor Girba
Hi, I tried loading it, but I get : "This package depends on the following classes: ExternalLibrary ExternalStructure" Can anyone tell me where to find these from? Also, are there eternal prerequisites to work with ODBC? Cheers, Doru On 18 Jul 2010, at 00:35, Levente Uzonyi wrote: On S

Re: [Pharo-project] connection to access databases

2010-07-17 Thread Gabriel Brunstein
Maybe squeakDBX, i don't know if it supports Access. On Sat, Jul 17, 2010 at 7:35 PM, Levente Uzonyi wrote: > On Sat, 17 Jul 2010, Tudor Girba wrote: > > Hi, >> >> Is there a way to connect to a Microsoft Access database from Pharo? >> > > Yes, with ODBC. > > > Levente > > > >> I have an mdb fi

Re: [Pharo-project] connection to access databases

2010-07-17 Thread Levente Uzonyi
On Sat, 17 Jul 2010, Tudor Girba wrote: Hi, Is there a way to connect to a Microsoft Access database from Pharo? Yes, with ODBC. Levente I have an mdb file of 300 Mb that I would need to analyze. Cheers, Doru -- www.tudorgirba.com "Next time you see your life passing by, say 'hi' and

[Pharo-project] connection to access databases

2010-07-17 Thread Tudor Girba
Hi, Is there a way to connect to a Microsoft Access database from Pharo? I have an mdb file of 300 Mb that I would need to analyze. Cheers, Doru -- www.tudorgirba.com "Next time you see your life passing by, say 'hi' and get to know her." ___ P