Client Access ODBC driver problem

[Wescotte]

I'm having an issue with a php program I am writing. If the user
enteres their password incorrectly a popup box appears asking them if
they would like to reenter their password (it's part of the driver not
my application). The issue comes into play when you run apache as a
service or not locally and the popup simply doesn't appear any longer.
This wouldn't be an issue but all future requests to login are ignored
until because the driver is stuck waiting for the inital responce of
yes/no to attempt a different password. Has anyone found a way around
this issue?

Eric

[Dan Scott]

Wescotte wrote:

I'm having an issue with a php program I am writing. If the user
enteres their password incorrectly a popup box appears asking them if
they would like to reenter their password (it's part of the driver not
my application).
What "driver"? What operating system? What version?

I've never heard of that behaviour before.

What extension are you using to connect from PHP to DB2? Using Unified
ODBC, compiled with --with-ibm-db2, with cataloged database connections
on Linux I have not seen this problem. Nor have I seen the problem using
Unified ODBC on Windows when the targeted DB2 database has been added as
a System DSN to the Data Sources.
The issue comes into play when you run apache as a
service or not locally and the popup simply doesn't appear any longer.
This wouldn't be an issue but all future requests to login are ignored
until because the driver is stuck waiting for the inital responce of
yes/no to attempt a different password. Has anyone found a way around
this issue?
Eric

[Mark Yudkin]

I can only help you with the ODBC API, not PHP. I do not know how PHP maps
ODBC parameters.

From your symptoms, I asume you're calling SQLDriverConnect. Set the
DriverCompletion argument to SQL_DRIVER_NOPROMPT and the call will fail
instead of prompting.

"Wescotte" <we******@earthlink.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I'm having an issue with a php program I am writing. If the user
enteres their password incorrectly a popup box appears asking them if
they would like to reenter their password (it's part of the driver not
my application). The issue comes into play when you run apache as a
service or not locally and the popup simply doesn't appear any longer.
This wouldn't be an issue but all future requests to login are ignored
until because the driver is stuck waiting for the inital responce of
yes/no to attempt a different password. Has anyone found a way around
this issue?

Eric

[Wescotte]

That's exactly what I needed. Thank you very much

Eric

Mark Yudkin wrote:

I can only help you with the ODBC API, not PHP. I do not know how PHP maps ODBC parameters.

From your symptoms, I asume you're calling SQLDriverConnect. Set the
DriverCompletion argument to SQL_DRIVER_NOPROMPT and the call will fail instead of prompting.

"Wescotte" <we******@earthlink.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

I'm having an issue with a php program I am writing. If the user
enteres their password incorrectly a popup box appears asking them if they would like to reenter their password (it's part of the driver not my application). The issue comes into play when you run apache as a
service or not locally and the popup simply doesn't appear any longer. This wouldn't be an issue but all future requests to login are ignored until because the driver is stuck waiting for the inital responce of yes/no to attempt a different password. Has anyone found a way around this issue?

Eric