RE: MS SQL Server
I found FreeTDS and DBD::Sybase to be the best for me rather than the SQL Server with unixODBC setup which is difficult to setup, buggy and speed issues for me. As for the nonsense about Windows vs. Linux, it's about the best technology for the job. Sometimes people have two products they want to connect; let's not be lame about it. ~Ben -Original Message- From: Matt Sergeant [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 9:32 AM To: FARRINGTON, RYAN Cc: 'Andy Wardley'; [EMAIL PROTECTED] Subject: RE: MS SQL Server On Wed, 18 Jun 2003, FARRINGTON, RYAN wrote: omg... linux people using MS SQL servers? shame on you... =) I hold in one hand the option of taking a pager home with me. In the other hand is using MS SQL Server and giving support over to our 24/7 DBAs. Which would you choose? -- !-- Matt -- :-get a SMart net/:- Spam trap - do not mail: [EMAIL PROTECTED]
RE: MS SQL Server
I was making a joke... I'm the last person to knock on either platform considering I manage both =( every platform has it's purpose =) -Original Message- From: Davis, Benjamin [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 8:30 PM To: '[EMAIL PROTECTED]' Subject: RE: MS SQL Server I found FreeTDS and DBD::Sybase to be the best for me rather than the SQL Server with unixODBC setup which is difficult to setup, buggy and speed issues for me. As for the nonsense about Windows vs. Linux, it's about the best technology for the job. Sometimes people have two products they want to connect; let's not be lame about it. ~Ben -Original Message- From: Matt Sergeant [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 9:32 AM To: FARRINGTON, RYAN Cc: 'Andy Wardley'; [EMAIL PROTECTED] Subject: RE: MS SQL Server On Wed, 18 Jun 2003, FARRINGTON, RYAN wrote: omg... linux people using MS SQL servers? shame on you... =) I hold in one hand the option of taking a pager home with me. In the other hand is using MS SQL Server and giving support over to our 24/7 DBAs. Which would you choose? -- !-- Matt -- :-get a SMart net/:- Spam trap - do not mail: [EMAIL PROTECTED]
Re: MS SQL Server
Matt Sergeant wrote: Anyone got any experience of doing MS SQL Server from mod_perl on Linux (via the FreeTDS drivers)? Not under mod_perl, but I think the experience is still relevant. Any gotchas I should be aware of? I have a very high performance requirements application (millions of hits/day) and I need to know the architecture can cope with it (the alternative being PostgreSQL). Sorry if I mention obvious things, but I know of: 1) lack of placeholders support with DBD::Sybase + Freetds layer. I used freetds 0.53, but 0.61 had the same problem for me. 2) I wasn't able to use sql transactions in the same way I normally do with postgresql/db2/informix/sybase/... This could be due to my fault, SQL server version (?), or other problems I couldn't track down. -- Cosimo
Re: MS SQL Server
On Wed, 18 Jun 2003, Cosimo Streppone wrote: Any gotchas I should be aware of? I have a very high performance requirements application (millions of hits/day) and I need to know the architecture can cope with it (the alternative being PostgreSQL). Sorry if I mention obvious things, but I know of: 1) lack of placeholders support with DBD::Sybase + Freetds layer. I used freetds 0.53, but 0.61 had the same problem for me. Ah, that explains why people are using unixODBC with the TDS driver instead. I assume that supports placeholders (?). Sounds like a bit of a showstopper to me! 2) I wasn't able to use sql transactions in the same way I normally do with postgresql/db2/informix/sybase/... This could be due to my fault, SQL server version (?), or other problems I couldn't track down. Any chance you can expand on that? I use transactions in the application heavily (it has been developed on PostgreSQL), and had feared this might be an area of contention. -- !-- Matt -- :-get a SMart net/:- Spam trap - do not mail: [EMAIL PROTECTED]
Re: MS SQL Server
Matt Sergeant wrote: Anyone got any experience of doing MS SQL Server from mod_perl on Linux (via the FreeTDS drivers)? Only a little, but I know that Simon Matthews ([EMAIL PROTECTED]) has done a lot. ISTR he switched from Postgres to SQL Server (from mod_perl front end, via FreeTDS) and hasn't looked back. He has nothing but good things to say about SQL Server, and from the limited exposure that I'm getting to it now, I'd be inclined to agree. A
RE: MS SQL Server
Title: RE: MS SQL Server omg... linux people using MS SQL servers? shame on you... =) -Original Message- From: Andy Wardley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 18, 2003 10:15 AM To: Matt Sergeant Cc: [EMAIL PROTECTED] Subject: Re: MS SQL Server Matt Sergeant wrote: Anyone got any experience of doing MS SQL Server from mod_perl on Linux (via the FreeTDS drivers)? Only a little, but I know that Simon Matthews ([EMAIL PROTECTED]) has done a lot. ISTR he switched from Postgres to SQL Server (from mod_perl front end, via FreeTDS) and hasn't looked back. He has nothing but good things to say about SQL Server, and from the limited exposure that I'm getting to it now, I'd be inclined to agree. A
RE: MS SQL Server [x-adr]
Title: RE: MS SQL Server [x-adr] Matt Sergeant wrote: On Wed, 18 Jun 2003, Cosimo Streppone wrote: 1) lack of placeholders support with DBD::Sybase + Freetds layer. I used freetds 0.53, but 0.61 had the same problem for me. Ah, that explains why people are using unixODBC with the TDS driver instead. I assume that supports placeholders (?). Yep. 0.61 has support for placeholders and odbc call sytax. There are a couple syntax issues which are resolved in CVS. But if you check the mailing list archives you should be able to get things working. -- Garrett Goebel IS Development Specialist ScriptPro Direct: 913.403.5261 5828 Reeds Road Main: 913.384.1008 Mission, KS 66202 Fax: 913.384.2180 www.scriptpro.com garrett at scriptpro dot com
RE: MS SQL Server
On Wed, 18 Jun 2003, FARRINGTON, RYAN wrote: omg... linux people using MS SQL servers? shame on you... =) I hold in one hand the option of taking a pager home with me. In the other hand is using MS SQL Server and giving support over to our 24/7 DBAs. Which would you choose? -- !-- Matt -- :-get a SMart net/:- Spam trap - do not mail: [EMAIL PROTECTED]
