Re: [opendbx] Mssql connection failed

Hi all I'm not a fan of ODBC, but with Windows and MSSQL at least it rocks (avoid any ODBC specific syntax commands), on the other side having access to SQL Server from Unix is really a plus and I would'nt dismiss FREETDS on the contrary - I don't know about ODBC on Linux. Just some details

Re: [opendbx] Mssql connection failed

Hi, I finally got openDbx working with FreeTDS and ODBC, I don't know what went wrong last night, I suppose my computer got tired ;) This is great ! However, I found - a much better performance with ODBC backend (DBXOdbcPlatform) in the test I did than with Freetds (DBXMSSQLPlatform) (run the

Re: [opendbx] Mssql connection failed

@lists.sourceforge.net Reply-To: OpenDBX devel list libopendbx-devel@lists.sourceforge.net Subject: Re: [opendbx] Mssql connection failed Hi, I finally got openDbx working with FreeTDS and ODBC, I don't know what went wrong last night, I suppose my computer got tired ;) This is great ! However, I found - a much

Re: [opendbx] Mssql connection failed

Hi Diogenes, You are right about cursors in odbc (client or server cursors), but they are controlled by the application and here there is no cursor. I had a look at the ODBC log trace there was no cursor option positioning either ( SQLSetStmtAttr ). My server is 2005 SP2+ security fix

Re: [opendbx] Mssql connection failed

Hi Mariano, Thanks for the pointers, I'll have a look at those links and tests. I think there are lot of developpers using windows and MS technology and that it would be nice to document a litle bit more this configuration specifically - I remember several posts on squeaks mailing lists about

Re: [opendbx] Mssql connection failed

On Thu, May 12, 2011 at 10:24 PM, Alain_Rastoul alr@free.fr wrote: Hi Mariano, Thanks for the pointers, I'll have a look at those links and tests. I think there are lot of developpers using windows and MS technology and that it would be nice to document a litle bit more this

Re: [opendbx] Mssql connection failed

Alain,, don't get my wrong. Im searching for perfomance and good configuration too.. i have severals limitations in english, and that makes me wrong. thank for share our experience, all learn to these mails. Saludos On Thu, May 12, 2011 at 4:55 PM, Alain_Rastoul alr@free.fr wrote: Hi

Re: [opendbx] Mssql connection failed

Hi Diogenes, Alain 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

Re: [opendbx] Mssql connection failed

Hi... Well the better way to connect to MSSql from pharo is with freetds platform. Not via ODBC. You need check a couple things: 1: all dll's are on the path. 2: freetds.conf is on. 3: the sql server accept tcp conexion, not name pipes or shared memory. 4: the enviroments variables are right

Re: [opendbx] Mssql connection failed

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

Re: [opendbx] Mssql connection failed

I'm willing to be conviced by freetds. :) 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