Re: [PHP] MSSQL Stored Proc

2012-08-28 Thread Andrew Ballard
On Tue, Aug 28, 2012 at 1:03 PM, Phillip Baker 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 MSSQL d

Re: [PHP] MSSQL failing.

2010-07-09 Thread Andrew Ballard
On Fri, Jul 9, 2010 at 7:10 AM, Paul Halliday wrote: > On Fri, Jul 9, 2010 at 7:12 AM, Paul Halliday 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 /usr/local/etc/freetds.conf: > > [global] >       hos

Re: [PHP] MSSQL failing.

2010-07-09 Thread Paul Halliday
On Fri, Jul 9, 2010 at 7:12 AM, Paul Halliday 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 (if yo

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 thi

Re: [PHP] MSSQL failing.

2010-07-08 Thread Andrew Ballard
On Thu, Jul 8, 2010 at 1:01 PM, Paul Halliday 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 \domain\username (mixed

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 ser

Re: [PHP] mssql and latin characters

2008-01-22 Thread Eric Butera
:[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 > > > > > &

RE: [PHP] mssql and latin characters

2008-01-22 Thread Leticia Larrosa
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: >

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 data

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, A

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 extensi

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 h

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 c

RE: [PHP] mssql 20020429

2005-08-15 Thread Daniel Baughman
#x27;; php-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,

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 200204

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

Re: [PHP] Mssql Connection

2005-01-19 Thread Jochem Maas
Richard Lynch wrote: Jochem Maas wrote: font tags suck I know nothing about MSSQL - thankgod (sorry I really can't help you there) - but I can recommend eradicating all font tags... everywhere... take no prisoners... death to frontpage (oh sorry got carried away :-). try this instead: # Can´t esta

Re: [PHP] Mssql Connection

2005-01-19 Thread Richard Lynch
Jochem Maas wrote: > font > tags > suck > > I know nothing about MSSQL - thankgod (sorry I really can't help you > there) - but I can recommend eradicating all font tags... everywhere... > take no prisoners... death to frontpage (oh sorry got carried away :-). > try this instead: > > > # Can´t est

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 make

[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 m

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 yo

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-

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 i

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 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 confi

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 >

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 correctly,

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 \ --enable-magi

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 com

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 l

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: > Fr

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 > T

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 t

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 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 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 h

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." -- PH

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] 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 hog

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

2004-03-08 Thread Alex Hogan
; 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 just forget ab

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

2004-03-08 Thread Jason Davidson
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 posted this message the other day, and no one has responded. I'm >

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
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 posted this message the other day, and no one has responded. I'm > re

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 http://www.phpco

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

[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 appreciat

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 c

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 A

RE: [PHP] MSSQL connection

2003-06-17 Thread Wim Paulussen
une 17, 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 PROTE

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,

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 : > > mssql_conne

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 sh

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 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 addsl

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 quo

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 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. ---Jo

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 Quer

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: <[EMAI

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 creatin

[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
AIL PROTECTED]> Sent: Tuesday, February 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

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 'c:\windows\ph

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-11 Thread val petruchek
entin Petruchek (aki 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() &g

[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 executio

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

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

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 ma

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 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] MsS

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 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 Sub

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 077

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 tha

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 ( text not null..); -Original Message- From: Franco Breciano [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 2

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: [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 also

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 funct

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 [mailt

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 &

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

RE: [PHP] MSSQL

2001-05-14 Thread Brandon Orther
Can you specify the OS you are running this on and the version of PHP you are running. What it looks like is that the extension is not installed. Thanks, Brandon -Original Message- From: Andreas Pucko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 3:19 PM To: Php (E-mail) Subject

Re: [PHP] MSSQL

2001-05-14 Thread Markus Fischer
- Original Message - From: "Andreas Pucko" <[EMAIL PROTECTED]> To: "Php (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 12:19 AM Subject: [PHP] MSSQL > Hi there, > > while tying to connect to a MSSQL DB I get the error message: call to > undefined function. > > I thing my synt

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 avail

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 i

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 p

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 stri