[PHP-DB] mssql datetime weirdness

Hi, I am facing some weird results when querying a MSSQL 2008 server, giving me just plain wrong results like "2012-01-01 32747:02" (usage of "mssql_fetch_assoc" originates from the original code fragment): Here's what I do: CUT- \n"; } ini_set( 'mssql.datetimeconvert', true );

Re: [PHP-DB] MSsql madness

On Fri, Jun 24, 2011 at 16:07, Paul Wilson wrote: > please remove me from this list Email php-db-unsubscr...@lists.php.net. -- Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MSsql madness

please remove me from this list On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns wrote: > Hey php-dbers, > > I have a helper script that connects to an MSsql database to select > retailer > location information, which is then processed into mysql statements to be > inserted into another remote dat

[PHP-DB] MSsql madness

Hey php-dbers, I have a helper script that connects to an MSsql database to select retailer location information, which is then processed into mysql statements to be inserted into another remote database (this one MYsql). Currently it is ran manually from a windows system that was preconfigured (

[PHP-DB] MSSQL and ODBC Connections with PHP on Windows

Hi, I am a newbie using the combination of PHP and MSSQL together. Can anyone tell me which method it might be better as far as using PHP on Windows with MSSQL database on a single machine? (The PHP and MSSQL database are not set up remotely on two different servers. I have set up bot

[PHP-DB] mssql and latin characters

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: SQL_Latin1_General_CP1_CI_AS I can’t change the method of insert data in datab

Re: [PHP-DB] mssql connecting

I also use PHP/SQL Server, but my server is the IIS. To make the PHP to have access the SQL Server 2000 in the Windows 2003 server, you he will need to install SP 4 of the SQL Server. "David BERCOT" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] Hi, Le Wed, 23 May 2007 14:37:58

Re: [PHP-DB] mssql connecting

Hi, Le Wed, 23 May 2007 14:37:58 -0400, "Dan Shirah" <[EMAIL PROTECTED]> a écrit : > Did you already try these steps? > > http://us2.php.net/manual/en/function.mssql-connect.php#70918 Hum, these steps are for PHP on IIS (i.e. Windows) (even if, later, someone talks about Linux). The question (I

Re: [PHP-DB] mssql connecting

Did you already try these steps? http://us2.php.net/manual/en/function.mssql-connect.php#70918 On 5/23/07, Bryan <[EMAIL PROTECTED]> wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any

[PHP-DB] mssql connecting

I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any ideas? It just gives me the wonderful error: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified,

[PHP-DB] mssql and client encoding

Hi, how can I set client encoding on mssql connection? I can connect, but data are win1250 in db and web in utf8. SET NAMES do not work nor php.ini directive mssql.charset = "UTF-8" / "UTF8" WindowsXP Home/Pro Apache 2.2 PHP 5.2 (apache module) Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)

[PHP-DB] mssql Database name grater than 30 characters

It seems I'm not able to select a MS SQL database that has a name greater than 29 characters? Is their a work around for this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MSSQL 6.5 IIS6 PHP 5

I recently wrote a simple web script to execute a few queries against an old MS SQL 6.5 server. I developed the script on my XP box running IIS5 any user can run the script with out a problem. However when I moved it to the production box running IIS6 domain admins can run the script anyone else ge

[PHP-DB] MSSQL 6.5 IIS6 PHP 5

I recently wrote a simple web script to execute a few queries against an old MS SQL 6.5 server. I developed the script on my XP box running IIS5 any user can run the script with out a problem. However when I moved it to the production box running IIS6 domain admins can run the script anyone else ge

Re: [PHP-DB] MSSQL Server

I had some issues a couple years ago connecting to the MS SQL Server where I was employed at the time. I was probably just doing something wrong, but what I ended up using that worked for me was using the ADODB database abstraction layer. Helped me connect to MS SQL , Oracle and some other ra

[PHP-DB] MSSQL Server

I cannot connect to my MSSQL server. I use the following connection string: php: -- $connection = mssql_connect ('server','user', 'password') or die ('server connection failed'); $database = mssql_select_db

