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

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.

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

Replies are listed 'Best First'.
Re^5: How to change expired database password via DBI? by mje (Curate) on Aug 20, 2009 at 15:53 UTC
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.	[reply]

Replies are listed 'Best First'.

Re^5: How to change expired database password via DBI?
by mje (Curate) on Aug 20, 2009 at 15:53 UTC

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.

[reply]