RE: [PHP-DB] PHP and MS-SQL

2002-10-28 Thread Axel Bergmann
Thanks Frank! -Original Message- From: Frank M. Kromann [mailto:frank@;kromann.info] Sent: Sunday, October 27, 2002 4:22 AM To: Axel Bergmann; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more

Re: [PHP-DB] PHP and MS-SQL

2002-10-26 Thread Andrew Hill
) [mailto:John.Negretti@;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server usi

RE: [PHP-DB] PHP and MS-SQL

2002-10-26 Thread Frank M. Kromann
Thanks, > Axel > > -Original Message- > From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] > Sent: Friday, October 25, 2002 3:14 PM > To: Axel; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] PHP and MS-SQL > > Axel, > > Well, I'm not

RE: [PHP-DB] PHP and MS-SQL

2002-10-25 Thread Axel Bergmann
Great, thanks a bunch! -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke@;Keane.com] Sent: Friday, October 25, 2002 3:11 PM To: Axel Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and MS-SQL yes this works. if your code is going to remian on Unix you'll have to in

RE: [PHP-DB] PHP and MS-SQL

2002-10-25 Thread Axel Bergmann
Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti@;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP

RE: [PHP-DB] PHP and MS-SQL

2002-10-25 Thread Negretti, John (CCI-San Diego)
Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used "MyODBC" (on windows) to connect to SQL Server using the built-in "odbc_***()" PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL

Re: [PHP-DB] PHP and MS-SQL

2002-10-25 Thread Jeffrey_N_Dyke
yes this works. if your code is going to remian on Unix you'll have to install freetds (www.freetds.org). there are instructions on www.php.net/mssql for install in the comments... when you get to the site(freetds.org) I know it says Sysbase..but it is what you're looking for. hope this hel

RE: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-20 Thread Andrew Hill
Universal Data Access & Data Integration Technology Providers > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 19, 2001 3:11 PM > To: John Lim; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] PHP and MS SQL 2000 Performance > &

Re: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-20 Thread rhelms
Am Mon, 19 Nov 2001 schrieb John Lim: > Are you using ODBC? We recently had similar problems, and it turned out that > we > had SQL tracing enabled, and every single ODBC function call was being > written > to SQL.LOG And added, such a traced logfile can grow up to some megabyte of data. I know

Re: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread Michael Kroiss
I'm using the php_mssql.dll extension/connection. "John Lim" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being wri

Re: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread Michael Kroiss
First, are you using the mssql.dll to connect or ODBC? Using mssql.dll Second, are you running PHP as a cgi or ISAPI plug-in? As a CGI under the "Home Directory" tab Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Performance from t

Re: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread John Lim
Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG, slowing things down, so a simple query took 7 minutes. Joshua Hoover <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">n

Re: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread Joshua Hoover
I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Thir

Re: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread Michael Kroiss
We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. "Gadam" <[EMAIL PROTECTED]> wrote in messa

RE: [PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread gadam
MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a