[PHP-DB] MSSQL PDO - Error!: could not find driver

Hello, I got "Error!: could not find driver" when using PDO to connect to MSSQL 2000 running on Windows 2003 server. I have recently installed Gentoo 2006 with Apache web server 2.0.55-r1, PHP 5.1.2, pecl-pdo 1.0.2, pecl-pdo-dblib 1.0, pecl-pdo-mysql 1.0.1, mysql 4.1.14, and freetds 0.62.3. When

RE: [PHP-DB] MSSQL Server Integration

Try the manual www.php.net/mssql From: "Noel Simela" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: [PHP-DB] MSSQL Server Integration Date: Sat, 13 Nov 2004 19:15:48 +0200 Hie guys, Does anyone have any idea how I can make my php pages to work with MS SQL Server.

[PHP-DB] MSSQL Server Integration

Hie guys, Does anyone have any idea how I can make my php pages to work with MS SQL Server.. regards Noel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MSSQL "FOR XML AUTO" php

HAHAHAHA i am so sorry this is so called problem infornt of computer. i didn't look in source of page and becouse of XML it isn't shown in page. Very sorry Thanks Bozhan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MSSQL "FOR XML AUTO" php

Thanks Robert but one thing i can't understand. As you can see in my first message freetds log contains such thing: -- 19:32:55.245996 tds_put_string converting 23 bytes of "exec GET_RESUME_AS_XML1" 19:32:5

Re: [PHP-DB] MSSQL "FOR XML AUTO" php

HI Bozhan When you append the "FOR XML" clause at the end of a query, the xml data will be sent in a single column result set. The column's type is ntext, which is not easily handled by FreeTDS and PHP. The reason is because it is UC2-2 encoded UNICODE text. UNICODE text is easier to deal with if

[PHP-DB] MSSQL "FOR XML AUTO" php

