Re: [PHP] MSSQL Stored Proc

2012-08-28 Thread Andrew Ballard
On Tue, Aug 28, 2012 at 1:03 PM, Phillip Baker phil...@freewolf.net wrote: Greetings all, I am having some trouble with running a stored proc on an MSSQL DB. I am new to using MSSQL. $link = mssql_connect($server, $db, $password); if(!$link){ die('Error connecting to

Re: [PHP] MSSQL failing.

2010-07-09 Thread Paul Halliday
What am I missing? Is the slash before the domain name above just a typo in your e-mail? It took a while to get mssql configured to where I could test it here since we're using Microsoft's SQL Server Driver for PHP (if you are running PHP under Windows, I'd strongly recommend this over the

Re: [PHP] MSSQL failing.

2010-07-09 Thread Paul Halliday
On Fri, Jul 9, 2010 at 7:12 AM, Paul Halliday paul.halli...@gmail.com wrote: What am I missing? Is the slash before the domain name above just a typo in your e-mail? It took a while to get mssql configured to where I could test it here since we're using Microsoft's SQL Server Driver for PHP

Re: [PHP] MSSQL failing.

2010-07-09 Thread Andrew Ballard
On Fri, Jul 9, 2010 at 7:10 AM, Paul Halliday paul.halli...@gmail.com wrote: On Fri, Jul 9, 2010 at 7:12 AM, Paul Halliday paul.halli...@gmail.com wrote: It was a typo :) The installation is running on FreeBSD. I am looking at TDS right now as a possible cause. Got it: In

RE: [PHP] MSSQL failing.

2010-07-08 Thread Tommy Pham
-Original Message- From: Paul Halliday [mailto:paul.halli...@gmail.com] Sent: Thursday, July 08, 2010 10:01 AM To: php-general@lists.php.net Subject: [PHP] MSSQL failing. Is there something that needs to be tweaked or added to get this to work? I am trying to connect to server

Re: [PHP] MSSQL failing.

2010-07-08 Thread Andrew Ballard
On Thu, Jul 8, 2010 at 1:01 PM, Paul Halliday paul.halli...@gmail.com wrote: Is there something that needs to be tweaked or added to get this to work? I am trying to connect to server 2008 w/ MS SQL 2008. I can see the connections fail in the servers event logs if I take away \domain from

RE: [PHP] mssql and latin characters

2008-01-22 Thread Leticia Larrosa
-Original Message- From: Eric Butera [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 5:43 PM To: Leticia Larrosa Cc: php-general@lists.php.net Subject: Re: [PHP] mssql and latin characters On Jan 20, 2008 9:53 PM, Leticia Larrosa [EMAIL PROTECTED] wrote: Hello I have a MSSql

Re: [PHP] mssql and latin characters

2008-01-22 Thread Eric Butera
if that's different from the SQL server box. - Frank Regards Leticia Larrosa -Original Message- From: Eric Butera [mailto:[EMAIL PROTECTED] Sent: Monday, January 21, 2008 5:43 PM To: Leticia Larrosa Cc: php-general@lists.php.net Subject: Re: [PHP] mssql and latin characters

Re: [PHP] mssql and latin characters

2008-01-21 Thread Eric Butera
On Jan 20, 2008 9:53 PM, Leticia Larrosa [EMAIL PROTECTED] wrote: 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:

Re: [PHP] MSSQL

2008-01-15 Thread Richard Lynch
On Tue, January 8, 2008 4:06 pm, Alexis wrote: I am pulling my hair out trying to set up PHP to connect to SQL Server. The office server, running Server 2003, has SQL Server on it. One of my computers is running XP with Apache 2.2 and PHP 5.2.3. Another one has Ubuntu Gusty Gibbon, Apache

RE: [PHP] MSSQL

2008-01-08 Thread Shelley Shyan
Did you check that you have enabled MSSQL extension? That is, On XP system, you should have this line 'extension=php_msql.dll' in php.ini file and the leading ';' be removed. On Ubuntu, you should also install mssql extension, which is a little more complex. There should be no problem once you

Re: [PHP] MSSQL

2008-01-08 Thread Andrew Ballard
On Jan 8, 2008 8:58 PM, Shelley Shyan [EMAIL PROTECTED] wrote: Did you check that you have enabled MSSQL extension? That is, On XP system, you should have this line 'extension=php_msql.dll' in php.ini file and the leading ';' be removed. On Ubuntu, you should also install mssql extension,

Re: [PHP] mssql conflict with sybase...

2006-12-01 Thread Richard Lynch
On Fri, December 1, 2006 2:28 am, Le Phuoc Canh wrote: I use php version 4.4.2. When i use mssql and sybase extention, they are conflict together. I don't know how to using them together. It might be easiest to dump mssql and use sybase exclusively. Last I heard, Microsoft hasn't actually

RE: [PHP] mssql 20020429

2005-08-15 Thread Daniel Baughman
Never mind I found it. It was 4.2.1 But... now I get IIS complaining the CGI module hasn't returned a full set of headers :( -Original Message- From: Daniel Baughman [mailto:[EMAIL PROTECTED] Sent: Monday, August 15, 2005 2:58 PM To: php-general@lists.php.net Subject: [PHP] mssql

RE: [PHP] mssql 20020429

2005-08-15 Thread Daniel Baughman
-general@lists.php.net Subject: RE: [PHP] mssql 20020429 Never mind I found it. It was 4.2.1 But... now I get IIS complaining the CGI module hasn't returned a full set of headers :( -Original Message- From: Daniel Baughman [mailto:[EMAIL PROTECTED] Sent: Monday, August 15, 2005 2:58 PM

Re: [PHP] Mssql Connection

2005-01-19 Thread Jochem Maas
Pablo D Marotta wrote: Hi there.. I´m connecting to a Ms Sql Server 2000, with the system administrator´s name, and its password. It always works fine, but... I know it´s not the safest way of connecting, so I want to use some ordinary user names and passwords. The problem is that I just can´t

Re: [PHP] Mssql Connection

2005-01-19 Thread Richard Lynch
Jochem Maas wrote: FONT face=Arial color=FF size=3font/FONT FONT face=Arial color=FF size=3tags/FONT FONT face=Arial color=FF size=3suck/FONT I know nothing about MSSQL - thankgod (sorry I really can't help you there) - but I can recommend eradicating all font tags...

Re: [PHP] Mssql Connection

2005-01-19 Thread Jochem Maas
Richard Lynch wrote: Jochem Maas wrote: FONT face=Arial color=FF size=3font/FONT FONT face=Arial color=FF size=3tags/FONT FONT face=Arial color=FF size=3suck/FONT I know nothing about MSSQL - thankgod (sorry I really can't help you there) - but I can recommend eradicating all font

Re: [PHP] Mssql Connection

2005-01-19 Thread Richard Lynch
having said that any HTML in production envs should degrade nicely for older browsers. it doesn't have to look the same but it should be accessible. It won't be if you use CSS. I can't count the number of CSS sites I've skipped because their links don't work (in my browser) due to CSS.

[PHP] Re: PHP + MSSQL Problem

2004-12-18 Thread Ben
Alaor Barroso wrote: It looks like PHP can't communicate with MSSQL but it connect! Strange... What server platform are you using? If you are on *nix you will need to install freetds and then build php with freetds support before you can use mssql with it. Under a windows server platform this

RE: [PHP] MSSQL, PHP and Linux

2004-09-02 Thread Jay Blanchard
[snip] On Thursday 02 September 2004 08:30, blackwater dev wrote: the date is a very good question? Here is the info from my system -rwxr-xr-x1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. But that's probably your

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Frank M. Kromann
Hi, You should compile php with this option --with-mssql or --with-mssql=/path/to/freetds. This will enable the mssql extension. Enabling the DBX extension is not enough. DBX is just a wrapper arround other extensions. You still need to compile each of these extensions. - Frank I need some

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Marek Kilimajer
blackwater dev wrote: I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the errors called to

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Jennifer Goodie
-- Original message from blackwater dev : -- I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread John Holmes
From: blackwater dev [EMAIL PROTECTED] I need some help...I am helping a local business with a site which needs to connect to a mssql db, my webhost uses linux and compiled php with the freetds library and when I go to the info page..it does show Microsoft SQL Server under dbx yet I still get the

RE: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Dan Joseph
Hmm, I do see the MS SQL listed under DBX, but I don't see the --with=mssql in the configure line. Only psql and mysql. Does that need to be in there also? -Dan Joseph -Original Message- From: blackwater dev [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 1:19 PM To:

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread blackwater dev
No, I was using the mssql functions which I want to use. I tried the dbx functions example: $link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass); but go the error that the mssql module isn't loaded. On Wed, 1 Sep 2004 14:06:55 -0400, John Holmes [EMAIL PROTECTED] wrote: From:

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Ben Ramsey
Like I and others have said, you need to compile PHP --with-mssql Blackwater Dev wrote: No, I was using the mssql functions which I want to use. I tried the dbx functions example: $link = dbx_connect('mssql', $mssqldbhost,,$mssqldbuser,$mssqldbpass); but go the error that the mssql module isn't

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread blackwater dev
We just tried again with the -mssql switch but it still doesn't seem to be therethe -mssql isn't on the info page...I don't have a clue... http://mwvre.ht-tech.net/info.php On Wed, 01 Sep 2004 15:08:41 -0400, Ben Ramsey [EMAIL PROTECTED] wrote: Like I and others have said, you need to

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread blackwater dev
I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds It all appears to compile correctly, except the info page does not reflect the config was done with mssql at all. below is a snippet of the config switches that were used. --enable-ftp \

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Ben Ramsey
Just try --with-mssql=/usr/include instead. Is that where freetds is installed for you? I think it's in /usr/local for me, so I use --with-mssql=/usr/local. Blackwater Dev wrote: I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds It all appears to compile

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Jennifer Goodie
-- Original message from blackwater dev : -- I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds It all appears to compile correctly, except the info page does not reflect the config was done with mssql at all. below is a snippet of the

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread James Kaufman
On Wed, Sep 01, 2004 at 04:39:51PM -0400, blackwater dev wrote: I have tried recompiling with --with-mssql and --with-mssql=/usr/include/freetds It all appears to compile correctly, except the info page does not reflect the config was done with mssql at all. below is a snippet of the config

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread blackwater dev
the date is a very good question? Here is the info from my system -rwxr-xr-x1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. On Wed, 01 Sep 2004 22:29:41 +, Jennifer Goodie [EMAIL PROTECTED] wrote: --

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Jennifer Goodie
-- Original message from blackwater dev : -- the date is a very good question? Here is the info from my system -rwxr-xr-x 1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. Are you sure apache is

Re: [PHP] MSSQL, PHP and Linux

2004-09-01 Thread Jason Wong
On Thursday 02 September 2004 08:30, blackwater dev wrote: the date is a very good question? Here is the info from my system -rwxr-xr-x1 root root 1371932 Sep 1 19:50 /usr/bin/php Not sure why its showing that date - Apache has been restarted. But that's probably your php-cli

Re: [PHP] MSSQL stored proc

2004-04-13 Thread Curt Zirzow
* Thus wrote Aris Santillan ([EMAIL PROTECTED]): hi everyone can you give me a sample code of using MSSQL stored procedures? and its explanation.. Here's a good place to start. http://php.net/mssql_execute Curt -- I used to think I was indecisive, but now I'm not so sure. -- PHP

[PHP] Re: php/mssql character limit?

2004-03-08 Thread Ben Ramsey
I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy. ;-) Seriously, if anyone can help me out, I would be much

RE: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Vincent DUPONT
are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger vincent -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I

Re: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Ben Ramsey
I am using a text column type. I had always though that the max size for varchars was 255. Vincent DUPONT wrote: are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger -- Regards, Ben Ramsey http://benramsey.com

RE: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Jason Davidson
:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll

RE: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Vincent DUPONT
Is it mY SQL or MS SQL we are talking about? -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:42 To: [EMAIL PROTECTED] Subject: RE: [PHP] Re: php/mssql character limit? VARCHAR limit is 255 :) mysql.com has great documentation. Jason

RE: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Jason Davidson
: are you using a 'Text' or a 'varchar' column type? I guess the max size for varchars is 4000; text should be larger vincent -Original Message- From: Ben Ramsey [mailto:[EMAIL PROTECTED] Sent: lundi 8 mars 2004 17:30 To: [EMAIL PROTECTED] Subject: [PHP] Re: php/mssql

RE: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Alex Hogan
PROTECTED] Subject: [PHP] Re: php/mssql character limit? I posted this message the other day, and no one has responded. I'm replying to it to refresh it in the list. I guess if no one responds or helps me out this time, then I'll just forget about it and let my client go unhappy

Re: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Ben Ramsey
That's precisely what I was looking for, Alex! I must have overlooked it when skimming through php.ini. Thanks! Alex Hogan wrote: Hi Ben, The setting in the php.ini is; mssql.textlimit = 4096 Reset that value to what you want. I have mine set to 400. Valid range 0 - 2147483647 alex

Re: [PHP] Re: php/mssql character limit?

2004-03-08 Thread Stuart
Ben Ramsey wrote: Anyone know of any kind of character limit in php or mssql (yes, Microsoft SQL Server) for entering long text into a text column (of around 4,055 characters in length--that's where it's cutting off)? Have a look in php.ini - IIRC there are 2 options that affect this. -- Stuart

Re: [PHP] MSSQL connection

2004-01-22 Thread Raditha Dissanayake
I assume you are working on a win32 platform, if so uncomment that relevent line in the php.ini file and copy the dll to the win folders. (all this is explained in great detail in teh installation guide) If you are working on linux this approach will not work with mssql. Alex Hogan wrote: Hi

Re: [PHP] MSSQL connection

2004-01-22 Thread Ben Ramsey
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If your Web server is running on a machine that is separate from your database server, then you'll also need to copy the file ntwdblib.dll from the database server to your C:\WINDOWS\system32 folder. PHP needs that DLL for the mssql functions to work

Re: [PHP] MSSQL connection

2003-06-17 Thread Adam Voigt
You need to turn on the MSSQL extension in your php.ini, under Windows this file is probably in: c:\winnt\php.ini On Tue, 2003-06-17 at 11:01, Wim Paulussen wrote: LS, I am trying to get a connection to a remote MSSQL server. This is what I found in the online manual : quote

RE: [PHP] MSSQL connection

2003-06-17 Thread Wim Paulussen
That's it . Thank you very much ! -Oorspronkelijk bericht- Van: Adam Voigt [mailto:[EMAIL PROTECTED] Verzonden: Tuesday, June 17, 2003 5:10 PM Aan: Wim Paulussen CC: [EMAIL PROTECTED] Onderwerp: Re: [PHP] MSSQL connection You need to turn on the MSSQL extension in your php.ini, under

RE: [PHP] MSSQL connection

2003-06-17 Thread Wim Paulussen
, 2003 5:14 PM Aan: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Onderwerp: RE: [PHP] MSSQL connection That's it . Thank you very much ! -Oorspronkelijk bericht- Van: Adam Voigt [mailto:[EMAIL PROTECTED] Verzonden: Tuesday, June 17, 2003 5:10 PM Aan: Wim Paulussen CC: [EMAIL PROTECTED] Onderwerp

RE: [PHP] MSSQL - Previous/Next Paging Results

2003-06-10 Thread Dan Joseph
Hi, -Original Message- MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc Anyone know of articles/examples that specifically deal with this issue? Look into the Top() function for MSSQL. It goes something like: SELECT Top(10) * FROM table

Re: [PHP] MSSQL - Previous/Next Paging Results

2003-06-10 Thread CPT John W. Holmes
-Original Message- MSSQL seems to be a little bit messier that MySQL..e.g limit clause etc Anyone know of articles/examples that specifically deal with this issue? Look into the Top() function for MSSQL. It goes something like: SELECT Top(10) * FROM table You should be able

Re: [PHP] MSSQL using Sybase FreeTDS

2003-04-03 Thread Jyry Kuukkanen
On Thu, 3 Apr 2003, Craig wrote: Hey all, Im hoping someone can shed some light on this for me: Im running PHP 4.31 on RH Advanced Server 2.1 I am connecting, to M$SQL Server 2000 using FreeTDS -- with Sybase support, and Im stumped on 1 thing: CODE:

Re: [PHP] MSSQL using Sybase FreeTDS

2003-04-03 Thread Lowell Allen
From: Craig [EMAIL PROTECTED] Im running PHP 4.31 on RH Advanced Server 2.1 I am connecting, to M$SQL Server 2000 using FreeTDS -- with Sybase support, and Im stumped on 1 thing: [snip] The above code works fine, except when one of the fields e.g client_name - Has a quoted string or

Re: [PHP] MSSQL using Sybase FreeTDS

2003-04-03 Thread Michael Sims
On Thu, 3 Apr 2003 12:17:50 +0100, you wrote: Has anyone experienced this, and if so know of a possible solution?? I have used addslashes() etc but still no joy. In addition to what the other respondents have said, you can set the INI setting magic_quotes_sybase to 1, and this will change

RE: [PHP] MSSQL and NT

2002-07-15 Thread John Holmes
Not sure if this helps, but if you turn on NT-Authentication in IIS, then you'll have a variable $_SERVER['LOGGED_ON'] or something similar that'll hold the username of the person that's logged on. Check a phpinfo() page in a NT-Authenticated directory to see which variables are available.

RE: [PHP] MSSQL/PHP Query Help

2002-06-12 Thread Leotta, Natalie (NCI/IMS)
have you tried Nics.MAC in (xxx,xxx,xxx,xxx)? There's a lot less room for error in that, because it's so much tidier. -Natalie -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:56 AM To: [EMAIL PROTECTED] Subject: [PHP] MSSQL/PHP Query Help

Re: [PHP] MSSQL help w/ auto_increment

2002-04-23 Thread Geoff Hankerson
I believe the auto increment field has to be set as the primary key as well. - Original Message - From: David Orn Johannsson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 23, 2002 10:04 AM Subject: [PHP] MSSQL help w/ auto_increment I'm having a problem wiht creating a

Re: [PHP] MSSQL help w/ auto_increment

2002-04-23 Thread Miguel Cruz
Unfortunately there is a lot of variation from one RDBMS' SQL implementation to another. Try something like this: create table test ( news_id int identity, title varchar(50), blah blah... miguel - Original Message - From: David Orn Johannsson [EMAIL PROTECTED] To: [EMAIL

[PHP] Re: PHP - mssql

2002-03-20 Thread Joe Webster
I doubt msSQL differs from MySQL -- $link = mssql_connect( $host, $user, $pass ) or die( Can't connect to the DB! ); mssql_select_db( $dbname, $link ) or die( Can't select database ); $query = SELECT * FROM members WHERE user='$user' AND pass='$pass';; $result = mssql_query( $query, $link );

Re: [PHP] MsSQL PASSWORD()

2002-02-13 Thread val petruchek
12, 2002 3:06 PM Subject: Re: [PHP] MsSQL PASSWORD() At 09:26 AM 2/12/2002 +0200, val petruchek wrote: My current project runs on Win2k, MsSQL 2k, and PHP 4.0.6 My problem is that i can not enable md5 extension because of Unable to load dynamic library 'c:\windows\php\extensions

Re: [PHP] MsSQL PASSWORD()

2002-02-12 Thread Michael Sims
At 09:26 AM 2/12/2002 +0200, val petruchek wrote: My current project runs on Win2k, MsSQL 2k, and PHP 4.0.6 My problem is that i can not enable md5 extension because of Unable to load dynamic library 'c:\windows\php\extensions/php_mcrypt.dll' - The specified procedure could not be found. in

Re: [PHP] MsSQL PASSWORD()

2002-02-12 Thread DL Neil
Zliy Pes, (I have no idea what this name means - trust it doesn't mean that you'll be coming after me with a sharp knife!) My current project runs on Win2k, MsSQL 2k, and PHP 4.0.6 My problem is that i can not enable md5 extension because of Unable to load dynamic library

Re: [PHP] MsSQL PASSWORD()

2002-02-11 Thread Michael Sims
At 06:34 PM 2/11/2002 +0200, val petruchek wrote: Hello, list! I'm looking for analog of Mysql password() func in MsSQL. My goal is not to store certain field (i.e. user passwords) as a clear text. I don't know the equivalent off the top of my head, but a coworker of mine has used it before.

[PHP] Includes in your document root (was: Re: [PHP] MsSQL PASSWORD())

2002-02-11 Thread bvr
In that case, forget what I said ';) But since you can't say this enough, here is it once more: *** Always remember to keep those includes *out of* your document root; This prevents accidental displaying of source code or (which I heard on this list could even be worse) out-of-context

Re: [PHP] MsSQL PASSWORD()

2002-02-11 Thread val petruchek
Zliy Pes) *** Cut the beginning *** http://zliypes.com.ua mailto:[EMAIL PROTECTED] - Original Message - From: Michael Sims [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 12, 2002 2:29 AM Subject: Re: [PHP] MsSQL PASSWORD() At 06:34 PM 2/11/2002 +0200, val petruchek wrote

Re: [PHP] MsSQL from FreeBSD

2001-12-28 Thread Valentin V. Petruchek
OK, we're talking about Linux, right? No ;) FreeBsd 4.x don't know exactly about x I'll bet `cat /proc/sys/fs/file-max` gives you 4096 Try upping the file descriptor limit in /proc/sys/fs/file-max. That may or may not solve the problem; worth a try. How much memory does the client machine

Re: [PHP] MsSQL from FreeBSD

2001-12-28 Thread Brian Clark
* Valentin V. Petruchek ([EMAIL PROTECTED]) [Dec 28. 2001 04:51]: OK, we're talking about Linux, right? No ;) FreeBsd 4.x don't know exactly about x Duh, that was stupid of me. It's right there in the subject. I'll bet `cat /proc/sys/fs/file-max` gives you 4096 OK, then give this a try:

Re: [PHP] MsSQL from FreeBSD

2001-12-27 Thread Brian Clark
* Valentin V. Petruchek ([EMAIL PROTECTED]) [Dec 27. 2001 05:55]: Hello php-world! Hello. PHP is configured './configure' '--with-apache=../apache_1.3.22' '--with-mysql' '--with-sybase=/usr/local/freetds' '--enable-track-vars' Everything works fine when using mssq-Functions, except

Re: [PHP] MsSQL from FreeBSD

2001-12-27 Thread Valentin V. Petruchek
Total Links 0/unlimited Application Name PHP 4.0 Client API Version - Original Message - From: Brian Clark [EMAIL PROTECTED] To: PHP is not a drug. [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 4:59 PM Subject: Re: [PHP] MsSQL from FreeBSD * Valentin V

Re: [PHP] MsSQL from FreeBSD

2001-12-27 Thread Brian Clark
* Valentin V. Petruchek ([EMAIL PROTECTED]) [Dec 27. 2001 10:28]: Yes, php.ini is there. [...] I've changed php.ini - turned mssql_limits to 100 (instead of 4096), restarted a[pache but problem doesn't seem to disappear. OK, we're talking about Linux, right? I'll bet `cat

Re: [PHP] MsSQL question

2001-12-05 Thread Jon Farmer
Hello world! I'm using php 4.0.6 to work with MsSQL (FreeBSD 4.4, Apache 1.3.20). How should i compile php to enable mssql functions? Exactly as described here: http://www.php.net/manual/en/ref.mssql.php RTFM -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763

Re: [PHP] MsSQL question

2001-12-05 Thread Valentin V. Petruchek
Thanks, i've looked in previously downloaded manual and 've found nothing ;) - Original Message - From: Jon Farmer [EMAIL PROTECTED] To: [EMAIL PROTECTED]; PHP [EMAIL PROTECTED] Sent: Wednesday, December 05, 2001 11:55 AM Subject: Re: [PHP] MsSQL question Hello world! I'm using php

Re: [PHP] MSSQL 7.0 and PHP

2001-10-24 Thread James Cave
varchar only accepts values up to 255 (so does char) I've found this too .. MS-SQL probably ceil()s the parameter in the table create statement to 255 without throwing an error. Have a quick look at the column you've created and you'll probably find it's a char(255). To get larger than that

RE: [PHP] MSSQL 7.0 and PHP

2001-10-23 Thread Nick Richardson
my understanding (and i could be totally wrong) is varchar only accepts values up to 255 (so does char). To get larger than that you have to use 'text' (i.e. create table name (column text not null..); -Original Message- From: Franco Breciano [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP] MSSQL Support

2001-09-19 Thread Frank M. Kromann
Hi Jason You can download and install FreeTDS (www.freetds.org). Then you can compule with the option --with-sybase=/usr/local/freetds. Thsi way you get the Sybase extension and this includes aliases for mssql_*. Be aware the FreeTDS can be used with MSSQL server 4 and 6 and in some cases

Re: [PHP] MSSQL Support

2001-09-19 Thread Michael Kimsal
Jason Wilson wrote: I'm compiling PHP and have a request from one of my developers for MSSQL support in mod_php (4.0.6). However, I don't see a configure option for MSSQL. Is there a *secret* configure option or are the MSSQL functions built in by default? +---+ |

Re: RE: [PHP] mssql and uniqueidentifier's

2001-06-29 Thread Frank M. Kromann
Hi all, The dll is not broken. The type UNIQUEIDENTIFYER is a 16 byte binary value and is returned as such. With versions of the php_mssql.dll distributed with php4.0.5 or before did not include proper support for binary data. This has been changed in php4.0.6. I have hust added a small

RE: [PHP] mssql and uniqueidentifier's

2001-06-27 Thread scott [gts]
well, the SQL statement you're trying to execute would help determine why it's not working... :) just stating that it's broken is like saying my car makes this funny noise and hoping that a mechanic will give you a detailed diagnosis. -Original Message- From: Thomas Häger

Re: [PHP] MSSQL

2001-05-14 Thread Fabian Raygosa
According to the php docs there is no mssql_pconnect just mssql_connect get rid of the p - Original Message - From: Andreas Pucko [EMAIL PROTECTED] To: Php (E-mail) [EMAIL PROTECTED] Sent: Monday, May 14, 2001 3:19 PM Subject: [PHP] MSSQL Hi there, while tying to connect to a MSSQL

Re: [PHP] MSSQL (Mistake)

2001-05-14 Thread Fabian Raygosa
DAMN SORRY there is a pconnect duh bad me bad me - Original Message - From: Fabian Raygosa [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Php (E-mail) [EMAIL PROTECTED] Sent: Monday, May 14, 2001 3:18 PM Subject: Re: [PHP] MSSQL According to the php docs there is no mssql_pconnect just

Re: [PHP] mssql

2001-03-24 Thread almir
1) if you are running it on linux(web server ) it will cost you about 2000$ at least to connect it , and you will have to use odbc for linux, 2)if you are using ms web server then you have to enable support for that in php3.ini but usualy this way is not good, i usualy had problems with that and

Re: [PHP] mssql

2001-03-24 Thread Andrew Hill
Actually, OpenLink's ODBC drivers can get you connected from any UNIX to MS SQLServer, and start out at free of charge for 2 concurrent database sessions. This also includes free support. The commercial pricing for higher concurrent database connections starts at $675. The free download is

Re: [PHP] mssql

2001-03-23 Thread Felix Kronlage
On Fri, Mar 23, 2001 at 06:16:10PM -0500, Mauricio Alarcon wrote: I want to connect to a Microsoft SQL Server, I try with mssql_connect but the script don't work, it always say Call to unsupported or undefined function are you sure, that ms-sql support is compiled into your php? what does

Re: [PHP] MSSQL field type money bring a string not a number back

2001-01-22 Thread Romulo Roberto Pereira
I am sorry about this - I figured out already - was nothing to do with the convertion... Rom - Original Message - From: Romulo Roberto Pereira [EMAIL PROTECTED] To: php-general [EMAIL PROTECTED] Sent: Monday, January 22, 2001 5:15 PM Subject: [PHP] MSSQL field type money bring a string