[PHP-DB] AUTH_USER

Hi! I have installed a Apache Server (+php) in a Windows NT network. I would like to identify the Windows NT user visiting my php pages. When I was using IIS, I think it was quite easy to find it out through the $_SERVER['AUTH_USER'] variable. But it doesn't seem to work with apache. Is there

[PHP-DB] Warnings and Error messages

Hi all! How can I prevent the warnings end errors to be written on the screen? I would like to prevent the warnings end errors to be written on the screen because I want to handle the errors with the odbc_errormsg() function. How do I do that? Is there a better way? Best regards, Gabor --

[PHP-DB] odbc into associative arrays

Hi all! Is it possible to fetch the odbc results into an associative array? Regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Not associated with a trusted SQL Server connection

Hi! I am working on a MSSQL DB. As I left last week on friday, everything worked fine, but today I got the error message above... What can be the problem. I think it is something with privileges and user rights, isn't it? Please help, Gabor -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Re: Not associated with a trusted SQL Server connection

I realized that the Authentification in the Properties of the SQL-Server has to be changed to sql-server AND(!) Windows. Is there a way to get it working if I set that to only Windows? Greetings, Gabor --- Hi! I am working on a MSSQL DB. As I left last week on friday,

[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

[PHP-DB] nt + sql Authentification /// ODBC

Hi all! I have managed to set up the connection to my MS-SQL Server, but I had to change the User-Authentification modus from NT SQL Authentification to just SQL Authentification in the SQL-Server management, otherwise I always got the error message: Login failed. I would like to know, if it

RE: [PHP-DB] Date comparison problem

Message- From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 8:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Date comparison problem Hi all! I have got a datetime field in a MS-SQL DB, and I have a date field in my html-form with the format: DD/MM/

[PHP-DB] php-security

Hi all! One can see in every php manual and install hint, that you have to consider security issues if you install php as a CGI, but I cannot really imagine what this means. What security issues? Can someone tell me an example, what can happen? Best regards, Gabor -- PHP Database Mailing

[PHP-DB] catch warnings?

Hi all! This is not a typical DB-Question, but I hope you give me some hints either... If I insert a String instead of a date(f.Ex) into the DB, I get a Warning: MS SQL message: Syntax error converting datetime from character string. (severity 16) How can I catch these warnings in PHP? Best

[PHP-DB] Date comparison problem

Hi all! I have got a datetime field in a MS-SQL DB, and I have a date field in my html-form with the format: DD/MM/. I would like to compare the two, but I think the two formats are a bit different and they do not really want to be compared:) If I write a query to write out the datetime

[PHP-DB] MSSQL_connect() won't work

Hello all! I am desperately trying to connect to a Win2000 SQL-Server, but I always get the error message: Warning: MS SQL message: Login failed for user 'gn'. (severity 14) in c:\inetpub\wwwroot\test.php on line 11 Warning: MS SQL: Unable to connect to server: SERVER1 in

RE: [PHP-DB] MSSQL_connect() won't work

Hi! Does the user 'gn' exist? Are you using the correct password? Does that user have permissions on the database? Hint: Login failed for user 'gn' suggests that there is something wrong with that account... That would be fine, but it is not the case. It just won't work! I have read

[PHP-DB] ntext data

Hi! As I wanted to retrieve a field of the data type ntext from the db, I got this error message: 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

[PHP-DB] how do i establish odbc connection?

Hi all! I realized, that it is impossible to retrieve ntext from an MSSQL DB with php normally. (Is this correct?) But I think it should be possible to make it through ODBC. Can someone explain me how this goes? (I think I have set up one ODBC Data Source, but I am not sure) But I cannot even