Hello i have such problem Executing this script php code: $stmt_page=mssql_init("GET_RESUME_AS_XML"); mssql_bind($stmt_page,"RETVAL",$returnval,SQLVARCHAR); $execute_stmt=mssql_execute($stmt_page); echo mssql_num_rows($execute_stmt); do { while ($row = mssql_fetch_array($execute_stmt))

Re: [PHP-DB] MSSQL INSERT query problem

Chris wrote: Here is the code I use: [snip] $sql =& $db->prepare("INSERT INTO ExitSurveyAnswers (session_id, Question_id, answer) VALUES ?,?,?"); [snip] When I execute it I keep recieving and error message stating: DB Error: syntax error Not a MSSQL expert, but shouldn't the ?,?,? in your query hav

[PHP-DB] MSSQL INSERT query problem

Here is the code I use: $dsn = "mssql://username:[EMAIL PROTECTED]/database"; $options = array( 'debug' => 2, 'portability' => DB_PORTABILITY_ALL, ); $db =& DB::connect($dsn, $options); if (DB::isError($db)) { $db->getDebugInfo(); die($db->getMessage()); } $sql =& $db->prepare("

Re: [PHP-DB] mssql insert

>$query = "INSERT INTO myTable VALUES ('".$myVar."');'; Check the commas? Miles At 05:50 PM 3/28/2004 +1200, Martin Ryan wrote: Got a dumb-ass question for you all. I have got insert queries working with mssql_query($query); except if any of the variables have two or more words. For example: $myVa

[PHP-DB] mssql insert

Got a dumb-ass question for you all. I have got insert queries working with mssql_query($query); except if any of the variables have two or more words. For example: $myVar = "Two or more words"; $query = "INSERT INTO myTable VALUES ('".$myVar."');'; mssql_query($query,$db); The query will only in

[PHP-DB] Mssql - Invalid Column Name

Hi, I hope someone can help me on this one. The following script: $val) { $$key=$val; } $res=mssql_query("SELECT Titel FROM indeks join indholdstyper on indholdstyper.id=indholdstypeid WHERE Titel='$titel' AND indholdstyper.DataTypeID=$dt")

Re: [PHP-DB] mssql query

SELECT count(id) FROM users WHERE DATEDIFF(eventtime,GETDATE(),d) == 1; Or something along those lines, all the date functions are very well documented in the "digital books" that come with Enterprise Manager. Open up the reference, and search for datediff, and there should be a link in there for

[PHP-DB] mssql query

I've used mysql a little, but now I'm working with a MS SQL SERVER 2000 database. We have a proprietary application/hardware setup where when a person enters the building, the time they enter the building is automatically put into the database in a field called eventtime, and their access card

Re: [PHP-DB] MSSQL stability problem

I confirm, I run IIS with php 4.3.2 in Fastcgi with IIS since several months without any problem. -- Thierry Bothorel (Tobias Schlitt) "Frank M. Kromann" <[EMAIL PROTECTED]> a écrit dans le message de news: [EMAIL PROTECTED] > I'm guessing that you are using PHP as ISAPI or Apache module and that

Re: [PHP-DB] MSSQL stability problem

I'm guessing that you are using PHP as ISAPI or Apache module and that might not always work with the MSSQL extension. The library (ntwdblib.dll from Microsoft) used for this extension is not thread safe. If you switch to CGI or FastCGI you will not have these problems. - Frank > Stuart wrote: >

Re: [PHP-DB] MSSQL stability problem

Stuart wrote: Robert Twitty wrote: Maybe you are running out of connections. The max connections settings in both php.ini and SQL Server are set to unlimited. Is there another limit I am not aware of? I am now closing the connection to MSSQL at the end of every page and it still does it. I've re

Re: [PHP-DB] MSSQL stability problem

Robert Twitty wrote: Maybe you are running out of connections. The max connections settings in both php.ini and SQL Server are set to unlimited. Is there another limit I am not aware of? -- Stuart On Wed, 21 Jan 2004, Stuart wrote: I have a site that makes heavy use of a local SQL Server databa

Re: [PHP-DB] MSSQL stability problem

Maybe you are running out of connections. -- bob On Wed, 21 Jan 2004, Stuart wrote: > I have a site that makes heavy use of a local SQL Server database. Every > 6-12 hours the site continuously reports not being able to connect to > the database. That is the only info in the warning that's given

[PHP-DB] MSSQL stability problem

I have a site that makes heavy use of a local SQL Server database. Every 6-12 hours the site continuously reports not being able to connect to the database. That is the only info in the warning that's given. The only solution I've found is to restart the Apache and MSSQL services. The [MSSQL] s

Re: [PHP-DB] mssql and resource handling

Michael, Don't store resources in your session. They die when the page is finished rendering. Variables you can store in your session. Even objects can be stored in your session. But do not store resources. I would suggest a couple of things. 1: Use ADOdb instead of just raw my_sql statements.

[PHP-DB] mssql and resource handling

I have a fairly common problem that I have not been able to find the solution for in the documentation and FAQs. I have to access a MSSQL box from a LAMP box using PHP. That part works fine (thank you freetds.org). I need to display results from user queries 10 at a time with the basic NEXT and BAC

[PHP-DB] MSSQL Error message

Hi I´m using a connection using php 4.3.3 with sql server ... and i´m having a error message : mssql error: [: Connection error to server '192.0.0.6\binotto' with user 'LUA'] .. The user 'LUA' is the dbowner ... anyone can help me??? Sorry my bad english ... Liana Cristine Leopold

[PHP-DB] MSSQL Problem

Hello everyone I have a strange problem with MSSQL Server 2000 and PHP 4.3.3 on a Windows XP machine with IIS. Sometimes, my script connects to the SQL Server, he said he couldn't connect, but if I reload the page, eveything is fine I can't see any schema in this fault, sometimes it works a

[PHP-DB] MSSQL connection seems abandoned

Using PHP 4.3.1 MSSQL 7.0 Executing a Stored Procedure through the function mssql_query that returns a message of: "DELETE statement conflicted with COLUMN REFERENCE constraint... The statement has been terminated." causes the link to be unusable in executing function mssql_query again. Sql Ser

[PHP-DB] mssql and Apache 1.3.28 and Win2k

I'm not shure that's a pure PHP bug, the problem only occur since I've ugraded Apache to 1.3.28. All SQL queries containing tables or column names containing special chars (ie: e) fails with the following PHP error message : "mssql_query(): message: Invalid object name 'Negociateurs'. (severity

Re: [PHP-DB] mssql and Apache 1.3.28 and Win2k

th Outlook Express, causing a failure to answer...) Stick to standards. EQCA Ignatius _ - Original Message - From: "EKSTEIN, Clément @ Paris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 06, 2003 11:46 AM Subject: [PHP-DB

