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

[PHP] MSSQL Stored Proc

2012-08-28 Thread Phillip Baker
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 database at '.$server); } else { $storedproc = "SP_DialerVa

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 >

[PHP] MSSQL failing.

2010-07-08 Thread Paul Halliday
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 auth is turned off) so the communication is somewhat working.

[PHP] mssql extension

2008-06-09 Thread Mathieu Pelletier
Hello ! My Workstation/server: Window XPApache 2.2.4 (win32) PHP/5.2.3SQl Server 2003 I have never been able to load mssql extension in my life...In my php .ini file, I removed the ; correctly : extension=php_mssql.dll Other extensions work fine, for example I use the PDF extension : exte

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
use to get the data is: > > > mssql_connect('server','user','pass'); > > mssql_select_db('db'); > > > > $r = mssql_query("select some_column from some_table"); > > $d = mssql_fetch_assoc($r); > > > > echo $d[&#

[PHP] mssql and latin characters

2008-01-20 Thread Leticia Larrosa
the data appears with weird characters. The code I use to get the data is: My PHP is 4.4.3, and my SO is XP. Other people ask the same as I’m and get no answer proper are: <http://www.psicofxp.com/forums/desarrollo-web.264/226703-php-mssql-y-acento s.html> http://www.psicof

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
no problem once you have managed mssql. It talks to sql server 2005/2000 quite well. Regards, Shelley -Original Message- From: Alexis [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 6:07 AM To: php-general@lists.php.net Subject: [PHP] MSSQL Hi, I am pulling my hair out try

[PHP] MSSQL

2008-01-08 Thread Alexis
Hi, 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 2.2 and PHP 5.2.3 Ideally I would like to get

Re: [PHP] Size Limit PHP + MSSQL

2007-02-23 Thread Frank M. Kromann
There are two settings in php.ini mssql.textsize and mssql.textlimit. When tese are set to -1 (default) the values used are configured on the server and is usually 4k. - Frank > Is there size limit for select queries in php? > > I am trying to grab a very long string that exists in the database.

[PHP] Size Limit PHP + MSSQL

2007-02-23 Thread Liz Kim
Is there size limit for select queries in php? I am trying to grab a very long string that exists in the database. When I do a select and print it out, php keep truncating the string - only outputing the first half or so when the string is too long. I have checked the actual database and the stri

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

[PHP] mssql conflict with sybase...

2006-12-01 Thread Le Phuoc Canh
Dear all, 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. Please help me... Thanks & Best Regard

[PHP] MSSQL Server 2005

2006-04-03 Thread Mike Smith
I am currently working on a project using SQL Server 2000. I don't think there would be a big advantage to switching to sql server 2005 for this project, but is anyone using 2005 (or one of the Express versions) with PHP? Looks like it only uses the "native client"? -- Thanks, Mike Smith -- PHP G

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]

[PHP] mssql 20020429

2005-08-15 Thread Daniel Baughman
Hey guys, I'm looking for the php_mssql.dll with api version: 20020429 Does anyone know where I can translate that to a version release in order to find the release with that version dll or something? Or have a resource for finding modules based on API version? Regards, Dan -- PHP General M

[PHP] mssql and paging

2005-01-26 Thread Zouari Fourat
Hello Is there anybody who succed in doing per/page listing from a MS SQL Server db. knowing that mssql doesnt support LIMIT like mysql and it uses TOP. i didnt find an optimized way to make a per/page script. Here's what am doing know : to replace a MySQL "SELECT FROM LIMIT $x,$y" i did

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] Mssql Connection

2005-01-19 Thread Pablo D Marotta
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 it work, it always th

RE: [PHP] PHP + MSSQL win32 / SOLVED

2005-01-13 Thread Vincent DUPONT
: mercredi 12 janvier 2005 21:54 To: php-general@lists.php.net Subject: [PHP] PHP + MSSQL win32 Hi I try to use PHP with MSSQL on a WINXP station. Usually, on win32 systems this works very well, but today I can't understand the problem. I can connect and execute SELECT statements When

[PHP] PHP + MSSQL win32

2005-01-12 Thread Vincent DUPONT
Hi I try to use PHP with MSSQL on a WINXP station. Usually, on win32 systems this works very well, but today I can't understand the problem. I can connect and execute SELECT statements When I try to INSERT , DELETE or UPDATE a record, I have a PHP ERROR, and a MSSQL error "code 15457" in

Re: [PHP] PHP + MSSQL Problem

