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]
