Cronk
Cc: PHP Mail
Subject: RE: PHP4 on Windows using MSSQL
Thanks Ollie. I will check Tcp or Named Pipes.
I have found a Linux Journal article dated 14 Feb 2003 using a FreeTDS
driver and ODBC to MSSQL and will try that.
Cheers,
Kevin
On Tue, 2003-02-25 at 23:25, Oliver Cronk wrote:
Yes, but I
[mailto:[EMAIL PROTECTED]
Sent: 25 February 2003 08:05
To: Oliver Cronk
Cc: PHP Mail
Subject: RE: PHP4 on Windows using MSSQL
Thanks Ollie
I guess this means using PHP4 MSSQL functions in Windows and PHP4 Sybase
functions in Linux?
On Tue, 2003-02-25 at 04:47, Oliver Cronk wrote:
The MSSQL module
The MSSQL module for PHP DOES NOT USE ODBC. It uses the C library direct
style of connecting to MSSQL. Use your enterprise manager to configure the
appropriate users and permissions and you should be fine.
Ollie Cronk
www.cronky.net
-Original Message-
From: Kevin Gordon [mailto:[EMAIL
Hi Kras
- Running PHP as the ISAPI module make sure you have the latest version
(you should get the latest version anyway).
Do you have problems with php in ISAPI mode with MSSQL permament
connections?
-- I don't use pconnect with ISAPI but maybe I should thinking about it(!)
so I can't
Obviously the major advantage of using the native MS-SQL extension is
performance (IHMO) maybe if you are running a few small apps then you won't
notice the connection overhead involved in establishing an odbc connection
to MSSQL. I have found the MSSQL extension much faster in testing .
In
Have you tried removing the [] brackets? And what is ReferencesComplete - a
standard table, a view or a stored procedure?
Ollie
-Original Message-
From: Hermann Otteneder [mailto:[EMAIL PROTECTED]]
Sent: 17 April 2002 16:30
To: [EMAIL PROTECTED]
Subject: troubles with select * from...
Hi PHP Is quite cool isn't it As for your problem you might want to try
a few things:
- Running PHP as the ISAPI module make sure you have the latest version
(you should get the latest version anyway).
- Removing this line : $r = mssql_rows_affected ( $link); - as there is a
mysql function
How about this incorporated somewhere:
$s = (SERVER_PROTOCOL == HTTP/1.0) ? Pragma: no-cache : Cache-Control:
no-cache, must-revalidate;
header($s);
This code must be at the start of the script BEFORE anything is output to
the browser - as it sends an additional HTTP header (hence the function
What is the query / code that you are sending to MS-SQL in PHP?
-Original Message-
From: Daniel Ryhle [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2002 21:42
To: [EMAIL PROTECTED]
Subject: MS SQL problem with php
I run MS SQL 2000 on a win 2k machine and IIS5. On this i have installed
.
[end of ms post]
Thanks for any pointers anyone throws up.
Oliver Cronk
p.s. this was found under the thread Re: ntwdblib.dll (Native vs. ODBC
driver) on microsoft.public.sqlserver.odbc over the last couple of days
(and
so should still be there if anyone else wants to look at the entire
Great, simple solution, which I really should have thought if myself
considering I did semaphores, IPC and other process management stuff last
year in my Uni course!
Cheers Everyone, I'll let you know what solution I use in the end (probably
won't know until Easter when my second prototype/ beta
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: 31 January 2002 23:09
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Ensuring users don't overwrite each other (NOT a
newbie question)
Hi there, currently writing an e-CRM system for an intranet using PHP on
Win32 and MS-SQL
- Original Message -
From: Oliver Cronk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Php-Db ML [EMAIL PROTECTED]
Sent: 01 February 2002 15:23
Subject: Re: [PHP-DB] Ensuring users don't overwrite each other (NOT a
newbie question)
Yes thats an interesting idea, and this compare-and-modify
the same logic implemented in two places (fatal when you come to
modify the code/db).
Regards,
=dn
- Original Message -
From: Oliver Cronk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Php-Db ML [EMAIL PROTECTED]
Sent: 01 February 2002 15:23
Subject: Re: [PHP-DB] Ensuring users don't overwrite each
Why not make it a function which also checks and replaces for characters SQL
fails on eg if ' replace with '' in strings etc, and does any sanity /
validation checks at the same time?
Ollie
Rick Emery [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Your problem is that you've
Like this for example:
http://www.phpbuilder.com/snippet/download.php?type=snippetid=378
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2002 16:01
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL values does not work
Why
: [PHP-DB] Inserting NULL values does not work
It's not failing on the single-quotes. MYSQL can use single-quotes.
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:01 AM
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL
might want to consider at the same point.
Ollie
Rick Emery [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
It won't fail if it is enclosed in double-quotes. That is:
INSERT INTO mytable (name) VALUES(O'leary)
is OK.
-Original Message-
From: Oliver Cronk [mailto
logic implemented in two places (fatal when you
come to
modify the code/db).
Regards,
=dn
- Original Message -
From: Oliver Cronk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; Php-Db ML [EMAIL PROTECTED]
Sent: 01 February 2002 15:23
Subject: Re: [PHP-DB] Ensuring users don't
PHP/MS-SQL for a while) or some
example T-SQL if you think thats the solution I should go for.
Thanks very much in advance...
Oliver Cronk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED
see it'll take me a little
longer to learn MSSQL.
Thanks!
william
--
William Fong - [EMAIL PROTECTED]
Phone: 626.968.6424 x210 | Fax: 626.968.6877
Wireless #: 805.490.7732| Wireless E-mail: [EMAIL PROTECTED]
- Original Message -
From: Oliver Cronk [EMAIL PROTECTED
No (not out of the box anyway) BUT the beauty of PHP is its much simpler
than JSP or ASP's server.response() server.request() methods (sorry if thats
not the exact syntax - I haven't done huge amounts of ASP/JSP work lately),
in most cases you simply output the data (i.e. print / echo something;)
Something I have created for a project recently (note that I use my own db
wrapper functions - just substitute the dbconn(), dbquery(), dbnumrows() and
dbresult() for your database functions - e.g. mysql_connect() for mysql,
ms_sql_connect() - look them up in the PHP manual however as I am not
It would appear that I should check if anyone else has answered a question
first! And get some more sleep!
Sorry!
Ollie
-Original Message-
From: olinux [mailto:[EMAIL PROTECTED]]
Sent: 29 January 2002 20:05
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] arrays and email
The other thing
I believe these additional functions are only available in the CVS version
of PHP not the version you can download from the web site.
But I could be wrong (someone correct me!)
Oliver Cronk
-Original Message-
From: Duarte Costa [mailto:[EMAIL PROTECTED]]
Sent: 23 January 2002 15:35
25 matches
Mail list logo