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 sof
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
) [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
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
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
xel [mailto:bergmann@;hi.net]
> Sent: Friday, October 25, 2002 6:57 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PHP and MS-SQL
>
>
> I want to apologize for my ignorance in advance...
> I'm developing PHP code with MySQL on Unix platforms for
> quite a while. Now
>
xel [mailto:bergmann@;hi.net]
> Sent: Friday, October 25, 2002 6:57 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PHP and MS-SQL
>
>
> I want to apologize for my ignorance in advance...
> I'm developing PHP code with MySQL on Unix platforms for
> quite a while. Now
>
AIL PROTECTED] To: [EMAIL PROTECTED]
et> cc:
Subject:
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 sit
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 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
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
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
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
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
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
uck a long delay, unless you SQL server is "overcrowded" with
other huge databases that you use...
George
-Original Message-
From: Michael Kroiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 3:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and MS SQL 2000 Per
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 sugge
18 matches
Mail list logo
