Re^4: How to change expired database password via DBI?

[Sue D. Nymme]

Okay, I understand. And looking through the C code for DBD::ODBC, I see where SqlDriverConnect is being called, and that it uses SQL_DRIVER_NOPROMPT.

So it appears that there is no way to do what I want in Perl. Rats.

[mje]

No, I did not say there was no way to do it. I was just explaining the current mechanism and where your dialogue was probably coming from. We can change DBD::ODBC in a few ways to perhaps support what you need. I'm not sure where you are going to get a window handle from but there is the connection attribute SQL_COPT_SS_OLDPWD which I could look at. In fact, by sheer coincidence (not), I've had a request for this in my email this afternoon - not doubt from someone else in your operation.

Unfortunately, I am away on holiday for 2 weeks from tomorrow so I won't be able to do anything about it but DBD::ODBC is in subversion and I'd happily accept a patch. Otherwise, you'll have to wait 2 weeks and remind me then.