Hi Ollie,

Thank you for your reply.

I was mistaken.  I am using PHP 4.1.1 loaded as a CGI.  I am using Apache
because I am from a Solaris/Linux background, and I know how to use it
better.  I don't feel comfortable enough with IIS to secure it down (with
all that NIMDA and CodeRed floating around).  Our company is going to
implement SQL Server 2000, so I want to try it out.

I used the sample PHP script from PHP's Web site to connect.  Here is the
code:

<?php

$hostname = "localhost";
$username = "username";
$password = "password";
$dbName = "Northwind";

MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO
RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");

$query = "SELECT * FROM Employees";

$result = MSSQL_QUERY($query);

$number = MSSQL_NUM_ROWS($result);

$i=0;

if ($number == 0) :
 print "No data?";
elseif ($number > 0) :
 print "Data:";
 while ($i < $number) :
  $name = mssql_result($result,$i,"Name");
  print $name;
  print "";
  $i++;
 endwhile;
endif;
?>


I modified it to grab information from Northwind's Employee table.

I didn't know Unicode was something that was defined.  I will try to make a
sample database with 'more simple' database fields to see if that works.  I
just wanted to do a quick test to grab data.  I see it'll take me a little
longer to learn MSSQL.

Thanks!


william


--
William Fong - [EMAIL PROTECTED]
Phone: 626.968.6424 x210  |  Fax: 626.968.6877
Wireless #: 805.490.7732    |  Wireless E-mail: [EMAIL PROTECTED]




----- Original Message -----
From: "Oliver Cronk" <[EMAIL PROTECTED]>
To: "Php-Db ML" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 3:19 PM
Subject: [PHP-DB] Re: MSSQL Query - Unicode data in a Unicode-only collation
or ntext data cannot be sent


> Hi there,
>
> PHP4.0.6 on IIS / Windows 2000 works fine with SQL Server 2000 (I have
teste
> this quite throughly) I don't know about unicode fields however as I
don't/
> haven't used them in any of my databases.  I know that varchar fields have
a
> few issues (can't retrieve more that 255 characters, you have to use text
> fields instead - which aren't queryable).
>
> What are you using to connect to MS-SQL? The MSSQL PHP library functions I
> hope (NOT ODBC its much slower IMO).  Why are you using Apache on Win32
may
> I ask(is it for apache functionality you can't get with IIS?)?
>
> Whats the query that you are sending in your test.php script?
>
> Cheers
>
> Ollie
>
> <[EMAIL PROTECTED]> wrote in message
> news:<[EMAIL PROTECTED]>...
> > 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 line 13
> >
> > Warning: Supplied argument is not a valid MS SQL-result resource in
> C:\webroot\test.php on line 15
> >
> > ---
> >
> > Using Windows 2000 Server with Apache 1.3.23 and PHP4.0 with SQL Server
> 2000.  Any ideas?  PHP's site didn't mention anything about SQL Server
2000.
> >
> > Thanks!
> >
> > will
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to