[PHP-DB] ODBC with SQL Server

2004-02-13 Thread Juan Torres
Hello, I have a connectoin ODBC with a SQL Server database. A table has a field of type 'nvarchar'. This field contains japanese characters. How can I read these japanese characteres? When I read (with: select name from data) only read '?' character. Thaks very much. Juan Torres. -- PHP

Re: [PHP-DB] ODBC with SQL Server

2004-02-13 Thread Robert Twitty
You cannot use the odbc mssql extensions to read nvarchar ntext fields. You will have to use the odbtp extension located at http://odbtp.sourceforge.net. It provides support for UNICODE data. -- bob On Fri, 13 Feb 2004, Juan Torres wrote: Hello, I have a connectoin ODBC with a SQL Server

RE: [PHP-DB] ODBC MS SQL Server 7

2001-12-24 Thread Andrew Hill
Integration Technology Providers -Original Message- From: Javalina [mailto:[EMAIL PROTECTED]] Sent: Friday, December 21, 2001 7:51 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] ODBC MS SQL Server 7 Hi to all...please can you help me ...because i cant retrieve any row of the database

[PHP-DB] ODBC MS SQL Server 7

2001-12-21 Thread Javalina
Hi to all...please can you help me ...because i cant retrieve any row of the database on MS SQL Server 7 with ODBC . i did use Openlink driver on a Solaris 6 machine (Sparc) , the database are on WIN NT4.0 my code is. ? /* some environment variables, you can test to comment them out to see if

[PHP-DB] ODBC and SQL Server

2001-09-05 Thread Todd Cary
I am trying to setup an ODBC connect to SQL Server. My DSN is Acct32_ODBC. I am using NT Authentication, so that could be my problem. odbc_connect(Acct32_ODBC, , ); Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'PENTIUM3\IUSR_PENTIUM3'., SQL state

RE: [PHP-DB] ODBC and SQL Server

2001-09-05 Thread Andrew Hill
Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 2:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ODBC and SQL Server I am trying to setup

Re: [PHP-DB] ODBC and SQL Server

2001-09-05 Thread Todd Cary
Andrew - Thank you for getting back to me... Well, does the Test button on your ODBC Admininstrator shed any light? :) If it works there, and doesn't work in your PHP, create an ODBC Trace in the Administrator so you can see the exact parameters of the connect. The test does give me an

RE: [PHP-DB] ODBC and SQL Server

2001-09-05 Thread Andrew Hill
Providers -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 5:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] ODBC and SQL Server Andrew - Could it be that the string, Acct32_ODBC\ 0, should be Acct32_ODBC

Re: [PHP-DB] ODBC and SQL Server

2001-09-05 Thread Todd Cary
Andrew - What I am trying to do is to find out if I can use PHP with my client's MS SQL Server DB. Anything that can help me obtain that information would be greatly appreciated. OS: Win 2K (SP 2) DBMS: MS SQl Server 7 Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database

RE: [PHP-DB] ODBC and SQL Server

2001-09-05 Thread Andrew Hill
, September 05, 2001 6:16 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] ODBC and SQL Server Andrew - What I am trying to do is to find out if I can use PHP with my client's MS SQL Server DB. Anything that can help me obtain that information would be greatly

Re: [PHP-DB] ODBC and SQL Server

2001-09-05 Thread Todd Cary
Andrew - Since I installed the OpenLink ODBC, the MS SQL Server Enterprise Manager has just about become useless as well as MS SQL Server itself. It take many minutes to do just about anything - even after I uninstalled OL. Do you have any suggestions? Todd -- Todd Cary Ariste Software