[PHP-DB] MSSQL date format problem

hi, I have seen solution for my problem, but I couldn't find and I'm in a hurry - please help. Problem is, how to set default datetime format while using mssql functions? With ODBC, there is format: -mm-dd hh:mm:ss[.fff] but wih using db-library there is: mmm dd hh:mmxx where xx i

Re: [PHP-DB] MSSQL VIRTUAL TABLES

r.AgentRef ='48976' HTH Mustafa - Original Message - From: "LOUD, Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 10:29 AM Subject: [PHP-DB] MSSQL VIRTUAL TABLES > Hi, > > I am trying to do the following query in a

[PHP-DB] MSSQL VIRTUAL TABLES

Hi, I am trying to do the following query in a MSSQL 2000 database: SELECT Order_Details.Qref, Order_Header.AgentRef FROM Order_Details, Order_Header WHERE Order_Details.Qref = Order_Header.Qref AND Order_Header.AgentRef = 48976 I get the following error: Syntax error converting the varchar val

[PHP-DB] mssql and dts

Hi everyone! I am looking for a way to use MSSQL Data Transformation Services (DTS) via PHP. Could anyone give some help on getting started? Or some tips on where to find some manuals? Any help would be greatly appreciated. Thanks for your help in advance! Best regards, Sven -- PHP Database

Re: [PHP-DB] MSSQL Procedures

Hi, The easy way is to use the mssql functions in PHP. You can see how to configure PHP with these in the online manual: http://www.php.net/mssql. You need to download and install FreeTDS (http://freetds.org). You can also use the online manual to get samples on how to execute stored procedures a

[PHP-DB] MSSQL Procedures

Jeson Hi , this is Nabil from PHP list, i wonder if u could help with the following: I have a stored procedure on a remote Microsoft (stupid) SQL server.. and I have to connect to it remotely and I have only permission to execute those specific procedure , and I only got the returned value... My

Re: [PHP-DB] MSSQL Optimize?

