ADO Connection.ConnectionString does not return back credentials anymore

loko-pr

New Member
I have a legacy ASP application that I need to release on a modern server. It uses ADO with SQLOLEDB to talk to MS SQL Server. It's logging on to SQL with username and password.The app relies on a peculiar behavior of the ADO Connection object that seems to have changed. These days (in ADODB.Connection.6), when you provide a connection string to a Connection and then retrieve it back, you don't get back an exact copy of the original string; specifically, the username and password are stripped from it, and some extra parameters are added.It looks like older versions of ADO did not strip the credentials in this scenario; the application would never work if it did, and it does. Question - is this documented? Is there a way to enforce the legacy behavior in new ADO?I really don't want to downgrade ADO on a shared server.
 
Back
Top