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
Why use odbc?
Why not something like:
$server = "localhost";
$username = "USER";
$password = "Password";
$sqlconnect = mssql_connect($server, $username, $password) or DIE("Can't
Connect to server.");
$sqldb = mssql_select_db("DB", $sqlconnect);
$SqlSelectData = "select * from tablename";
$results
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
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
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
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
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 hav
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 (not include in packages 4
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 19:20
Subject: [PHP-WIN] MSSQL
It's not as easy with MSSQL, but the TOP syntax should work.
SELECT TOP 10 user,email FROM userdb WHERE user LIKE '%b%'
Regards,
Nick H.
Network Operations Center
[EMAIL PROTECTED]
- Original Message -
From: "disko_kex" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July
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
OK, to answer my own question...
The ansi_* settings were to blame for the sp failing. In Enterprise Manager
I went into the Server Properties (Properties > Connections) and made sure
'ANSI null defined on' was checked and the problem has cleared up.
Still mystified, though: why do connections f
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)
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
> Subject: [PHP-WIN] mssql stored procedures
No, they are supported on teh CGI version.
I don't know what you problem is now, but you just need to uncomment the
php_mssql.dll line in your php.ini file and make sure that you have the
extension. In addition, the MS SQL Client should be installed on the machine
in which PHP is running. It need
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
Kevin,
If you are using 4.0.4pl1 or recent version (4.0.x) of PHP, there is a
php.ini directive for MSSQL, for you to set this.
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
Uncomment and set the dir
A related problem with the query Analyzer and MS SQL server 7.0:
255 character column width is the default value used by the Query Analyzer.
There exists an option in the menu "Query->Current Connection Options"
select this, and then select the tab "Advanced", there you will find the
field "Maxi
>-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
I had the same problem with a cold fusion page a while ago. It turned out
that it was nothing to do with cold fusion but actually because I didn't
have the latest version of the MDAC components installed onto my cold fusion
server. There was a bug in previous versions which meant only the first 25
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
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
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
First: what method are you using to connect? ODBC?
IF you are using ODBC, then you might check weather you are using named
pipes or
not to connect to the server. If named pipes not work, change to TCP/IP -
some
times named pipes are not allowed because of security reasons.
Second, it might be re
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
extension=php_mssql70.dll
>
> I checked and I do have that dll in c:\winnt\system32. I also have the data
> source setup on the web serve as a system dsn.
> Thanks!,
> Martin
>
> -Original Message-
> From: Michael Rudel [mailto:[EMAIL PROTECTED]]
> Sent: Thu
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
Hey Martin,
First Problem (mssql): you don't have the mssql-extension running.
Check it out in the php.ini and remove the ; before the appropriate line.
Second Problem (odbc): I've never worked with mssql2k, but here a silly
question that *might* be the problem: the system-dsn entry, is it set o
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.
Hi All,
the key komponent is ntwdblib.dll installed in winnt\system32. The dll uses
other dll's to comunicate with the server dbmssocn.dll (tcp/ip) and dbmsnp.dll
(NetBios). All the communication dll's should be installed with the ODBC driver. Just
copy ntwdblib.dll from the SQL server to the
Toby,
Yes, the client is requires because the MSSQL module uses some libraries
from the client to function. I don't know which 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 [mai
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
62 matches
Mail list logo
