How to connect to DB2

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

How to connect to DB2

Andrei Stebakov
Looks like ODBC is broken in Pharo 6.1. 
What's the best way to get access to DB2 in Pharo?


Reply | Threaded
Open this post in threaded view
|

Re: How to connect to DB2

Stephane Ducasse-3
Hi andrei

First welcome to this list.
Second can you explain to us what is the experience that you did so
that you can state that ODBC is broken in Pharo 6.1?

Stef

On Thu, Dec 21, 2017 at 11:48 PM, Andrei Stebakov <[hidden email]> wrote:
> Looks like ODBC is broken in Pharo 6.1.
> What's the best way to get access to DB2 in Pharo?
>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to connect to DB2

Andrei Stebakov
Hi Stef

Gofer new
  squeaksource: 'ODBC';
  package: 'ConfigurationOfODBC'; load.
  (Smalltalk at: #ConfigurationOfODBC) load.

When I execute the code above I got an exception doesNotUnderstand: #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope variable is not defined.
Also if I install ODBC from the catalog it also fails.

Andrei


On Fri, Dec 22, 2017 at 2:19 AM, Stephane Ducasse <[hidden email]> wrote:
Hi andrei

First welcome to this list.
Second can you explain to us what is the experience that you did so
that you can state that ODBC is broken in Pharo 6.1?

Stef

On Thu, Dec 21, 2017 at 11:48 PM, Andrei Stebakov <[hidden email]> wrote:
> Looks like ODBC is broken in Pharo 6.1.
> What's the best way to get access to DB2 in Pharo?
>
>


Reply | Threaded
Open this post in threaded view
|

Re: How to connect to DB2

Stephane Ducasse-3
Hi andrei

I do not know the status of OBDC but you should know that code on
squeaksource is in general quite old.
Have a look at Garage which is a kind of JBDC.

https://github.com/pharo-rdbms/garage

You should probably have a version available via the catalog

Stef

On Fri, Dec 22, 2017 at 2:43 PM, Andrei Stebakov <[hidden email]> wrote:

> Hi Stef
>
> Gofer new
>   squeaksource: 'ODBC';
>   package: 'ConfigurationOfODBC'; load.
>   (Smalltalk at: #ConfigurationOfODBC) load.
>
> When I execute the code above I got an exception doesNotUnderstand:
> #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope
> variable is not defined.
> Also if I install ODBC from the catalog it also fails.
>
> Andrei
>
>
> On Fri, Dec 22, 2017 at 2:19 AM, Stephane Ducasse <[hidden email]>
> wrote:
>>
>> Hi andrei
>>
>> First welcome to this list.
>> Second can you explain to us what is the experience that you did so
>> that you can state that ODBC is broken in Pharo 6.1?
>>
>> Stef
>>
>> On Thu, Dec 21, 2017 at 11:48 PM, Andrei Stebakov <[hidden email]>
>> wrote:
>> > Looks like ODBC is broken in Pharo 6.1.
>> > What's the best way to get access to DB2 in Pharo?
>> >
>> >
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to connect to DB2

Andrei Stebakov
Hi Stef

I already checked Garage, it doesn't have support for DB2. It used to have support for odbc, but now it's deprecated.

Andrei

On Dec 22, 2017 15:11, "Stephane Ducasse" <[hidden email]> wrote:
Hi andrei

I do not know the status of OBDC but you should know that code on
squeaksource is in general quite old.
Have a look at Garage which is a kind of JBDC.

https://github.com/pharo-rdbms/garage

You should probably have a version available via the catalog

Stef

On Fri, Dec 22, 2017 at 2:43 PM, Andrei Stebakov <[hidden email]> wrote:
> Hi Stef
>
> Gofer new
>   squeaksource: 'ODBC';
>   package: 'ConfigurationOfODBC'; load.
>   (Smalltalk at: #ConfigurationOfODBC) load.
>
> When I execute the code above I got an exception doesNotUnderstand:
> #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope
> variable is not defined.
> Also if I install ODBC from the catalog it also fails.
>
> Andrei
>
>
> On Fri, Dec 22, 2017 at 2:19 AM, Stephane Ducasse <[hidden email]>
> wrote:
>>
>> Hi andrei
>>
>> First welcome to this list.
>> Second can you explain to us what is the experience that you did so
>> that you can state that ODBC is broken in Pharo 6.1?
>>
>> Stef
>>
>> On Thu, Dec 21, 2017 at 11:48 PM, Andrei Stebakov <[hidden email]>
>> wrote:
>> > Looks like ODBC is broken in Pharo 6.1.
>> > What's the best way to get access to DB2 in Pharo?
>> >
>> >
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to connect to DB2

Thomas Sattler
I have no problem using Garage to connect to Postgres.  Don't know if it will work with DB2, but since it's ODBC, it should.

On Fri, Dec 22, 2017 at 6:36 PM, Andrei Stebakov <[hidden email]> wrote:
Hi Stef

I already checked Garage, it doesn't have support for DB2. It used to have support for odbc, but now it's deprecated.

Andrei

On Dec 22, 2017 15:11, "Stephane Ducasse" <[hidden email]> wrote:
Hi andrei

I do not know the status of OBDC but you should know that code on
squeaksource is in general quite old.
Have a look at Garage which is a kind of JBDC.

https://github.com/pharo-rdbms/garage

You should probably have a version available via the catalog

Stef

On Fri, Dec 22, 2017 at 2:43 PM, Andrei Stebakov <[hidden email]> wrote:
> Hi Stef
>
> Gofer new
>   squeaksource: 'ODBC';
>   package: 'ConfigurationOfODBC'; load.
>   (Smalltalk at: #ConfigurationOfODBC) load.
>
> When I execute the code above I got an exception doesNotUnderstand:
> #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope
> variable is not defined.
> Also if I install ODBC from the catalog it also fails.
>
> Andrei
>
>
> On Fri, Dec 22, 2017 at 2:19 AM, Stephane Ducasse <[hidden email]>
> wrote:
>>
>> Hi andrei
>>
>> First welcome to this list.
>> Second can you explain to us what is the experience that you did so
>> that you can state that ODBC is broken in Pharo 6.1?
>>
>> Stef
>>
>> On Thu, Dec 21, 2017 at 11:48 PM, Andrei Stebakov <[hidden email]>
>> wrote:
>> > Looks like ODBC is broken in Pharo 6.1.
>> > What's the best way to get access to DB2 in Pharo?
>> >
>> >
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: How to connect to DB2

Andrei Stebakov
Thank you for the answers! I thought ODBC was deprecated from Garage, I'll give it another look.

On Fri, Dec 22, 2017 at 10:53 PM, Thomas Sattler <[hidden email]> wrote:
I have no problem using Garage to connect to Postgres.  Don't know if it will work with DB2, but since it's ODBC, it should.

On Fri, Dec 22, 2017 at 6:36 PM, Andrei Stebakov <[hidden email]> wrote:
Hi Stef

I already checked Garage, it doesn't have support for DB2. It used to have support for odbc, but now it's deprecated.

Andrei

On Dec 22, 2017 15:11, "Stephane Ducasse" <[hidden email]> wrote:
Hi andrei

I do not know the status of OBDC but you should know that code on
squeaksource is in general quite old.
Have a look at Garage which is a kind of JBDC.

https://github.com/pharo-rdbms/garage

You should probably have a version available via the catalog

Stef

On Fri, Dec 22, 2017 at 2:43 PM, Andrei Stebakov <[hidden email]> wrote:
> Hi Stef
>
> Gofer new
>   squeaksource: 'ODBC';
>   package: 'ConfigurationOfODBC'; load.
>   (Smalltalk at: #ConfigurationOfODBC) load.
>
> When I execute the code above I got an exception doesNotUnderstand:
> #selector in RBParser>>externalFunctionDeclaration. Looks like currentScope
> variable is not defined.
> Also if I install ODBC from the catalog it also fails.
>
> Andrei
>
>
> On Fri, Dec 22, 2017 at 2:19 AM, Stephane Ducasse <[hidden email]>
> wrote:
>>
>> Hi andrei
>>
>> First welcome to this list.
>> Second can you explain to us what is the experience that you did so
>> that you can state that ODBC is broken in Pharo 6.1?
>>
>> Stef
>>
>> On Thu, Dec 21, 2017 at 11:48 PM, Andrei Stebakov <[hidden email]>
>> wrote:
>> > Looks like ODBC is broken in Pharo 6.1.
>> > What's the best way to get access to DB2 in Pharo?
>> >
>> >
>>
>