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