[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 another way? Cheers, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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/) To unsubscribe, visit: http://www.php.net/unsub.php
[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, 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 user is actually working in the DB. IS there a way to use NT-Authentification in connection with php MSSQL ??? Please Help, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 is possible to leave the modus on NT SQL Authentification? Question #2: I wanted to make the connection to the same database through an ODBC Data Source. I have managed to set it(the ODBC data source) up successfully, but I do not know, how I communicate with it, with php. Do I have to alter something in the php.ini to make ODBC work? Thanks for your help. Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Date comparison problem
But I would like to do it the other way round. I mean for the solution you have mentioned, I have to make the query on the whole record, then compare the two dates and filter the right ones. I'd like to make the query look like: SELECT something FROM table WHERE datetime $form_date So I think I have to adjust the form of my $form_date. Or am I making a mistake somewhere? Thanx Gabor --- This is how I do it: date(m/d/Y,strtotime(odbc_result($rs,ts))) where $rs is the result set and ts is the name of the field containing the datetime. Ryan -Original 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/. 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 field from the DB, I get the form : 02 05 2002 12:25 In the HTML-form it looks a bit different: 12/10/2000 I do not really want to explode the form-data and than build a new timestamp, it has to be a more simple way. Thanks, best regards Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 field from the DB, I get the form : 02 05 2002 12:25 In the HTML-form it looks a bit different: 12/10/2000 I do not really want to explode the form-data and than build a new timestamp, it has to be a more simple way. Thanks, best regards Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 c:\inetpub\wwwroot\test.php on line 11 DATABASE FAILED TO RESPOND. Please help me, because I really don`t know what to do! Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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 something about all this on the mailing list, but I cannot figure out, how to repair it... Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 c:\inetpub\wwwroot\test.php on line 18 What do I have to do? I had completed the same things with mysql and it worked without any problems... Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 imagine how I use this stuff for establishing a connection... Does it really only go this way? Best regards, Gabor -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php