SqueakDBX November 2009

squeakdbx@lists.squeakfoundation.org

2 participants
2 discussions

MS SQL Server Backend in Windows (working but some problems)
by Stefan Kapusniak 27 Nov '09

27 Nov '09

I worked out what was going on with the MSSQL backend segfaulting on my Vista machine when running the tests. It wasn't as fatal as I thought initially, but it's a pretty serious problem if you want to use it in production code. It turns out if you put in an incorrect (non-existing) host, instead of getting an error either when you connect or when you open the connection, everything seems to work, but it it then all blows up dramatically as soon as you try execute some SQL. The same happens if you supply a username that doesn't exist, or even get your password wrong (ouch!). I guess I'll be poking around the code a bit to try and see what I can come up with for that one :) I also ran the core tests, and got 2 failures on multi-statements, I assume that's the known thing that's in the OpenDBX bug tracker? This is all on Windows Vista, Pharo RC1 (10498), OpenDBX 1.4.4, FreeTDS 0.82, SQL Server Express 2008, both OpenDBX and FreeTDS built from source with ye olde mingw recommended on the OpenDBX site. -- Stefan

2 9

ODBC in Windows
by Mariano Martinez Peck 27 Nov '09

27 Nov '09

Hi Stefan Kapusniak! First of all thanks for all your test and analysis you have been doing related to http://bugs.linuxnetworks.de/index.php?do=details&id=24&area=comments#tabs It is much more than what I could do. Regarding your question of SQL_ASYNC_ENABLE_OF, yes, you are right, it means that the calls are going to block for the duration each query :( However, this is exactly the same case with the native ODBC driver for Squeak, isn't it? Anyway, do you have a reason of using ODBC ? SqueakDBX and OpenDBX should be used with ODBC when you are using an unsupported database, but squeakdbx and opendbx do support mssql. So, why don't you use that instead of ODBC? It would be MUCH better. Sorry, I really don't like ODBC at all hahaha Cheers, Mariano

2 4

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

SqueakDBX November 2009