ADO and SQL Server

[philbell]

Using ADO, once you have connected to an SQL server database passing in an SQL Server Username and Password ( not using NT security ), does anyone know if it is possible to change the username and password by using ADO code.

[JHausmann]

Originally posted by philbell
Using ADO, once you have connected to an SQL server database passing in an SQL Server Username and Password ( not using NT security ), does anyone know if it is possible to change the username and password by using ADO code.



I don't think so but it's failry easy to close a connection and open it again (or have multiple connections, if you'd rather not).