Re: [opendbx] Mssql connection failed

2011-05-12 Thread Alain rastoul
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

2011-05-12 Thread diogenes . moreira
Hi alain.. If i remeber well obdc work with a cache and open a cursor to obtein the resultser. You can check this with the trace tools of mssql server. A good test may be select with diferent queries, inserts, deletes,updates, etc.. Not repeating the same query. Please would you send to as you

Re: [opendbx] Mssql connection failed

2011-05-12 Thread Alain_Rastoul
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

2011-05-12 Thread Alain_Rastoul
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

2011-05-12 Thread Mariano Martinez Peck
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

2011-05-12 Thread Diogenes Moreira
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