Mssql server has a list of tools you can use for this. When you create the database (or later modify it through Enterprice Manager) you can specify 'Auto Shrink'. This will make sure the file sise is optimized when you delete data. This cal also be done with this call: sp_dboption('database', 'au

[PHP-DB] MSSQL Optimize?

Please forgive me for being somewhat off topic. This information is going towards a db class written in php. Does MSSQL have an SQL command counterpart to mysql's Optimize or postgresql's Vacuum?? Thanks for any insight you may provide... -- PHP Database Mailing List (http://www.php.net/) To unsu

RE: [PHP-DB] MSSQL/PHP problem

s a lot Kelvin -Original Message- From: Roedel, Mark [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 2:27 PM To: Poon, Kelvin (Infomart); [EMAIL PROTECTED] Subject: RE: [PHP-DB] MSSQL/PHP problem > -Original Message- > From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTE

RE: [PHP-DB] MSSQL/PHP problem

> -Original Message- > From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 9:13 AM > To: '[EMAIL PROTECTED]' > Subject: [PHP-DB] MSSQL/PHP problem > > > [snip] > > WHen I retrieve this data from php to display

[PHP-DB] MSSQL/PHP problem

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

[PHP-DB] MSSQL, Linux and Binaries

Hello, we have stored Images in MS SQL 7 - Database. With freetds we can read all Information - but on Binaries (Images) we became wrong informations. If we store the Data in a File, the Filesize is (as example) 34 kbyte. The original filesize are 17 kbye. what can we do to convert the informa

[PHP-DB] MSSQL + PHP incredibly slow

We've been using PHP hosted on a win32 machine to connect to SQL Server 2000. When the PHP host and the MSSQL host are the same machine, everything is fine. But when we try to use seperate hosts for PHP and MSSQL, query times become unbearably slow. The odd thing is that I can run the same scrip

Re: [PHP-DB] MSSQL Problems

Looks like this groups saves the day again. "John Krewson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > mssql_pconnect cannot be closed as you mentioned: > http://www.php.he.net/manual/en/function.mssql-pconnect.php > > I am using this as well, calling MSSQL

RE: [PHP-DB] MSSQL Text Length Restriction

ODBC instead? Rich -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 16:01 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MSSQL Text Length Restriction Uncommented, and set to the max value (2147483647). No effect. On Tue, 2002-12-10

RE: [PHP-DB] MSSQL Text Length Restriction

ODBC instead? Rich -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 15:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL Text Length Restriction I can't seem to get more then 255 characters to be sent back from a field in our MSSQL database, unless

RE: [PHP-DB] MSSQL Text Length Restriction

<[EMAIL PROTECTED]> Subject: RE: [PHP-DB] MSSQL Text Length Restriction(Document link:

RE: [PHP-DB] MSSQL Text Length Restriction

<[EMAIL PROTECTED]> Subject: RE: [PHP-DB] MSSQL Text Length Restriction(Document link:

RE: [PHP-DB] MSSQL Text Length Restriction

t; cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MSSQL Text Length Restriction

RE: [PHP-DB] MSSQL Text Length Restriction

Adam Voigt mm.com> cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MSSQL Text Length

RE: [PHP-DB] MSSQL Text Length Restriction

they don't look too terribly inefficient. -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:18 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL Text L

RE: [PHP-DB] MSSQL Text Length Restriction

AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL Text Length Restriction I can't seem to get more then 255 characters to be sent back from a field in our MSSQL database, unless the fields is a "TEXT" type, which is very inefficient. Anyone know a fix? (I've already tri

[PHP-DB] MSSQL Text Length Restriction

I can't seem to get more then 255 characters to be sent back from a field in our MSSQL database, unless the fields is a "TEXT" type, which is very inefficient. Anyone know a fix? (I've already tried modifying the max size variables in the php.ini under the MSSQL section.) -- Adam Voigt

Re: [PHP-DB] MSSQL Problems

Take a look at the documentation at http://www.php.net/manual/en/function.mssql-close.php whhere it says "mssql_close() will not close persistent links generated by mssql_pconnect()". connections created by mssql_pconnect() will only be closed when the PHP process terminates. - Frank > I've writ

Re: [PHP-DB] MSSQL Problems

mssql_pconnect cannot be closed as you mentioned: http://www.php.he.net/manual/en/function.mssql-pconnect.php I am using this as well, calling MSSQL on a Windows box from PHP/Apache on Linux, and I am also getting some of the results you mentioned, although it behaves differently at different ti

RE: [PHP-DB] MSSQL Problems

Sent: 05 December 2002 13:33 To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL Problems I've written a script that works perfectly for almost ten times, and then stops being able to connect to the MSSQL server. I imagine this has something to do with me not properly closing my connection, and

[PHP-DB] MSSQL Problems

I've written a script that works perfectly for almost ten times, and then stops being able to connect to the MSSQL server. I imagine this has something to do with me not properly closing my connection, and the server having a maximum # of connections. I'm calling both mssql_free_result() and mssq

RE: [PHP-DB] mssql select db problem

ROTECTED]> 10/14/2002 cc: "'Kadir Leblebici'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 11:32 AM Subject: RE: [PHP-DB] mssql select db problem(Document link: Jeff

RE: [PHP-DB] mssql select db problem

W. Holmes" , <[EMAIL PROTECTED]> arter.net> cc: Subject: RE: [PHP-DB]

RE: [PHP-DB] mssql select db problem

Rename your database. Either PHP or MSSQL doesn't like the '-' in the name. ---John Holmes... > -Original Message- > From: Kadir Leblebici [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 14, 2002 4:36 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] m

[PHP-DB] mssql select db problem

Hi friends I have big problem I connect to mssql server I connected succesful but i select_db samples code is here $hostname = "192.168.100.4"; $username = "sa"; $password = ""; $dbName ="WIN-PAK 2"; MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND."); mssql_selec

[PHP-DB] MSSQL error

I am getting problems with MSSql when using DB.php, I have an intermitant fualt where php keeps gives me a CGI "The specified CGI application misbehaved by not returning a complete set of HTTP headers" (you know the one), but when the page is refreshed it all works fine. I have a felling that it

[PHP-DB] mssql: insert a record and return the auto increment ID

I insert a new record with PHP into my MS SQL Server database. The key is defined with auto_idINT IDENTITY(1000,1) NOT NULL, how do I get the new id to use it in PHP? To insert the record I use this code: $sSql = "INSERT INTO myTable (time_in ) VALUES ( getdat

[PHP-DB] MSSQL Version

I just found out today that I could find out mysql or postgresql version # using an sql select statement. 'select version() as version' It doesn't work for MSSQL. Does anyone know of a way to retrieve MSSQL's version via php or sql statement. Thanks. -- Gerard Samuel http://www.trini0.org:81

Re: [PHP-DB] MSSQL functions vs. ODBC functions

CTED]] > Sent: Thursday, July 11, 2002 10:14 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] MSSQL functions vs. ODBC functions > > I am not sure if this question has been asked before, If so sorry for > asking > again. > > I have a site that the Client is moving from

