RE: [PHP-DB] PHP to MS SQL Package

2008-06-13 Thread Wei, Alice J.
To: Wei, Alice J. Cc: Olavi ivask; php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package That error message tells you that you are getting closer. Next step would be to make sure you have a connection to that system: $ ping 192.168.10.128 Next thing I would do is see if that port is open

Re: [PHP-DB] PHP to MS SQL Package

2008-06-13 Thread Dee Ayy
http://php.he.net/manual/en/mssql.installation.php Installation The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini. To get these functions to work, you have to compile PHP with --with-mssql[=DIR], where DIR is the FreeTDS install prefix. And FreeTDS should be compiled

[PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Olavi ivask
Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] You actually meant

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Ken Keefe
Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have to compile php or freetds as there are packages available to do what you want... Ken On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I am currently using a Linux box

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:44 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Olavi ivask
of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Ken Keefe
] wrote: From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:44 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Alice, make sure the php-mssql package is installed. # yum install php-mssql You

RE: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Wei, Alice J.
2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB] PHP to MS SQL Package Hello, Here is a good article about ms-sql PHP on Linux (http://www.devarticles.com/index2.php?option=contenttask=viewid=667pop=1page=0hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei

Re: [PHP-DB] PHP to MS SQL Package

2008-06-12 Thread Ken Keefe
2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL

[PHP-DB] PHP and MS SQL Server 7.0

2003-03-04 Thread Michael Morrison
I would like to use PHP to open a connection to a MS SQL server, query the database, and then use the query results to generate dynamic content for a mass HTML e-mail campaign. Is it possible to execute PHP scripts in an HTML file or must the file have a .php extension? I'm limited by the

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 info

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

2002-10-26 Thread Frank M. Kromann
-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 sure what everyone will tell you, but this is what I did. I used

[PHP-DB] PHP and MS-SQL

2002-10-25 Thread Axel
I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously

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

2002-10-25 Thread Jeffrey_N_Dyke
] To: [EMAIL PROTECTED] et cc: Subject: [PHP-DB] PHP and MS-SQL

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 install

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-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 Am Mon, 19 Nov 2001 schrieb

[PHP-DB] PHP and MS SQL 2000 Performance

2001-11-19 Thread Michael Kroiss
We're running W2K, IIS 5, PHP 4, and SQL Server 2000 and performance seems to be really slow. We're using a simple connect PHP script to query a table that has only 1 record in it, and it takes approximately 20 seconds to load. This seems to be very slow. Is this normal or does anyone have

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?

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

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

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