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-
?php
ini_set( 'mssql.datetimeconvert', false );
$dbh
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
please remove me from this list
On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns toltma...@gmail.com 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
On Fri, Jun 24, 2011 at 16:07, Paul Wilson paulwilso...@gmail.com wrote:
please remove me from this list
Email php-db-unsubscr...@lists.php.net.
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
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
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 cant change the method of insert data in
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
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 have
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
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)
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
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
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
I cannot connect to my MSSQL server.
I use the following connection string:
php:
--
$connection = mssql_connect http://php.net/mssql_connect('server','user',
'password') or die ('server connection failed');
$database = mssql_select_db
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
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
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
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..
regards
Noel
--
PHP Database
Hello i have such problem
Executing this script
php code:
?php
session_start();
include ../msdb_conn.php;
$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 {
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
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
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
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(INSERT
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 have
$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:
$myVar =
Hi,
I hope someone can help me on this one. The following script:
?php
include(../includes/include.php);
$connect=new db_open(dnlbweb);
foreach($_POST as $key = $val) { $$key=$val; }
$res=mssql_query(SELECT Titel
FROM indeks
join indholdstyper on
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
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
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:
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
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
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]
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.
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
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
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
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
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
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
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
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
='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 MSSQL 2000 database:
SELECT Order_Details.Qref
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
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
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
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
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',
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
-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 on my webpage I
get this:
Globe and Mail data
-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 PROTECTED]
Sent: Monday, March
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
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
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
:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:18 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
]
mm.com cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MSSQL Text Length Restriction
12/10/2002
]
Subject: RE: [PHP-DB] MSSQL Text Length Restriction(Document link:
Jeff Dyke
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 the fields
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 at 10
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 on a
: 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 the server
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
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
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.);
:
Subject: RE: [PHP-DB] mssql select db
problem
10/14/2002 11:30
AM
]
10/14/2002 cc: 'Kadir Leblebici'
[EMAIL PROTECTED], [EMAIL PROTECTED]
11:32 AM Subject: RE: [PHP-DB] mssql select db
problem(Document link: Jeff
Dyke
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
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 (
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
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
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 February
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
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, If so
: [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
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
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
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
- [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
Subject: [PHP-DB] MSSQL
I just starting with mssql
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
]
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. If I echo it from PHP, I get May 13
2002 12:00AM. date() won't
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
: [PHP-DB] Mssql/Sybase errors
07:26 PM
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.
bWarning/b: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK
HINTS option. (severity 15) in myFile.php on line
: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.
bWarning/b: Sybase error: 'REQ' is not a recognized OPTIMIZER LOCK
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
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
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:
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
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,
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
I'm using PHP with PostgreSQL and now I need to use MSSQL...
what modifications I need to do !?
I already get php_mssql.dll and put it on /etc/php4/apache... is it
right !?
thanks
César
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Hello all,
I'm having a problem getting PHP to run a query against a MSSQL 7 database.
I have installed PHP, the MSSQL client tools and the php_mssql.dll all
according to the documentation.
PHP will connect to the database just fine. But if I send the query to
execute it will never return, no
Hi There ..
I used to be running php before on windows xp iis 5.1. Everything worked
fine.
It was installed by copying the php_mssql70.dll to the system folder and
uncommenting this in the php.ini file.
Now i have downloaded the new version and tryed to install it and get it
configured but im
Hi
I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:
?pup
$h = server adr;
$u = user;
$p = passw;
$b = db;
$connexion = mssql_connect($h, $u, $p);
mssql_select_db($b);
$sql = select * from test;
$result =
Hi
I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:
?php
$h = server adr;
$u = user;
$p = passw;
$b = db;
$connexion = mssql_connect($h, $u, $p);
mssql_select_db($b);
$sql = select * from test;
$result =
Hi Jerry,
You need to have the Client Tools for MS SQL Server installed on your PHP4 box. These
tools is found on the CD, or you can just copy ntwdblib.dll fom one system to another.
The default communication protocol will be netbios, if you want to change that to
tcp/ip you need to install
Hi there!
I'm baffled!!!
The extension code for mssql support resides on ext/mssql/php_mssql.*
The file EXTENSIONS states that it's working for both Unix and Windows 32.
There is no --with-mssql option on configure.
How am I suposed to get this working on Linux ???
Is it included in some other
Hello,
From the PHP site I read that I may use the Sybase libraries to connect to
a MS SQL server using PHP.
Then reading over the Sybase documentation I got lost.
Do I have to install/configure Sybase in order to compile PHP with sybase
support?
Or are there some basic libraries that I can
-Original Message-
From: Marcelo [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 3:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MSSQL 2000 and PHP on Linux..
Hello,
From the PHP site I read that I may use the Sybase libraries to
connect to
a MS SQL server using PHP
When we run an insert query in MS SQL Server we get the following
error 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.
On the following website we found this had to do something with the
NTEXT-type.
of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access Data Integration Technology Providers
-Original Message-
From: Hace [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 7:04 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MSSQL Error with MSSQL
1 - 100 of 135 matches
Mail list logo