RE: [PHP-DB] MSSQL functions vs. ODBC functions

Universal Data Access & Virtuoso Universal Server -Original Message- From: Mark McCulligh [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 10:14 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL functions vs. ODBC functions I am not sure if this question has been asked before

[PHP-DB] MSSQL Warnings

Whenenver I get a DB error with MSSQL just about every other mssql_query statement begins producing warnings until I restart IIS. Once I restart IIS everything runs fine again. Has anyone else had this problem? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] mssql datetime field

Hi, there exists a workaround in php for this problem. Just put in your php.ini: mssql.datetimeconvert = 0 or in your script: ini_set('mssql.datetimeconvert' , 0); this causes date values in this format: -MM-DD HH24:MI:SS if it doesen't work correctly, the upgrade to php4.2.1 bye, [EMAIL

Re: [PHP-DB] mssql datetime field

Could you give an example of what you are sending in as the date value in an Insert/Update? Adam Voigt [EMAIL PROTECTED] On Thu, 2002-07-25 at 08:45, [EMAIL PROTECTED] wrote: > > has anyone had any expierence with the datetime field coming back from > MSSQL as someting along the lines of Februa

[PHP-DB] mssql datetime field

has anyone had any expierence with the datetime field coming back from MSSQL as someting along the lines of February 3, 2036 6:36AM. This happens to me no matter the time in the database. PHP inserts it correctly, but the select has a problem. I am using php4.1.2 and SqlServer 7.0. Or is anyo

[PHP-DB] MSSQL and NT

Hi all! I went after my problem with the NT authentification and I found out, that if you want to make a NT-based Authentification (f.ex for an ODBC-Connection) the I_USR will be seen as the actual user... I granted then rights to the I_USR in the DB, but this way, I cannot distinguish which use

[PHP-DB] MSSQL, PHP, Linux, and FreeTDS???

Can someone please give me any kind of advice on what it is I need to do in order to configure a Linux box to talk to a MSSQL 2000 box. I have found various sets of directions, none of which resemble each other, and none of which work. I would greatly appreciate if any one could lend me a hand w

[PHP-DB] MSSQL functions vs. ODBC functions

I am not sure if this question has been asked before, If so sorry for asking again. I have a site that the Client is moving from a MySQL db to Microsoft SQL Server. Is it better to setup an ODBC connection to SQL Server and use the ODBC functions OR to use the MSSQL functions. If I have the choi

