Re: [Pharo-dev] How production ready is Pharo on SQLServer?

Sept. 19, 2014

      yes if things where in markdown friendly wiki and git you'll see a pull request in half a second

I'll think of something

but returning to the dll issue, you mention you endd up using odbc and I see there are two backends to choose from. The odbc and the mssql, so, i'm getting this right? If I use odbc that dll is not needed?

Any reason not to use odbc?

from iPad
...
On 19/09/2014, at 08:05, "Torsten Bergmann" <astares@gmx.de> wrote:
Hi Sebastian,
The DLL's have to be where Pharo VM is or in the subfolder where the other DBX libs are. If in doubt put
it (temporarily) into C:/Windows/System32 as they will be found always then. No need to restart the OS but
you should reopen Pharo VM with image.
You can find the missing DLL here:  http://web.archiveorange.com/archive/v/a1gO5ZoJReyXr6T4n5m7
Fortunately I bookmarked this one after going through the same hazzle.
You have to download "libsybdb-5.xxx" and rename to "libsybdb-5.dll".
I went through all this pain in the past - very time wasting and not what I would call user friendly.
It is really a pity that no one is able to care about setting up a CI to build all the necessary
stuff ...
In the end I used ODBC package as it is easy to load from the config browser and one only has
to setup an ODBC name.
Hope this helps in your OpenDBX adventure...
When successfull maybe you could put a tutorial and all the necessary binaries on a webpage/github/... afterwards.
Dont know how long the archive remembers the thread with the missing DLL.
Thx
T.
Gesendet: Freitag, 19. September 2014 um 12:46 Uhr
Von: "Sebastian Sastre" <sebastian@flowingconcept.com>
An: "Pharo Development List" <pharo-dev@lists.pharo.org>
Betreff: Re: [Pharo-dev] How production ready is Pharo on SQLServer?
Thank you tudor that one loads.
Answering a question about documentation mentions:
Gofer it
   smalltalkhubUser: 'DBXTalk' project: 'Configurations';
   configurationOf 'OpenDBXDriver'; loadStable.
Which is consistent with the next step about the connectionSettings preparing to run the tests.
What I've experienced is that you need to
1. copy all .dll's to the pharo dir
2. set that in the windows path (reboot/relogon required)
3. try connecting
Minor issue: The tests assumes that you have a postgres backend so it will complain about you not having it installed (unless you do)
Changing th ecode to use MSSQL leads to the apparently known issue of Windows complaining about 
libsybdb-5.dll
More info here:
http://lists.squeakfoundation.org/pipermail/squeakdbx/2011-March/000337.html
As soon as you evaluate connect, you see that problem
| conn connectionSettings |
connectionSettings := (DBXConnectionSettings
host: 'localhost'
port: '1433'
database: 'dbxtest'
userName: 'sa'
userPassword: '123').
conn := DBXConnection platform: DBXMSSQLBackend new settings: connectionSettings.
conn connect.
conn open.
I have to continue later but I don't have clear yet where or who is suposed to install libsybdb-5.dll
any help appreciated
and thanks for the helpful tips in your replies
seb
o/
------------------------------------------------------------
De: "Tudor Girba" <tudor@tudorgirba.com>
Para: "Pharo Development List" <pharo-dev@lists.pharo.org>
Enviadas: Sexta-feira, 19 de setembro de 2014 4:35:31
Assunto: Re: [Pharo-dev] How production ready is Pharo on SQLServer?
Here is how to load and install DBXTalk in Pharo 3.0:
Gofer new
     smalltalkhubUser: 'DBXTalk' project: 'DBXTalkDriver';
     package: 'ConfigurationOfOpenDBXDriver';
     load.
     #ConfigurationOfOpenDBXDriver asClass loadBleedingEdge.
  #NBPharoOpenDBX asClass installAsCurrent.
Cheers,
Doru
On Fri, Sep 19, 2014 at 8:45 AM, Esteban Lorenzano <estebanlm@gmail.com[estebanlm@gmail.com]> wrote:yeahâ¦ I told you that dbxtalk site information is outdated (and never find the time to update)
you need to look here:
http://smalltalkhub.com/#!/~DBXTalk/Configurations[http://smalltalkhub.com/#!/~DBXTalk/Configurations]
(or in the configuration browser)
cheers,
Esteban
...
On 19 Sep 2014, at 08:00, Stephan Eggermont <stephan@stack.nl[stephan@stack.nl]> wrote:
Sebastian, that doesn't look like the correct one
DBXTalk is on smalltalkhub
https://ci.inria.fr/dbxtalk/[https://ci.inria.fr/dbxtalk/]
Stephan
--
www.tudorgirba.com[http://www.tudorgirba.com]
"Every thing has its own flow"