well. I don't knew thats comments... but i did benchmarks and free tds
works better..
In fact i have 3 system in production and freetds work better.. and
without tipical ADO distributions problems..
You are free to chose which platform to use. :)

besides, When you use ODBC, you must use, ODBC Syntax.. that is little
bit diferent than ANSI, loosing portability

based on that i can say, "Free tds platfom is the better option".

In addition Glorp dont have a ODBCPlatform.. if you chose that
platform you must extend the DatabasePlatform. In fact the right model
, may be  a superclass for ODBC and specifics classes for each DBMS.

Best..

On Tue, May 10, 2011 at 2:04 PM, Alain_Rastoul <alr....@free.fr> wrote:
> just found it:
> http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows/Building_with_MinGW
> see comment on MSSQL Server backend
> "The mssql backend is primarily intended for Unix environments where a
> native client library is not available for the MS SQL Server and FreeTDS
> library provides the only alternative. On Windows platforms, the native
> client is an ODBC driver so it's better to use the odbc backend."
> to be honest, it seems reasonable, ODBC is not bad and the driver in sync
>
> "Alain_Rastoul" <alr....@free.fr> a écrit dans le
> message de news: iqbqj0$hpg$1...@dough.gmane.org...
>> Thanks Mariano and Diogenes for your answers.
>> I can't check your suggestions (env.variables, though I'm quite sure I
>> did, and blob fields) this evening but tomorrow .
>> As I said, I was able to connect with the tsql.exe utility compiled with
>> freetds using sockets, my server has the 2 authentications modes (sql and
>> nt) and is listening on sockets, so I would say freetds seems to be ok.
>> I downloaded the opendbx win 32 binaries from the link on the squeakdbx
>> site and I'm sure I've seen a comment saying that the "prefered backend
>> was odbc" because of native drivers (on this site I think) - but I could
>> not find the link anymore.
>> I'll send it to you when I find it.
>> Thanks again
>> cheers
>> Alain
>>
>>
>> "Alain rastoul" <alr....@free.fr> a écrit dans le
>> message de news:
>> almarsoft.449488083514407...@news.gmane.org...
>> I dowloaded opendbx binaries and freetds sources, mingw, msys and
>> built freetds. I installed opendbx in my pharo1.3 with the gofer
>> script found in docs.
>> Connection to my sql server with the freetds tsql utility was ok, but
>> from pharo I always got «connection failed» then a crash (pharo
>> process exit).
>> I saw in opendbx docs that from a windows client odbc backend is
>> prefered, changed backend of DBXMSSQLPlatform to 'odbc' then
>> connection to my server with a system dsn was ok, but I have «unknow
>> problem with executeStatement» when I execute a «select * from
>> mytable»
>> Is there a better way to proceed with opendbx-mssql?
>> Can I connect without a dsn ?
>>
>> Any advice or comments are welcome.
>>
>> TIA
>> Cheers
>>
>> --
>> Alain_rastoul
>>
>>
>> ------------------------------------------------------------------------------
>> Achieve unprecedented app performance and reliability
>> What every C/C++ and Fortran developer should know.
>> Learn how Intel has extended the reach of its next-generation tools
>> to help boost performance applications - inlcuding clusters.
>> http://p.sf.net/sfu/intel-dev2devmay
>>
>>
>>
>>
>
>
> --------------------------------------------------------------------------------
>
>
>> ------------------------------------------------------------------------------
>> Achieve unprecedented app performance and reliability
>> What every C/C++ and Fortran developer should know.
>> Learn how Intel has extended the reach of its next-generation tools
>> to help boost performance applications - inlcuding clusters.
>> http://p.sf.net/sfu/intel-dev2devmay
>
>
> --------------------------------------------------------------------------------
>
>
>>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Achieve unprecedented app performance and reliability
> What every C/C++ and Fortran developer should know.
> Learn how Intel has extended the reach of its next-generation tools
> to help boost performance applications - inlcuding clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> libopendbx-devel mailing list
> libopendbx-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
> http://www.linuxnetworks.de/doc/index.php/OpenDBX
>
>

------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX

Reply via email to