Re: [PHP-DB] MSSQL

Fong - [EMAIL PROTECTED] Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 714.315.8954| Wireless E-mail: - Original Message - From: "Gerard Samuel" <[EMAIL PROTECTED]> To: "php-db" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 1:07 PM Subjec

[PHP-DB] MSSQL

I just starting with mssql coming from a mysql background. Im looking for tutorials and such on how to get scripts working with php. The server is IIS 5 with php 4.2.1 and mssql 2000. phpinfo() shows that mssql is recognised. Im not sure if I have to jump through hoops like how I did when I firs

Re: [PHP-DB] MSSQL DateTime field formatting?

Hi, get the latest PHP4 and set set php.ini-param mssql.datetimeconvert to Off the the MSSQL-Module then returns datetime-values in this format: -MM-DD HH24:MI:SS bye, Benjamin Walling wrote: > I can't seem to find a way to format the field that comes back from my > DateTime fields in MS

RE: [PHP-DB] MSSQL DateTime field formatting?

uesday, May 14, 2002 2:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL DateTime field formatting? I can't seem to find a way to format the field that comes back from my DateTime fields in MSSQL Server. For example, '2002-05-13' shows in Query Analyzer as 2002-05-13 00:00:00.000. I

[PHP-DB] MSSQL DateTime field formatting?

I can't seem to find a way to format the field that comes back from my DateTime fields in MSSQL Server. For example, '2002-05-13' shows in Query Analyzer as 2002-05-13 00:00:00.000. If I echo it from PHP, I get May 13 2002 12:00AM. date() won't take it. strftime() won't take it. What do I nee

Re: [PHP-DB] Mssql/Sybase errors

TED]> cc: 04/25/2002 Subject: Re: [PHP-DB] Mssql/Sybase errors 07

Re: [PHP-DB] Mssql/Sybase errors

ED]> Sent: Thursday, April 25, 2002 10:18 AM Subject: [PHP-DB] Mssql/Sybase errors > Hello. > > I have recently installed the freetds package and reconfigured PHP to > connect to MSSQL. I am running a simple join query on two tables and I get > the following error. > Warning:

[PHP-DB] Mssql/Sybase errors

Hello. I have recently installed the freetds package and reconfigured PHP to connect to MSSQL. I am running a simple join query on two tables and I get the following error. Warning: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK HINTS option. (severity 15) in myFile.php on line 29 RE

[PHP-DB] mssql problems

Dear All, I hope somebody can help me. I am new to PHP (I've used ASP for three years:-( ) and I'm loving PHP and trying to get my work to convert but I've coming across a error with mssql_query() explorer its just crashes with a php.exe 'memory could not be read error'. I'm sure it a school boy e

[PHP-DB] mssql cursor fetching

Is it possible to fetch the scroll cursor from microsoft sql server 2000 to the PHP installed at Linux box? I tried even enclosing the cursor to the stored procedure with no effect. My setup is: apache 1.3.19, mod_php 4.0.6, freetds 0.53 without configuration, glibc 2.2.4, kernel 2.4.17 Thanks a l

[PHP-DB] MSSQL and cyrilic symbols ...

I have this problem mssql_query - returns DOS format strings and this changes my cyrilic data result from text fields. with mysql_query - no prolem (on MySQL DB of cource) -- Nikolay Todorov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Mssql trusted connections ?

How does one use trusted connections with mssql_connect() ? Also, the manual says something about an "interfaces" file. Where do I find this? Where is this interfaces file documented? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MSSQL: PHP fails to connect

Hello community! After reinstalling our Active Directory domain from scratch, PHP 4.0.6 does no longer connect to MS SQL Server 2000 by mssql_connect(). PHP itself resides on our master DC (W2K Small Business Server, 192.168.1.1), while the SQL Server is installed on the 2nd DC (W2K Server, 192

[PHP-DB] MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent

Getting this error: Warning: MS SQL message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in C:\webroot\test.php on line 13 Warning: MS SQL: Query failed in C:\webroot\test.php on

  1   2   >