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.
Printable View
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).Quote:
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.