many changes to php.ini to get this far..whew!
PHP 5.2.7 just got jerked out from underneathe me (I have't replaced it since
this is a simple script)
phpinfo works!
\ or
// , when using a non default port number
$server = 'LANDON\SQLEXPRESS';
$link = mssql_connect($server, 'sa', 'PW');
Hi,
please, how can I set client encoding for MS SQL server from php? I did not
find any working solution. :-(
Database: windows-1250
Web and app: UTF-8
Thanks
Fanda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hane you tried
$result = mssql_query("EXEC getSomeCoolData '061451221', NULL, NULL" );
Also, did you try mssql_init()?
-- bob
On Wed, 4 Jan 2006, meska wrote:
> Hi,
>
> I've done it in various ways, still, no luck..
>
> Lets say i have a stored procedure getSomeCoolData declared as :
>
> [getS
Hi,
I've done it in various ways, still, no luck..
Lets say i have a stored procedure getSomeCoolData declared as :
[getSomeCoolData]
@prodCode char(255),
@prodName nvarchar(255),
@prodID int = NULL
This stored procedure returns products based on parameters i pass. So let's
say i do like this
Hi Rafi,
You need to install (and configure) the SQL Server Client tools. The
important part here is the 'Client Network Utility' where you create
aliases for host names, protocols and other options.
The default setting for both the SQL server and the client is (in most
cases) to use named pipes
I am trying to create a connection w' MS-SQL Server to use with php. I have
the server name (on our LAN) and my UID & PWD (work via MS-ODBC driver for
Access db). However my php is failing to bring any data back (unknown
host). Any suggestions if I am missing any parms?
[I am a newbie so plz
ite so stupid as when I'm trying to be quite so smart!
Thanks for sticking with me on this one.
Michael
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 6:38 PM
To: Michael Flanagan
Cc: Php-Db
Subject: RE: [PHP-DB] MS SQL 'C
&$errorString)
> {
> // Get info, based on the $select query
> $result = $db->query($select);
> if (DB::isError($result)) {
> $errorString .= $result->getMessage() .
> $result->getDebugInfo ();
> return FALSE;
> }
> re
= $result->getMessage() .
$result->getDebugInfo ();
return FALSE;
}
return $result;
}
-----Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 22, 2004 2:49 PM
To: Michael Flanagan
Cc: Php-Db
Subject: RE: [PHP-DB] MS SQL 'Cha
am I doing wrong? If so, how can I get around this?
> Thanks!
>
> Michael
>
> -Original Message-
> From: Frank M. Kromann [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 21, 2004 7:40 PM
> To: Php-Db
> Subject: RE: [PHP-DB] MS SQL 'Changed database contex
So, is this a PEAR
problem? If not, what am I doing wrong? If so, how can I get around this?
Thanks!
Michael
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 21, 2004 7:40 PM
To: Php-Db
Subject: RE: [PHP-DB] MS SQL 'Changed database c
Twitty [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 19, 2004 5:38 PM
> To: Michael Flanagan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] MS SQL 'Changed database context' error
>
>
> Hi Michael
>
> You might get better results using the odbtp ex
> the
> > exact same $db connection object.
> >
> > Any ideas on getting PHP to ignore this info message?
> >
> > Thanks again.
> > Michael
> >
> > -Original Message-
> > From: Adam Voigt [mailto:[EMAIL PROTECTED]
> > Sent: Thursday
PM
> To: Michael Flanagan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] MS SQL 'Changed database context' error
>
>
> Hi Michael
>
> You might get better results using the odbtp extension with support for
> the mssql functions. Since you are using Windows,
obert Twitty [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 5:38 PM
To: Michael Flanagan
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MS SQL 'Changed database context' error
Hi Michael
You might get better results using the odbtp extension with support for
the mssql function
ork?
> mssql.min_error_severity = 11
> mssql.min_message_severity = 11
>
> Michael
>
> -Original Message-
> From: Adam Voigt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 19, 2004 12:44 PM
> To: Michael Flanagan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] MS SQL &#
severity levels, and their interplay with MS SQL Server??
Thanks.
Michael
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 5:07 PM
To: Michael Flanagan
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MS SQL 'Changed database context' e
ork?
> mssql.min_error_severity = 11
> mssql.min_message_severity = 11
>
> Michael
>
> -Original Message-
> From: Adam Voigt [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 19, 2004 12:44 PM
> To: Michael Flanagan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB]
don't work?
mssql.min_error_severity = 11
mssql.min_message_severity = 11
Michael
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 12:44 PM
To: Michael Flanagan
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MS SQL 'Changed database context&
; Sent: Thursday, February 19, 2004 12:13 PM
> To: Michael Flanagan
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] MS SQL 'Changed database context' error
>
>
> This may not be the case, but I've seen this before when the PHP library
> didn't know how to exp
lto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 12:13 PM
To: Michael Flanagan
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MS SQL 'Changed database context' error
This may not be the case, but I've seen this before when the PHP library
didn't know how to express MS SQL's e
This may not be the case, but I've seen this before when the PHP library
didn't know how to express MS SQL's error, so it simply returns the last
message sent which was the informational context change. If it is infact
an error, you should be able to plug the query directly into Enterprise
Manager
I'm getting the error "Changed database context" from MS SQL. I see
where this is supposedly just an informational message. I've tried
setting
mssql.min_error_severity = 11
mssql.min_message_severity = 11
but to no avail. What am I missing? I don't mind the message so much,
but php treats thi
This doesn't have anything to do with PHP, but it does have to do with
MS SQL server and I know we've got a buncha smart folks on this list.
I'm sure you'll forgive the slightly OT post.
I have a stored procedure that I want to protect from external rollback
calls. Basically, it logs calls to itse
Oops
Use "Off" instead of "On", or execute this in your script:
ini_set('mssql.datetimeconvert' , 0 );
Note: Do not use the date() function to display the value. Just display
it "asis".
-- bob
On Tue, 27 Jan 2004, Steve wrote:
> I tried what you had suggested and I still get the same result.
I tried what you had suggested and I still get the same result.
Robert Twitty wrote:
The date() is for use with the 32-bit C time value returned by functions
like time(). Data from fields of type datetime are returned as strings in
the form Jan 9 2004 by the mssql extension as the default. To
The date() is for use with the 32-bit C time value returned by functions
like time(). Data from fields of type datetime are returned as strings in
the form Jan 9 2004 by the mssql extension as the default. To return it
using ISO format set mssql.datetimeconvert to "On" in the php.ini file, or
use
I have Apache 1.3 and PHP 4 running on Windows 98 connecting to a local
MS SQL 7.0 server. MS SQL has the date as 2004-01-09 (-MM-DD), when
I print the date to a webpage with this PHP code:
printf("Date Picked Up: %s\nDate", date("Y/j/n",$row[0]);
I get this output:
1969/12/31
What is wr
Hi everyone.
I have a Redhat 8 box with Apache 2.0.40, PHP 4.3.1, FreeTDS 0.61 to work
with an MS-SQL2000 server.
It works fine and I have no problems but today i found this.
When i call specific stored procedures it retrieve no rows, and if i paste
this query on the Query Analizer it works fine
Thanks for the immediate response... it turns out my co-worker actually
had a bug in his stored proc ...
(nobody ever admits the problem is their own eh?)
hehe
~Steve
[EMAIL PROTECTED] wrote:
my experience in the past is just:
$SQL = "sp_runthis $param1, $param2, $param3";
$RES = mysql_que
my experience in the past is just:
$SQL = "sp_runthis $param1, $param2, $param3";
$RES = mysql_query($SQL);
may have to prefix with exec like you mentioned...
change sp_runthis to your procedure name... probably still works the
same..
On Wed, 16 Jul 2003, Stephen March wrote:
> Anybody ha
Anybody have code that WORKS (hehe) for executing a MS-SQL stored
proceedure through PHP?
exec viewFacilities()
Thanks in advance!
~Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I'm using MS-SQL-Server (MSDE, ServicePack 3), with Apache 1.3.27
PHP/4.3.1 completely under Windows 2000.
My task is, to build an installation package, which installs MSDE,
Apache and PHP and some PHP-code on arbitrary Windows 2000 systems.
Currently my installation package is running. It
as Robert and me observed (from source code) - that switch isn't there in 4.1.2
after installing 4.3.1 there is no problem with date format - switch is working
5o
Robert Twitty wrote:
> I don't have access to the source code for PHP 4.1.2, but I would not be
> suprised if this was the case.
PROTECTED]]
Sent: Thursday, January 23, 2003 8:21 PM
To: Grant, Dean (OIT); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] ms sql limit equivalence
> I am just joining this list so if this has been covered in the past I
> apologize. I am working with MS SQL and would like the functionalit
> I am just joining this list so if this has been covered in the past I
> apologize. I am working with MS SQL and would like the functionality
that
> MySQL's limit function provides. I understand that MS SQL has no such
> command or equivalent. Has someone found a way to use standard (or MS
SQL
>
b.ca> Subject: [PHP-DB] ms sql limit
equivalence
Hi,
I am just joining this list so if this has been covered in the past I
apologize. I am working with MS SQL and would like the functionality that
MySQL's limit function provides. I understand that MS SQL has no such
command or equivalent. Has someone found a way to use standard (or MS SQL
spe
12, 2002 9:57 AM
To: php.db
Subject: [PHP-DB] MS Sql Server xp_sqlagent_proxy_account
exec master.dbo.xp_sqlagent_proxy_account N'GET'
Anyone ever had the above give you "Access is denied." When you run it as 'sa' ???
<>< Ryan
--
PHP Database Mailing
exec master.dbo.xp_sqlagent_proxy_account N'GET'
Anyone ever had the above give you "Access is denied." When you run it as 'sa' ???
<>< Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm trying to connect to an MS SQL Server but I'll receive permanetly
this message:
Warning: MS SQL message: Login failed for user 'mirela'. Reason: Not
associated with a trusted SQL Server connection. (severity 14) in
d:\inetpub\wwwroot\roslocal\registrums.php on line 24
Warning: MS SQL: Unable
I run MS SQL 2000 on a win 2k machine and IIS5. On this i have installed
php4.11 with php_mssql.dll support. When i do an insert query it works fine.
But my problem is with SELECT querys.
If i write a select query and run it on a table that is empty it works fine.
BUT if i put an entry into the
I am trying to get PHP to work with MS SQL Server 7, but its not liking
something
when I do a mssql_connect() it says "
Fatal error: Call to undefined function: mssql_connect() in
c:\inetpub\wwwroot\test.php on line 7
I have added the proper extensions, have put them in the right directory.
S
tting off-topic, let's continue in pvt. When we get the
solution you can send it back to the list.
Bruno.
- Original Message -
From: "Matt Lemon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 22, 2001 2:30 PM
Subject: Re: [PHP-DB] Ms
> 2 options:
> - compile php with mssql support (might be ./configure --with-mssql ...)
or
> - if you installed from packet (rpm for example) you can install the
packet
> for mssql (it should be something like php_mssql.version.rpm)
Okey, on http://www.php.net/manual/en/function.mssql-connect.php
reti.
>
> - Original Message -
> From: "Matt Lemon" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, November 22, 2001 3:08 PM
> Subject: [PHP-DB] Ms SQL.
>
>
>> I'm trying to get my linux server to connect to an MS
like php_mssql.version.rpm)
Bruno Gimenes Pereti.
- Original Message -
From: "Matt Lemon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 22, 2001 3:08 PM
Subject: [PHP-DB] Ms SQL.
> I'm trying to get my linux server to connect to an MS SQL
I'm trying to get my linux server to connect to an MS SQL server via php.
If I run the same script on my windows laptop there is no problem but on
the Linux server I get the message :
Fatal error: Call to undefined function: mssql_connect() in
/var/www/html/stationary/index.php on line 49
I
//Richard
-Original Message-
From: Daniel Persson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 2:35 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MS SQL Server support
I got this error message when using PHP 4.06 with MSSQL.
PHP ERROR: PHP build incomplete: the prerequisite MS SQL Serv
I got this error message when using PHP 4.06 with MSSQL.
PHP ERROR: PHP build incomplete: the prerequisite MS SQL Server support
required to read the alert database
was not built into PHP. Please recompile PHP with the necessary library
(--enable-mssql).
Is there anyone who knows what's wrong?
Date : Thu, 04 Oct 2001 12:17:18 -0700
> Subject : Re: [PHP-DB] MS SQL 7
>
> If your storred procedure returns a result set you can get it with
the mssql_functions as well.
>
> If the precedure returns values or output parameters you will need
php 4.0.7 (or current cvs). The updated
If your storred procedure returns a result set you can get it with the mssql_functions
as well.
If the precedure returns values or output parameters you will need php 4.0.7 (or
current cvs). The updated version of php_mssql.dll includes three new functions aimed
for storred procedures.
- Fran
Is there a way to retrieve records from a stored procedure with MS SQL 7?
I've tried but I couldn't get anything.
I read on the PHP bug site that I can only use SELECT statement, but ODBC
should work; is that true?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mai
ology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -Original Message-
> From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 10:33 PM
> To: [EMAIL PROTECTED]
> Subject:
Hi,
Did someone ever connect PHP (on Linux box) to MS SQL (on NT box) via ODBC
(iODBC or unixODBC)? How to config and writing code in PHP?
thanks
SF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PRO
Hi.,
I'm currently using an IIS5 (W2k) with php4.0.6 (CGI) and MS SQL Server
2000.
I've run into problems when fetching fileds of the type datetime from the
database.
When using the MS SQL Query Analyzer I get my dates formated like this out
of my database: 2001-06-08 08:14:40.000
When using php
> -Original Message-
> From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 4:00 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] MS SQL 6.5 connection
>
>
> I've been setting PHP 4.0.6 with apache 1.3.20 in Linux
> Red H
Hi,
I've been setting PHP 4.0.6 with apache 1.3.20 in Linux Red Hat 6.2 to
connect MS SQL 6.5 via TDS4.2 (freetds-0.51). Why I can't connect to MS
SQL 6.5? here my code in php
here is freetds config
SQLSERVER
query tcp tds4.2 203.144.255.71 1443
master tcp tds4.2 203
> -Original Message-
> From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 2:45 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] ms sql connect
>
>
> Hello,
> I'd like to use MS SQL 6.5 on NT from PHP-4.0.6 from Linux.
>
Hello,
I'd like to use MS SQL 6.5 on NT from PHP-4.0.6 from Linux. I was
config FreeTDS (use ver 4.2) and setup interfaces file already. I'm still
cannot login to MS SQL 6.5. Here is my config.
- Linux Red Hat 6.2 (use different IP with NT-Box)
- Apache 1.3.
Hi,
I am having trouble setting a datetime in a ms sql database. I can put in a
date, but when I add the time i always get an error. this is likely
something simple, any thoughts? thanks
--Brian
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
What are these magical MS SQL DB-libraries and where can they be found?
Thank you,
Sean
::Sean Richards
::www.sharpwebinnovations.com
::web hosting and applications development
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional comman
L PROTECTED]]
> Sent: Monday, April 23, 2001 8:18 AM
> To: Manuel Prieur; PHP-DB
> Subject: Re: [PHP-DB] MS-SQL Server on PHP4/Apache/Linux
>
>
> > I currently use PHP4/IIS to access a MS-SQLServer 7.0 with "mssql_*"
> > functions ("php_mssql70.dll" extensio
> I currently use PHP4/IIS to access a MS-SQLServer 7.0 with "mssql_*"
> functions ("php_mssql70.dll" extension).
>
> I plan to move my website on PHP4/Apache/Linux, and I am wondering if thoses
> functions will work and how, as I didn't find any explanations on it in
> documentation.
>
I think
Hello,
I currently use PHP4/IIS to access a MS-SQLServer 7.0 with "mssql_*"
functions ("php_mssql70.dll" extension).
I plan to move my website on PHP4/Apache/Linux, and I am wondering if thoses
functions will work and how, as I didn't find any explanations on it in
documentation.
Thanks.
===
Well, I just started working on implementing SQL Server support in my
database abstraction class. I downloaded and installed the SQL2k evaluation
from MS and I can connect through DBArtisan and through the SQL Server Query
tool. However when I try to do it through PHP, it just sits there, and
caus
8, 2001 2:13 PM
---> To: [EMAIL PROTECTED]
---> Subject: [PHP-DB] Ms SQL Server inserting image datatype with PHP??
--->
--->
---> How can I accomplish this??
--->
--->
--->
---> --
---> PHP Database Mailing List (http://www.php.net/)
---> To unsubscribe, e-m
How can I accomplish this??
--
PHP Database 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]
I'm having trouble compiling my new PHP4 module with apache 1.3.17 using
freetds to connect to a Microsoft SQL server. There's a great article
out on PHPBuilder for an older version of PHP4 complete with patches,
but I wanted to build this new box with the latest revs of code. Has
anyone else at
So you like to let the SQL check for those constraints and you want only the
PHP to deal with that ugly error:
- disable the error output by placing @ before your php-function
- catch the error either by checking $php_errormsg (works only if
error-tracking is enabled) or by the result code or
[EMAIL PROTECTED] wrote:
> How can I put in my own custom message when these errors occur?
> Should I be looking for a failed query message and then acting on
> that? I like the protection that the foreign key relationship
> enables, because you can't delete "parent" objects without
>
, 2001 7:22 PM
To: [EMAIL PROTECTED]
Subject:[PHP-DB] MS-SQL Error Message Replacement
I'm working with MS-SQL 7 and IIS 4 as well as PHP4.0.4 ---
My question is that when a message is received while attempting to delete a
row in [table x] while it is tied to [table y.column a]
I'm working with MS-SQL 7 and IIS 4 as well as PHP4.0.4 ---
My question is that when a message is received while attempting to delete a
row in [table x] while it is tied to [table y.column a] by a foreign key
relationship [see below]
Warning: MS SQL message: DELETE statement conflicted with COLU
73 matches
Mail list logo
