[SqueakDBX] Installing on Windows with MSSql backend was Re: [Esug-list] [ANN] ESUG supports once again SqueakDBX

Fri Apr 8 14:23:48 UTC 2011

1. Yes. I'm using in SQLServerPlatform in Production.. and work fine...
mmm.. well.. as SQL Server works :). btw SQLServerPlatform is the platform
to MSSQL 2000 or superior, if you use older version, you must use
SybasePlatform.

2. Glorp version (the root version, not DBTalk Version), can be imported in
Gemstone, but play attention in the states of cache, because Glorp is based
on transient condition of Session Object.. you can use NonCachePolicy..

Best Regard

On Fri, Apr 8, 2011 at 11:06 AM, Esteban Lorenzano <estebanlm at gmail.com>wrote:

> Hi,
>
> El 08/04/2011, a las 11:01a.m., Miguel Sanchez escribió:
>
> > Hi,
> >
> > OK after a few weeks hiatus I've managed to get all the SqueakDBX
> > tests to pass (ok two are still failing but they don't look like a big
> > deal. ) Yayyyyyyy! It helped using the right backend. I've all but
> > given up compiling openDBX. If I have time I'll go back to it for
> > completeness. I'll suggest some changes to the windows specific
> > documentation, or make them myself. How do you want to proceed?
> >
> > Soooooo now I have two questions that have occured to me.
> > 1. Is SqueakDBX ported to GemStone? (I'm guessing not)..
>
> not yet... now with the new FFI support it becomes possible, but it is not
> in our current "agenda" (maybe next year, I dunno)
>
> > 2. Is there a MsSQLPlatform on GLORP or does the SQLServerPlatform
> > integration work. (GLORP documentation makes reference to *rumours* of
> > SQLServer integration working.) Basically what is the state of the
> > GLORP/SqueakDBX rearchitecture work looking in order to use SueakDBX
> > backend?
>
> you should be able to use it GlorpDBX with SQLServer, maybe it will need
> some tweaks, but Diogenes made it work, as I remember...
>
>
> >
> > Best Regards,
> >
> >
> > Miguel
> >
> > On 23 March 2011 23:41, Mariano Martinez Peck <marianopeck at gmail.com>
> wrote:
> >>
> >>
> >> On Wed, Mar 23, 2011 at 11:39 PM, Miguel Sanchez <
> mikey.sanchez at gmail.com>
> >> wrote:
> >>>
> >>> So it's a feature and not a bug.... ;-)
> >>>
> >>
> >> heheheheh
> >>
> >>>
> >>> I've got some stuff on compiling freeTDS and if I ever manage to
> >>> compile openDBX I'll put together a howto.
> >>>
> >>
> >> Ok. We can then integrate them where they should go:
> >> http://www.squeakdbx.org/Compiling%20for%20different%20backends
> >>
> >>>
> >>> On 23 March 2011 23:34, Mariano Martinez Peck <marianopeck at gmail.com>
> >>> wrote:
> >>>> ehehehhehe  Pharo > 1.1  is broken with this...this is a known bug
> >>>> (check
> >>>> Pharo issue tracker)
> >>>> But don't worry, just evaluate: DBXPlatform
> >>>> disableAutomaticConnectionReleaseOnGC  and that's all. It is safe,
> don't
> >>>> worry.
> >>>>
> >>>> BTW...if you have something to improve our documentation in the
> website,
> >>>> please let us know.
> >>>>
> >>>> Cheers
> >>>>
> >>>> Mariano
> >>>>
> >>>> On Wed, Mar 23, 2011 at 11:29 PM, Miguel Sanchez
> >>>> <mikey.sanchez at gmail.com>
> >>>> wrote:
> >>>>>
> >>>>> OK so after struggling to build openDBX (that one is ongoing), on
> your
> >>>>> instruction I switched to using DBXOdbcPlatform and .........
> SUCCESS!
> >>>>>
> >>>>> Well ok partial success. I managed to open the connection and while
> >>>>> investigating the resultset of a select I started getting an error.
> In
> >>>>> DBXConnection>>connect
> >>>>> On the line
> >>>>>        self platform class isAutomaticConnectionReleaseOnGC ifTrue: [
> >>>>>                SqueakDBXSmalltalkDialect current
> >>>>> addObjectToGarbageCollect: self].
> >>>>> /*during addObjectToGarbageCollect:*/
> >>>>> I get the error: "Error: There is no free space in this set."
> >>>>>
> >>>>> Do I need to force a garbage collect?
> >>>>>
> >>>>> Best Regards,
> >>>>>
> >>>>>
> >>>>> Miguel
> >>>>>
> >>>>>
> >>>>> On 15 March 2011 18:22, Miguel Sanchez <mikey.sanchez at gmail.com>
> wrote:
> >>>>>> OK so I've had no luck getting to the bottom of the problem so far.
> I
> >>>>>> still get thrown into  "DBXRecovereableError: RECOVERABLE OpenDBX:
> >>>>>> Connecting to server failed" when calling DBXConnection>>open.
> >>>>>>
> >>>>>> I can connect with the Windows command-line tsql equivalent
> >>>>>> (sqlcmd.exe) so the DB  user and permissions are correct.
> >>>>>>
> >>>>>>
> >>>>>> I said I was going to try and build from sources instead of the
> >>>>>> precompiled binaries.
> >>>>>        self platform class isAutomaticConnectionReleaseOnGC ifTrue: [
> >>>>>                SqueakDBXSmalltalkDialect current
> >>>>> addObjectToGarbageCollect: self].>
> >>>>> I've downloaded and installed (finally) MinGW. I've (finally!)
> >>>>>> downloaded sources of opendbx 1.4.5 and freetds-0.8.2.
> >>>>>>
> >>>>>> freetds built fine and put the headers in an accessible place. but
> >>>>>> now
> >>>>>> when I try to configure opendbx I get the following:
> >>>>>>
> >>>>>> checking for style of include used by make... GNU
> >>>>>> checking for gcc... gcc
> >>>>>> checking whether the C compiler works... no
> >>>>>> configure: error: in `/opendbx-1.4.5':
> >>>>>> configure: error: C compiler cannot create executables
> >>>>>> See `config.log' for more details.
> >>>>>>
> >>>>>> config.log says the following:
> >>>>>>
> >>>>>> ===============================================
> >>>>>> <snip>
> >>>>>> configure:3972: gcc -qversion >&5
> >>>>>> gcc.exe: unrecognized option '-qversion'
> >>>>>> gcc.exe: no input files
> >>>>>> configure:3983: $? = 1
> >>>>>> configure:4003: checking whether the C compiler works
> >>>>>> configure:4025: gcc  /local/include  conftest.c  >&5
> >>>>>>
> c:/mingw/bin/../lib/gcc/mingw32/4.5.2/../../../../mingw32/bin/ld.exe:
> >>>>>> cannot fin
> >>>>>> d C:/MinGW/msys/1.0/local/include: Permission denied^M
> >>>>>> collect2: ld returned 1 exit status^M
> >>>>>> configure:4029: $? = 1
> >>>>>> configure:4067: result: no
> >>>>>> configure: failed program was:
> >>>>>> | /* confdefs.h */
> >>>>>> <snip>
> >>>>>> ======================================
> >>>>>>
> >>>>>> The directory C:/MinGW/msys/1.0/local/include exists and is writable
> >>>>>> by
> >>>>>> me.
> >>>>>>
> >>>>>> Right now it feels like I'm trying to solve the problem of building
> >>>>>> opendbx without knowing if it's getting me any closer to getting
> >>>>>> squeakDBX working.
> >>>>>>
> >>>>>> Any help would be appreciated.
> >>>>>>
> >>>>>> Miguel
> >>>>>>
> >>>>
> >>>>
> >>
> >>
> > _______________________________________________
> > SqueakDBX mailing list
> > SqueakDBX at lists.squeakfoundation.org
> > http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>
> _______________________________________________
> SqueakDBX mailing list
> SqueakDBX at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110408/200e8ba6/attachment.htm