[Pharo-project] connection to access databases
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."
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 get to know her."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
Maybe squeakDBX, i don't know if it supports Access. On Sat, Jul 17, 2010 at 7:35 PM, Levente Uzonyi <leves@elte.hu> 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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:35 PM, Levente Uzonyi <leves@elte.hu> 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "Don't give to get. Just give."
On Sun, Jul 18, 2010 at 8:51 AM, Tudor Girba <tudor.girba@gmail.com> 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 driver would be easier for you.
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:35 PM, Levente Uzonyi <leves@elte.hu> 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Don't give to get. Just give."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 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 get to know her."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "Speaking louder won't make the point worthier."
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere... For the moment, I recommend you to install FFI using the ConfigurationOfFFI. Cheers Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 plugin/library to get the C calls from ODBCLibrary going? Cheers, Doru On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "When people care, great things can happen."
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image. Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested. Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com
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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo- project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo- project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo- project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo- project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "It's not how it is, it is how we see it."
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: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 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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"It's not how it is, it is how we see it."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net>  Twitter: garduino Arduino Software & Web Hosting  http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
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 yourdatabase, then it won't help. Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net>  Twitter: garduino Arduino Software & Web Hosting  http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net>  Twitter: garduino Arduino Software & Web Hosting  http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name' Is there something to be done in this area? Cheers, Doru On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com
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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo- project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "Every thing should have the right to be different."
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. Find attached. On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote:
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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba < tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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:[^ 'libodbc.so']. Smalltalk platformName = 'Mac OS' ifTrue:[^ 'libiodbc.dylib']. ^self error: 'Don''t know the ODBC library name'
works for me. Find attached.
On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote: 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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
<ODBCLibrary class-moduleName.st>_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
On Mon, Jul 19, 2010 at 9:07 PM, Stéphane Ducasse <stephane.ducasse@inria.fr
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 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. Find attached.
On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote: 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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
<ODBCLibrary class-moduleName.st>_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 <marianopeck@gmail.com>:
On Mon, Jul 19, 2010 at 9:07 PM, Stéphane Ducasse <stephane.ducasse@inria.fr> 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 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. Â Find attached.
On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote: 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     "Return the name of the module for this library"     SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ].     SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ].     ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino  <gsa @ arsol.net>  Twitter: garduino Arduino Software & Web Hosting  http://www.arduinosoftware.com PasswordsPro  http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
<ODBCLibrary class-moduleName.st>_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net>  Twitter: garduino Arduino Software & Web Hosting  http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
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: '' password: ''. connection query: 'select * from TABLE' Am I doing something wrong, or is it something else? Cheers, Doru On 19 Jul 2010, at 19:39, Eliot Miranda wrote:
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. Find attached.
On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote: 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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
<ODBCLibrary class- moduleName.st>_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "Every thing has its own flow."
Hi Doru, On Mon, Jul 19, 2010 at 1:51 PM, Tudor Girba <tudor.girba@gmail.com> 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 arguments":
connection := ODBCConnection dsn: 'Test' user: '' password: ''. connection query: 'select * from TABLE'
Am I doing something wrong, or is it something else?
difficult to know. I was using ODBC & mysql to test the threaded VM late last year but I haven't ported this to Snow Leopard. Anyway, I used Apple's ODBC tools and the mysql tools to check the database was setup correctly before I used the ODBCConnect code. Apple's recently released their ODBC tools for SNow Leopard http://reviews.cnet.com/8301-13727_7-10330516-263.html. So I recommend using the relevant tools to check the DB is configured correctly before you try and debug ODBCConnect. cheers, Eliot
Cheers, Doru
On 19 Jul 2010, at 19:39, Eliot Miranda wrote:
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. Find attached.
On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote: 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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
<ODBCLibrary class-moduleName.st>_______________________________________________
Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing has its own flow."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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 19, 2010 at 1:51 PM, Tudor Girba <tudor.girba@gmail.com> 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 arguments":
connection := ODBCConnection dsn: 'Test' user: '' password: ''. connection query: 'select * from TABLE'
Am I doing something wrong, or is it something else?
difficult to know. I was using ODBC & mysql to test the threaded VM late last year but I haven't ported this to Snow Leopard. Anyway, I used Apple's ODBC tools and the mysql tools to check the database was setup correctly before I used the ODBCConnect code. Apple's recently released their ODBC tools for SNow Leopard http://reviews.cnet.com/8301-13727_7-10330516-263.html . So I recommend using the relevant tools to check the DB is configured correctly before you try and debug ODBCConnect.
cheers, Eliot
Cheers, Doru
On 19 Jul 2010, at 19:39, Eliot Miranda wrote:
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. Find attached.
On Mon, Jul 19, 2010 at 1:41 AM, Tudor Girba <tudor.girba@gmail.com> wrote: 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 "Return the name of the module for this library" SmalltalkImage current platformName = 'Win32' ifTrue: [ ^ 'odbc32' ]. SmalltalkImage current platformName = 'unix' ifTrue: [ ^ 'libodbc.so' ]. ^ self error: 'Don''t know the ODBC library name'
Is there something to be done in this area?
Cheers, Doru
On 19 Jul 2010, at 01:04, Germán Arduino wrote:
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 <leves@elte.hu>:
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 yourdatabase, then it won't help.
Levente
About Mac, sorry, never touched a mac in all my life....
Cheers.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- ================================================= Germán S. Arduino <gsa @ arsol.net> Twitter: garduino Arduino Software & Web Hosting http://www.arduinosoftware.com PasswordsPro http://www.passwordspro.com =================================================
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing should have the right to be different."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
<ODBCLibrary class- moduleName.st>_______________________________________________
Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Every thing has its own flow."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com "One cannot do more than one can do."
2010/7/18 Levente Uzonyi <leves@elte.hu>
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
On Linux I've used libmdbodbc from mdbtools http://mdbtools.sourceforge.net/ to migrate an access database 2 years ago. (using ruby & rubyodbc binding) Cheers, Laurent Laffont
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
On Sun, 18 Jul 2010, laurent laffont wrote:
2010/7/18 Levente Uzonyi <leves@elte.hu>
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 itself :). But there's a driver for mac which costs only 30 usd if you're interested.
On Linux I've used libmdbodbc from mdbtools http://mdbtools.sourceforge.net/ to migrate an access database 2 years ago. (using ruby & rubyodbc binding)
This looks good and probably works on a Mac too: http://www.automatthew.com/2008/02/how-to-compile-mdbtools-on-mac-os-x.html Levente
Cheers,
Laurent Laffont
Levente
Some examples on: http://wiki.squeak.org/squeak/2480
Cheers. Germán.
2010/7/18 Levente Uzonyi <leves@elte.hu>:
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, do I need anything else, like a C plugin/library to get the C calls from ODBCLibrary going?
First you'll need a pc running windows. Then you have to create an ODBC Data Source for your Access file. Then you'll be able to create a connection to that datasource from your image.
Levente
Cheers, Doru
On 18 Jul 2010, at 09:17, Mariano Martinez Peck wrote:
On Sun, Jul 18, 2010 at 8:49 AM, Tudor Girba <tudor.girba@gmail.com> 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 from FFI, a pre-requisite for ODBC to work. Maybe there is a ConfigurationOfODBC somewhere...
For the moment, I recommend you to install FFI using the ConfigurationOfFFI.
Cheers
Mariano
Also, are there eternal prerequisites to work with ODBC?
Cheers, Doru
On 18 Jul 2010, at 00:35, 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 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."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"Speaking louder won't make the point worthier."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- www.tudorgirba.com
"When people care, great things can happen."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
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
-- www.tudorgirba.com
"Next time you see your life passing by, say 'hi' and get to know her."
_______________________________________________ Pharo-project mailing list Pharo-project@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project
-- _,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;: Alexandre Bergel http://www.bergel.eu ^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.
participants (9)
-
Alexandre Bergel -
Eliot Miranda -
Gabriel Brunstein -
Germán Arduino -
laurent laffont -
Levente Uzonyi -
Mariano Martinez Peck -
Stéphane Ducasse -
Tudor Girba