online, (I
am not sure what year it was published), my PHP could no longer wrong. But, I
will give it a shot.
Alice
-Original Message-
From: Eric [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 3:32 AM
To: PHP-WINDOWS; Wei, Alice J.
Subject: Re: [PHP-WIN] MSSQL and ODBC Connection
Sent: Wednesday, June 18, 2008 6:55 PM
To: Wei, Alice J.; Zephaniah ha Levi; php-windows@lists.php.net
Subject: Re: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows
Hi,
Could you able detail the errors ?
I am prefer a method that seperate the connection steps as
1.) Could you able connectio
Alice
==
Alice Wei
MIS 2009
School of Library and Information Science
Indiana University Bloomington
[EMAIL PROTECTED]
From: Zephaniah ha Levi [EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 10:53 AM
To:
I would recommend using PDO for MSSQL, because it performs better in most.
You have to enable both php_pdo.dll and php_pdo_mssql.dll in your php.ini,
restart the web server and you should be ready to go.
Here's a sample code taken from http://de.php.net/manual/en/ref.pdo-dblib.php
[CODE]
getMess
the mssql extension is
loaded in your php.ini.
-Original Message-
From: Wei, Alice J. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 10:45 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] MSSQL and ODBC Connections with PHP on Windows
Hi,
I am a newbie using the combinatio
Hi,
I am a newbie using the combination of PHP and MSSQL together.
Can anyone tell me which method it might be better as far as using PHP on
Windows with MSSQL database on a single machine? (The PHP and MSSQL database
are not set up remotely on two different servers.
I have set up bot
EMAIL PROTECTED]
Sent: Tuesday, January 22, 2008 3:25 PM
To: Leticia Larrosa
Cc: php-windows@lists.php.net
Subject: Re: [PHP-WIN] mssql and latin characters
Hi Leticia,
MS SQL server comes with a set of client tools that allows you to specify
the encoding. There is a checkbox in the Client Network Tool
Hi Leticia,
MS SQL server comes with a set of client tools that allows you to specify
the encoding. There is a checkbox in the Client Network Tool that allows
you to enable/disable OEM character conversion. Flipping that for the alias
you are using to connect to the database should fix the problem
Hello
I have a MSSql 2000 database that have stored data with the follow special
characters: ó, í, Ñ, á, é, ú.
When I see the data through any MsSql Client I see exactly those characters.
The Collation of database is: SQL_Latin1_General_CP1_CI_AS
I cant change the method of insert data in datab
Alf Stockton wrote:
Frank M. Kromann wrote:
This sounds like your MSSQL connections are getting mixed up.
If the two databases are on the same server and the same sql login has
access to both databases you can query everything from a single
conenction.
You just have to qualify the tables/proce
Frank M. Kromann wrote:
This sounds like your MSSQL connections are getting mixed up.
If the two databases are on the same server and the same sql login has
access to both databases you can query everything from a single conenction.
You just have to qualify the tables/procedures with ..table
to
This sounds like your MSSQL connections are getting mixed up.
If the two databases are on the same server and the same sql login has
access to both databases you can query everything from a single conenction.
You just have to qualify the tables/procedures with ..table
to the server knows where to
I have a php script where I need to access tables in two different MSSQL
databases.
The scenario is . access 1st database to retrieve data that will be
used when calling a StoredProcedure within the 2nd database which will
return data with which one can access the 1st database to retrieve mo
I recently wrote a simple web script to execute a few queries against an
old MS SQL 6.5 server. I developed the script on my XP box running IIS5
any user can run the script with out a problem. However when I moved it
to the production box running IIS6 domain admins can run the script
anyone else ge
mailto:[EMAIL PROTECTED]
> Skickat: den 15 november 2005 17:23
> Till: Joakim Ling
> Kopia: php windows; Robert Twitty
> Ämne: Re: SV: [PHP-WIN] mssql tcp
>
> Hi Jocke,
>
> Well I work with PHP and MSSQL and I know a bit about the broblems too.
> The library used to build
o CGI?
>
> // jocke
>
>
> -Ursprungligt meddelande-
> Från: Frank M. Kromann [mailto:[EMAIL PROTECTED]
> Skickat: den 15 november 2005 17:23
> Till: Joakim Ling
> Kopia: php windows; Robert Twitty
> Ämne: Re: SV: [PHP-WIN] mssql tcp
>
> Hi Jocke,
>
> Well
o CGI?
>
> // jocke
>
>
> -Ursprungligt meddelande-
> Från: Frank M. Kromann [mailto:[EMAIL PROTECTED]
> Skickat: den 15 november 2005 17:23
> Till: Joakim Ling
> Kopia: php windows; Robert Twitty
> Ämne: Re: SV: [PHP-WIN] mssql tcp
>
> Hi Jocke,
>
> Well I work wit
: den 15 november 2005 17:23
Till: Joakim Ling
Kopia: php windows; Robert Twitty
Ämne: Re: SV: [PHP-WIN] mssql tcp
Hi Jocke,
Well I work with PHP and MSSQL and I know a bit about the broblems too.
The library used to build the extension (msdblib) is not thread safe so if
you are using the extension
Jocke
>
> -Ursprungligt meddelande-
> Från: Robert Twitty [mailto:[EMAIL PROTECTED]
> Skickat: den 15 november 2005 14:20
> Till: Joakim Ling
> Kopia: php windows
> Ämne: Re: [PHP-WIN] mssql tcp
>
> Are you using mssql_pconnect() to connect to the database?
Joakim Ling wrote:
It doesn't matter, the problem lies within php. To solve this problem you have to
use a client that usage pooling like ODBC -> MSSQL. So my next step is to
rewrite all mssql code to ODBC.
This is not a problem if you run a small mssql server, buy if you have over 100
databa
ng
Kopia: php windows
Ämne: Re: [PHP-WIN] mssql tcp
Are you using mssql_pconnect() to connect to the database?
-- bob
On Mon, 14 Nov 2005, Joakim Ling wrote:
> Hi
>
>
>
> When I connect to my MSSQL server (internal) with mssql_connect, make a
> few queries etc and then close the c
Are you using mssql_pconnect() to connect to the database?
-- bob
On Mon, 14 Nov 2005, Joakim Ling wrote:
> Hi
>
>
>
> When I connect to my MSSQL server (internal) with mssql_connect, make a
> few queries etc and then close the connection link. It creates a TCP
> connection each time (for every
Hi
When I connect to my MSSQL server (internal) with mssql_connect, make a
few queries etc and then close the connection link. It creates a TCP
connection each time (for every query). I'm running Win 2003 STD, IIS6,
PHP5, MSSQL2000. The problem is that the connection doesn't close
correctly so
I have looked in the online manual but am not able to find the
equivalent functions in mssql of mysql_errno() & mysql_error().
I am in the unfortunate position of having to develop using an existing
MSSQL database.
--
Regards,
Alf Stocktonwww.stockton.co.za
Lady Luck brings added
is there any other php.ini for command line execution???
--- Robert Twitty <[EMAIL PROTECTED]> wrote:
> Make sure the php.ini file used by the PHP command line interpreter
> has
>
> extension=php_mssql.dll
>
> The php.ini file used by PHP under Apache probably has this already
> specified. You
ok, i found the answer.
although i could not find the reason, u have to load php_mssql.dll
dynamically from the code with following line(it is not enough to set
from php.ini):
dl("php_mssql.dll");
but do not forget to put the DLL in directory C:\php4 .This is the
default directory for dl() fun
Make sure the php.ini file used by the PHP command line interpreter has
extension=php_mssql.dll
The php.ini file used by PHP under Apache probably has this already
specified. You can also just simply copy the php.ini for Apache over the
the one used for command line execution.
-- bob
On Tue, 7
hi,
php: 4.3.3
apache: 1.3.24
mssql: sql 2000 server
os: windows 2000
i try to run a php script from command line. it contains some mssql
functions. when i call it by browser, everthing works fine. but when
i call the same script from command line i get the error message:
Fatal Error: Couldn't f
need to have the proper grants in all
databases in order to do this.
-Original Message-
From: Robert Twitty
To: Gerardo Rojas
Cc: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 12-3-2004 20:17
Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result set
Hi Gerardo
abase, etc, etc.
-Original Message-
From: Gerardo Rojas
To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED]
Sent: 12-3-2004 19:30
Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result set
According to your last email, i can accomplish my goal, by doing:
insert into tablename se
n another remote db.
>
>
> --
> Gerardo S. Rojas
> mailto: [EMAIL PROTECTED]
>
>
> -Original Message-
> From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 12, 2004 12:26 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] MSSQL inserti
> > -Original Message-
> > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, March 11, 2004 3:25 PM
> > To: '[EMAIL PROTECTED] '
> > Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid
result
> > set
> >
b and the second
query (insert command) is on another remote db.
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-Original Message-
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 12:26 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] MSSQL inserting i
rom: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 11, 2004 3:25 PM
> To: '[EMAIL PROTECTED] '
> Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result
> set
>
>
> You can do a insert into with a SELECT instead of VALUE,
> b
Can i do a select from a PHP: resource (positive MSSQL result identifier)
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
-Original Message-
From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 3:25 PM
To: '[EMAIL PROTECTED] '
Subject: RE: [PHP-
You can do a insert into with a SELECT instead of VALUE,
but the attribute in the select must agree with the table
definition.
-Original Message-
From: Gerardo Rojas
To: [EMAIL PROTECTED]
Sent: 11-3-2004 21:54
Subject: [PHP-WIN] MSSQL inserting into a table with a valid result set
I
I have a valid result set from running a simple query. Is there a way of inserting
this into an existing table or creating a new table with the result set? All ideas
are welcome!
MSSQL Server 2000
PHP 4.3.4
Windows 2000 pro
IIS 5.0
--
Gerardo S. Rojas
mailto: [EMAIL PROTECTED]
You have to install the client libraries from the MSSQL setup CD.
-Mike
On Thu, 10 Jul 2003, Alain ROMERO wrote:
> Date: Thu, 10 Jul 2003 14:06:20 +0200
> From: Alain ROMERO <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] mssql
>
> Where is mssql.dll
Where is mssql.dll (not include in packages 4.1.2 / 4.2.3 / 4.3.2 ?
Thanks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
There are two ways. In MS SQL server 7.0 you can do SELECT TOP <#>
If you are on 6.5, then you need to do set the row count
environ variable, e.g something like "set rowcount <#>"
-Original Message-
From: disko_kex
To: [EMAIL PROTECTED]
Sent: 2003-07-02 1
PROTECTED]>
Sent: Wednesday, July 02, 2003 12:20 PM
Subject: [PHP-WIN] MSSQL HELP
: In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So
: how do I make it page in MSSQL?
:
:
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
In MySQL is easy to page with LIMIT but it doesnt work with MSSQL. So
how do I make it page in MSSQL?
Hello all!
as writen in the topic...
it cant load the php_mssql.dll
and i have no clue left what i did wrong
its PHP 4.2.3 with IIS on NT5
Thanks in advance!
Alex
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi there ...
I need to work php and mssql my version is 4.1.2 and on IIS, i figured
out that to work i need de client tools instaled and add
extension=php_mssql.dll in ini file, where do i get php_mssql.dll , or
what is the right procedure to have mssql support ??? I have no clue ..
THANKX !! A
this is personally why I try to always use iso compliant
"-mm-dd hh:nn" or "-mm-dd"
Matt Kynaston wrote:
> --=_NextPart_000_000D_01C25E30.61F93B80
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> PHP is supposed to output the date accordi
PHP is supposed to output the date according to the locale settings of the
server - see setlocale() function to force the issue. But dates are always a
pain - strtotime() and strftime() are your friends.
> Incidentally, inserting a value into the databases on both
> machines works
> presenting th
connection preferences by given technology.
-Original Message-
From: Matt Kynaston [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 6:15 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] MSSQL trouble: ansi_nulls?
OK, to answer my own question...
The ansi_* settings were to blame for the
002 10:31
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] MSSQL trouble: ansi_nulls?
>
>
> Hi there,
>
> I tried posting this to the newsgroup yesterday, but it
> doesn't look like it
> worked - sorry if it shows up twice.
>
> I'm running PHP 4.2.2 under Win2K/IIS a
Hi there,
I tried posting this to the newsgroup yesterday, but it doesn't look like it
worked - sorry if it shows up twice.
I'm running PHP 4.2.2 under Win2K/IIS and trying to run a stored proc in
MSSQL2000 (SP2) on the same server.
Exactly the same script works fine from Linux/Apache using Fre
hello,
any trouble connecting to MSSQL server from linux to win?
I Run php on linux with freeTDS e unixODBC
but there are alot lot of troubles.
Every now and then I have to close and reopen connections because
in pages with many queries, every qry need a new connection-..
Can't do any nested
Greetings All,
I posted this on Friday but now I have cut it down to make it readable and
stand alone
W2K server
MS SQL 2000
PHP 4.2.1 (in CGI mode)
I have a valid bit of SQL, but PHP does not correctly run it
below is bit of code
==8<==
Hi all!
I went after my problem with the NT authentification and I found out,
that if you want to make a NT-based Authentification (f.ex for an
ODBC-Connection) the I_USR will be seen as the actual user...
I granted then rights to the I_USR in the DB, but this way, I cannot
distinguish which use
What the heck are you talking about?
>-Original Message-
>From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, December 26, 2001 7:50 PM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
>[EMAIL PROTECTED]
>Subject: Re: [PHP-WIN] MSSQL conne
, almost literary quoting my
> answer, and then pinpointing down things I already pointed out! Moron...
>
> >From: Thomas "omega" Henning
> >Sent: Wednesday, December 26, 2001 8:50 AM
> >To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
> >[EMAIL PROTECTED]
> >Su
ROTECTED]
>Subject: Re: [PHP-WIN] MSSQL connect
>
>
>$h = "server adr"; //don't forget 2 change this
>$u = "user"; //don't forget 2 chage this
>$p = "passw"; //don't forget 2 change this
>$b = "db"; //don
Here is the problem $sql != $sql_temp
so the $result = NULL; because mssql_query(" ") has no query to send to the
MsSQL server.
This should work try it out!!!
Thomas "omega" Henning
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional c
From: Jerry [mailto:[EMAIL PROTECTED]]
>I tried something like:
>
>$h = "server adr";
>$u = "user";
>$p = "passw";
>$b = "db";
>$connexion = mssql_connect("$h", "$u", "$p");
Why do you uses quotes here?
>mssql_select_db($b);
>$sql = "select * from test";
.
>$result = mssql_query($sql_temp)
Hi
I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:
But it didn't work. Please help me.
Jerry
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands
Hi
I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:
But it didn't work. Please help me.
Jerry
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands
Hello,
I have this simple
query:
insert into table1 ( fname) values ('test1')
I use odbc_exec()all goes fine. Insert is performed.
I use mssql_query(); Query returns 1, but no insert is done!!!
same, db, same table, same user.
Why!!?
mssql_query("select * from table1")
I'm using php to retrieve a Query from a SQLServer 7.0 database.
My code is this one:
$base = mssql_select_db($db,$conexion);
$sql="SELECT MarcasSolicitante FROM Marcas";
$result = mssql_query($sql,$conexion);
while ($myrow = mssql_fetch_array($result))
{
$mensaje= $myrow["MarcasSolici
Martin, thank you for your helpful response. I tried it and it worked as
you suggested.
Lenny
- Original Message -
From: "Martin Lindhe" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>
Sent: Tuesday, October 02, 2001 8:15 AM
Subject: RE: [PHP-WIN] ms
you do that directly in a query
mssql_query("exec storeprocedure_name
'parmeter1','parameter2'",$database_connection);
> -Original Message-
> From: Leonard Harris [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 02, 2001 1:38 PM
> To: php
&g
Can mssql stored procedures be invoked from php? If so, are there any
unique considerations for invoking stored procedures from php?
Thanks for any advice/pointers/etc. you can provide.
Lenny Harris
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
F
g. It needs the client drivers to run properly.
-Flint
-Original Message-
From: John Meyer [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 13, 2001 12:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL Functions
Just a quick question on the MSSQL functions: are they unsupported in the
Just a quick question on the MSSQL functions: are they unsupported in the
CGI version of PHP?
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTEC
Hi,
Thanks for the responses, hit the nail right on the head. It works perfectly
now,
Cheers,
Kelvin.
-Original Message-
From: Flint Doungchak [mailto:[EMAIL PROTECTED]]
Sent: 19 April 2001 19:04
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] MSSQL t
You can set the limits in php.ini using these settings:
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
- Frank
> Hi,
> I've got a new problem to do with how long things can be! This time it is
> from
ck [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 10:46 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL text fields truncation
Hi,
I've got a new problem to do with how long things can be! This time it is
from a text field so I would expect there to be no limit. But my text i
Hi,
I've got a new problem to do with how long things can be! This time it is
from a text field so I would expect there to be no limit. But my text is
being cut off after 4096 characters. I am selecting with a mssql_query and
then using mssql_fetch_array to get the results. Has anyone run into thi
;Cc: Josh Seward; Daniel Furse; [EMAIL PROTECTED]
>Subject: [PHP-WIN] MSSQL varchar fields truncation revisited
>
>
>I'm still using 3.0.16 and when you have to display a varchar field in a
>MSSQL table everything over 255 characters gets truncated (this affects
>only selects, not
>-Original Message-
>From: Tomasz Abramowicz [mailto:[EMAIL PROTECTED]]
[...]
>check out www.mysql.com
>(or you maybe a really big bubu in your DB structure)
Cutted from "www.mysql.com"
"Why use MySQL?
MySQL is very fast, reliable, and easy to use.
If that is what you are looking fo
IL PROTECTED]]
> Sent: Thursday, April 19, 2001 2:37 PM
> To: Tomasz Abramowicz; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] mssql and php4
>
>
>
>
> >-Original Message-
> >From: Tomasz Abramowicz [mailto:[EMAIL PROTECTED]]
>
>
>-Original Message-
>From: Tomasz Abramowicz [mailto:[EMAIL PROTECTED]]
>hihi, mssql = sux
Well, that's a very intelligent and elaborated statment indeed.
Regards,
Anders
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additio
l the help,
> Kelvin.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 18 April 2001 15:18
> To: Kelvin Luck
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] mssql and php4
>
>
> >Any other ideas?
>
> Other fac
eland
Cc: Josh Seward; Daniel Furse; [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL varchar fields truncation revisited
I'm still using 3.0.16 and when you have to display a varchar field in a
MSSQL table everything over 255 characters gets truncated (this affects
only selects, not inserts). I k
e someone
elses machine...
Thanks for all the help,
Kelvin.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 18 April 2001 15:18
To: Kelvin Luck
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] mssql and php4
>Any other ideas?
Other factors that could affect perfor
>Any other ideas?
Other factors that could affect performance would be:
Is your table indexed?
How big the database is.
How complex is the query in "mssql_query($getArticlesSQL)"
Server cpu load.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
F
>Any other ideas?
Maybe you could install mysql and/or interbase on the same server as mssql.
Then you could do comparison tests.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the lis
I'm still using 3.0.16 and when you have to display a varchar field in a
MSSQL table everything over 255 characters gets truncated (this affects
only selects, not inserts). I know that a workaround would be to
transform the fieldtype from varchar to text, but this isn't very
practical in the parti
have PHP somehow
set up wrong...
Any other ideas?
Thanks,
Kelvin.
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
Sent: 18 April 2001 06:41
To: Tomasz Abramowicz
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] mssql and php4
MSSQL is actually as fast
MSSQL is actually as fast (or faster) as mysql on the same hardware, but I guess you
can compare the two and get the results you want. On the other hand that is not the
issue !
When you are configuring MSSQL systems with server and client on two different
computers you should consider using TC
hihi, mssql = sux
check out www.mysql.com
(or you maybe a really big bubu in your DB structure)
> Hi,
> I am just starting out with php and have managed to get it running OK on
my
> machine (Win2K) and connecting to an MSSQL 7 database on another machine
(on
> my LAN). However, it seems to run r
Hi,
I am just starting out with php and have managed to get it running OK on my
machine (Win2K) and connecting to an MSSQL 7 database on another machine (on
my LAN). However, it seems to run really slowly when accessing the database.
It takes around 6 seconds for my simple page to appear... At fir
schrieb im Newsbeitrag
9b5fv9$il6$[EMAIL PROTECTED]">news:9b5fv9$il6$[EMAIL PROTECTED]...
> How can i use MSSQL + IIS?
> i´m having some problems...
>
well then describe the problems. it's hard to
solve one if you don't know what it is.
Johannes
--
PHP Windows Mailing List (http://www.php.n
How can i use MSSQL + IIS?
i´m having some problems...
tks
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
t;Subject: [PHP-WIN] MSSQL Connect problems
>
>
>Hello -
>
>I'm trying to debug some scripts locally before I send them to my server.
>When the scripts are on the server they have no problem connecting to the
>MSSQL sever, but when run from my machine I can't ge
Is it the same DB server you're trying to connect to from locally run
scripts that you connect when the scripts are run from your hosting
server?
It does matter, because my hosting company for example has forbidden
any access to their DB servers for IP addresses different from the
addresses their
Hello -
I'm trying to debug some scripts locally before I send them to my server.
When the scripts are on the server they have no problem connecting to the
MSSQL sever, but when run from my machine I can't get it to establish a
connection. Any thoughts?
--TWB
--
PHP Windows Mailing List (htt
t; internet: http://www.suchtreffer.de
> _______________
>
>
>
> -Original Message-
> From: Martin Rokicki [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 7:08 PM
> To: '[EMAIL PROTECTED]
source setup on the web serve as a system dsn.
Thanks!,
Martin
-Original Message-
From: Michael Rudel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 1:31 PM
To: Martin Rokicki; [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] mssql and odbc functions
Hey Martin,
First Problem (mssql
7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___
-Original Message-
From: Martin Rokicki [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 7:08 PM
To: '[EMAIL PROTECTED]'
Subj
Hi All,
Thanks for the advice on database connectivity. I've tried
connecting to the mssql server (which is running 2000 not 6.5 as I had
thought) with the mssql_connect function as well as the odbc_connect
function. When I run the mssql connect I use this code:
MSSQL_CONNECT($host,$user,$
Hi Toby,
Ther is no difference in how MSSQL Server works on NT or Windows 2000. That goes for
both Client and server tools.
You should be able to do the same trick (copying ntwdblib.dll to winnt\system32) on a
Windows 2000 maschine.
You will get IIS5 on Windows 2000 where yoy have IIS4 on NT.
Hey all,
Actually, Frank might know this, but I was wondering if anyone is using the MSSQL
functions on Win2000 instead of NT. If so, are you using an installation of MSSQL
Server to allow your MSSQL functions to work or did you just copy the DLL's (like
Frank suggested in my earlier post). I
ich one. If Frank see
this, he
>might be able to give you some detailed insight. I just know it has to be
>installed.
>
>-Flint
>
>-Original Message-
>From: Toby Miller
[mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, February 07, 2001 4:04 PM
>To:
[EMAIL PROTECTED];
iller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 4:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] MSSQL Functions
Hey all,
I've got a question about using the MSSQL Functions. The only way I've been
able to use them is to install Microsoft SQL Client on
Hey all,
I've got a question about using the MSSQL Functions. The only way I've been able to
use them is to install Microsoft SQL Client on the web server. Is there any way to get
around this to use the MSSQL Functions without installing a copy of Microsoft SQL
Client? Right now I am using the
The PHP extension for MSSQL shoud strip leading and trailing spaces, but I check the
code and fix it if there is an error.
- Frank
>Hello,
>
>>From habbit and an unexplained hate to NULLs I do not use them in my
>databases.
>I use varchar fields with empty strings ('') instead.
>However MSSQL v
Hello,
>From habbit and an unexplained hate to NULLs I do not use them in my
databases.
I use varchar fields with empty strings ('') instead.
However MSSQL via the php4 module, returns these values as a single space
character,
and it forces me to trim all the returned varchar fields, before using
100 matches
Mail list logo
