[PHP-DB] Re: Integrated Authentication on IIS 6.0
Hi,I have an intranet application that I wrote in PHP that has worked greatfor a long time. It uses integrated authentication in IIS. I'm trying tomigrate to IIS 6 and things are mostly working. The problem I have isthat my ODBC_CONNECT calls are not resulting in: Login failed for user'(null)'. Reason: Not associated with a trusted SQL Server connection..What it seems to tell me is it is correctly trying to make an integratedauth connection to the database, but for some reason the current user'scredentials aren't being passed? Does anyone have insight into this?Thanks! Ryan How many times in the pass week has people been told that when they post to this list to post code with their question? Most people will reject to help without code displayed. But this problem could be a code or server error but no-one can pin-point it with 100% confidence without code sniplets or what you did. J - Find local movie times and trailers on Yahoo! Movies.
RE: [PHP-DB] Re: Integrated Authentication on IIS 6.0
Okay, ?PHP odbc_connect(myDSN,,); ? Does that help? Ryan -Original Message- From: JeRRy [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 1:33 AM To: php-db@lists.php.net Subject: [PHP-DB] Re: Integrated Authentication on IIS 6.0 Hi,I have an intranet application that I wrote in PHP that has worked greatfor a long time. It uses integrated authentication in IIS. I'm trying tomigrate to IIS 6 and things are mostly working. The problem I have isthat my ODBC_CONNECT calls are not resulting in: Login failed for user'(null)'. Reason: Not associated with a trusted SQL Server connection..What it seems to tell me is it is correctly trying to make an integratedauth connection to the database, but for some reason the current user'scredentials aren't being passed? Does anyone have insight into this?Thanks! Ryan How many times in the pass week has people been told that when they post to this list to post code with their question? Most people will reject to help without code displayed. But this problem could be a code or server error but no-one can pin-point it with 100% confidence without code sniplets or what you did. J - Find local movie times and trailers on Yahoo! Movies. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Integrated Authentication on IIS 6.0
Remember that for this the 'trusted user' is to be the webserver, not the client machine that the user is using to run the application. Ensure that the webserver is registered as a authorized user. Bastien From: Ryan Jameson (USA) [EMAIL PROTECTED] To: php-db@lists.php.net Subject: RE: [PHP-DB] Re: Integrated Authentication on IIS 6.0 Date: Tue, 24 May 2005 12:34:15 -0600 Okay, ?PHP odbc_connect(myDSN,,); ? Does that help? Ryan -Original Message- From: JeRRy [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 1:33 AM To: php-db@lists.php.net Subject: [PHP-DB] Re: Integrated Authentication on IIS 6.0 Hi,I have an intranet application that I wrote in PHP that has worked greatfor a long time. It uses integrated authentication in IIS. I'm trying tomigrate to IIS 6 and things are mostly working. The problem I have isthat my ODBC_CONNECT calls are not resulting in: Login failed for user'(null)'. Reason: Not associated with a trusted SQL Server connection..What it seems to tell me is it is correctly trying to make an integratedauth connection to the database, but for some reason the current user'scredentials aren't being passed? Does anyone have insight into this?Thanks! Ryan How many times in the pass week has people been told that when they post to this list to post code with their question? Most people will reject to help without code displayed. But this problem could be a code or server error but no-one can pin-point it with 100% confidence without code sniplets or what you did. J - Find local movie times and trailers on Yahoo! Movies. -- 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] group by
Hello, Let's say I have an app used in car garages. I have two tables: table cars id make model table work_done id carid details work_date I need to pull out the last work order for each car. This pulls them all: select c.make, c.model, c.id, wd.details from cars c join work_done wd on wd.carid=c.id I can do this to get one per car: select c.make, c.model, c.id, wd.details from cars c join work_done wd on wd.carid=c.id order by c.id but that doesn't always pull the most recent one. How can I group by carid so I only get one row returned per car and ensure that row contains the most recent work row? I can't used subqueries as I haven't updated to MySQL 4.1 yet. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Form information
Hi there everyone, I'm pulling data from my MySQL DB with PHP 4.2, and I have a quantity box for multiple items, what I'm not sure of is this: Say there are 8 products and they choose 3 by entering a quantity into each box, I can display that no problem BUT how can I capture the ID of each product at the same time for each quantity? This is really an important thing for me to have to do, so I can associate each quantity with the product id. BTW, I use quantity[] as the name in the form, so it's an array, I just need to know how to add an extra item called productid to it so I can carry that info over too :-) Thank you for your help, it's driving me nuts. Chris