2004-12-20 Thread Richard Lynch
Alaor Barroso wrote: > I changed the php.ini and enabled the support for > MSSQL and now i can connect without errors, BUT when > make an query to an table the query return NO MATCHES, > i have sure that the SQL line is correct (i already > used it on(or in? i don't know the difference =P) > other

[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

[PHP] PHP + MSSQL Problem

2004-12-18 Thread Alaor Barroso
Hello guyz, sorry my bad english, im brazilian and i'll try to write in english... I use actually PHP 5.02 with MySQL in my site, but now i have to access an external server that use MS SQL Server running at windows 2000 server edition, firtly i tried to connect and it fails, because i don't have

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
, 2004 1:19 PM > To: [EMAIL PROTECTED] > Subject: [PHP] MSSQL, PHP and Linux > > 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

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

[PHP] MSSQL, PHP and Linux

2004-09-01 Thread 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 SQL Server under dbx yet I still get the errors "called to undefined function mss

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

[PHP] MSSQL stored proc

2004-04-13 Thread Aris Santillan
hi everyone can you give me a sample code of using MSSQL stored procedures? and its explanation.. thanks

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

[PHP] php/mssql character limit?

2004-03-05 Thread Ben Ramsey
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)? -- Regards, Ben Ramsey http://benramsey.com http://www.phpcommunity.org/wiki/People/BenRamsey

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

[PHP] MSSQL connection

2004-01-22 Thread Alex Hogan
Hi All, I have a question about connecting to a MSSQL back end. I keep getting the error that the php_mssql.dll wont load because it isn't present. >From what I can see so far is that php needs to be compiled with that extension uncommented in order to get the dll. Is that correct?

Re: [PHP] [PHP - MSSQL]: Problem with mssql_connect

2003-09-18 Thread Ongart Wongsanupa
; > > "Ongart Wongsanupa" <[EMAIL PROTECTED]> > 09/18/2003 04:25 PM > > To: [EMAIL PROTECTED] > cc: > Subject:[PHP] [PHP - MSSQL]: Problem with mssql_connect > > > > Please help!... > I have to use 'apache+php

Re: [PHP] [PHP - MSSQL]: Problem with mssql_connect

2003-09-18 Thread Larry_Li
Change MS SQL SERVER Authentication's type to SQL Server and Windows instead of windows only. "Ongart Wongsanupa" <[EMAIL PROTECTED]> 09/18/2003 04:25 PM To: [EMAIL PROTECTED] cc: Subject: [PHP] [PHP - MSSQL]: Problem with mss

[PHP] [PHP - MSSQL]: Problem with mssql_connect

2003-09-18 Thread Ongart Wongsanupa
Please help!... I have to use 'apache+php' connect to MSSQL Server 2000 in Windows Server 2003, but there are problem. Computer A: Windows Server 2003 Enterprise, MSSQL Server 2000 Enterprise, Computer B: Windows XP Professional, Apache, php ( Web Server ) Computer A <-- network -> Compu

Re: [PHP] PHP & MSSQL Images

2003-08-14 Thread Curt Zirzow
* Thus wrote [EMAIL PROTECTED] ([EMAIL PROTECTED]): > ... > > The following is the tag inserted to my webpage: > > View the source of this image to see if any php errors are being displayed. Curt -- "I used to think I was indecisive, but now I'm not so sure." -- PHP General Mailing List (

[PHP] PHP & MSSQL Images

2003-08-12 Thread Chris . Jones
Hey .. I am having a problem when i try to pull an image that has been stored in MS SQL Server from displaying properly. I know, its a waste of space to store the actual image in SQL, but this is the way it needs to be done to be compatible with some of the other systems. Anyway, if you have

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

[PHP] MSSQL connection

2003-06-17 Thread Wim Paulussen
LS, I am trying to get a connection to a remote MSSQL server. This is what I found in the online manual : mssql_connect() establishes a connection to a MS SQL server. The servername argument has to be a valid servername that is defined in the 'interfaces' file. This is the command given : $test

[PHP] Mssql error after upgrading to 4.3.2

2003-06-11 Thread Javier
Hi, yesterday I upgraded to php 4.3.2 from 4.3.1 with the freebsd ports. There were any problems on the process, but many of the pages I had running with mssql, now doesn't work. These are the errors I get: Warning: mssql_num_rows(): supplied argument is not a valid Sybase result resource in xx

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

[PHP] MSSQL - Previous/Next Paging Results

2003-06-10 Thread Craig
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? Any insight appreciated. Craig -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

[PHP] MSSQL using Sybase FreeTDS

2003-04-03 Thread Craig
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:

[PHP] MSSQL/PHP Problem

2003-03-31 Thread Poon, Kelvin (Infomart)
Hi, I have this problem retrieving data from a mssql table with PHP. I have this in my mssql table column: Globe and Mail data are retrieved and processed for CustomSearch. On the R30, the crontab entry: 0 4 * * 1-6 /usr1/applic/ntgm/ntgm_get.pl will run the Perl script at 4 a.m. everyday to

RE: [PHP] PERL/PHP, MSSQL, Unix AIX

2003-03-11 Thread Adam Voigt
? Kelvin -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 1:35 AM To: Poon, Kelvin (Infomart) Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP] PERL/PHP, MSSQL

RE: [PHP] PERL/PHP, MSSQL, Unix AIX

2003-03-11 Thread Poon, Kelvin (Infomart)
: Re: [PHP] PERL/PHP, MSSQL, Unix AIX Hi Kelvin, You can use both PERL and PHP (prefered :-)). You need to download, compile and install FreeTDS (http://freetds.org). If you are using PHP you need to recompile it using --with-mssql. This will enable the mssql extension. You can then create a php

Re: [PHP] PERL/PHP, MSSQL, Unix AIX

2003-03-09 Thread Frank M. Kromann
Hi Kelvin, You can use both PERL and PHP (prefered :-)). You need to download, compile and install FreeTDS (http://freetds.org). If you are using PHP you need to recompile it using --with-mssql. This will enable the mssql extension. You can then create a php script to read the text file, parse it

Re: [PHP] PERL/PHP, MSSQL, Unix AIX

2003-03-09 Thread Frank M. Kromann
Hi Kelvin, You can use both PERL and PHP (prefered :-)). You need to download, compile and install FreeTDS (http://freetds.org). If you are using PHP you need to recompile it using --with-mssql. This will enable the mssql extension. You can then create a php script to read the text file, parse it

[PHP] PERL/PHP, MSSQL, Unix AIX

2003-03-07 Thread Poon, Kelvin (Infomart)
Hi, I got a little project and I need to come up with a solution on how to finish it and was hoping if you guys can give me any ideas. I have a PERL script on a Unix AIX machine that checks for incoming update of data. Specificly what it does is, when it runs, it will look at the corresponding d

[PHP] MSSQL Stored procedure return values

2003-02-22 Thread Leo Spalteholz
Hi, I'm doing a small project at work with php, ms sql server on w2k IIS5. All the data access is done through stored procedures. This seems to be working fine, the record sets are returned and the stored procedures execute without error however I can't get any return values from them. For

[PHP] mssql functions

2003-01-04 Thread Duncan
Hi, i need the php mssql functions, but php is not configured --with-mssql on my server. What options do i have to enable this? I mean, if i need the mssql-functions, does the client (as stated in the php manual) have to be installed, or can i use s.th. dynamical and load it at runtime? S.o

[PHP] MsSQL connection !!! HELP !

2002-07-16 Thread Djurovski Dejan
I can't connect to mssql! When I start PHP page with MsSQL connection, PHP craches and I receive this: PHP caused an invalid page fault in module NTWDBLIB.DLL at 0167:73330fde. Registers: EAX=0020 CS=0167 EIP=73330fde EFLGS=00010246 EBX=0010 SS=016f ESP=0063f600 EBP=0063f610 ECX=00797fe0

RE: [PHP] MSSQL and NT

2002-07-15 Thread John Holmes
h variables are available. ---John Holmes... > -Original Message- > From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 15, 2002 8:39 AM > To: [EMAIL PROTECTED] > Subject: [PHP] MSSQL and NT > > Hi all! > > > I went after my problem with the

[PHP] MSSQL and NT

2002-07-15 Thread Gabor Niederlaender
user is actually working in the DB. IS there a way to use NT-Authentification in connection with php & MSSQL ??? Please Help, Gabor -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] MSSQL - Authentification ?????

2002-07-15 Thread Gabor Niederlaender
Hi All! Is there a way to build up the connection to a MSSQL Database if the Authentification is set to Windows-Authentification and not SQL-Authentification? Greetings, Gabor -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] MSSQL - Authentification ?????

2002-07-15 Thread Gabor Niederlaender
Hi All! Is there a way to build up the connection to a MSSQL Database if the Authentification is set to Windows-Authentification and not SQL-Authentification? Greetings, Gabor -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

[PHP] MSSQL/PHP Query Help

2002-06-12 Thread Michael
Hey guys... I'm currently using PHP, FreeTDS, and Sybase libraries to access a database on an MS SQL 2000 server. Things are going fine, except for my more complex queries. Here is an example: SELECT Servers.Name, Nics.MAC FROM Servers INNER JOIN Nics ON Servers.ServerId = Nics.Server WHERE ((

  1   2   >