Password Change Problem

[cpaige]

Hi People,
I wrote a Visual Basic program to change a users password for MS SQL 2000 Server. The server is currently using SQL security. The program changes the password fine, but it changed the password globally. I want the program to only change the password local to a specific database. This can be done through the Enterprise Manager interface, so I know that it is possible.

I did set the default password of the ODBC connection to the one I want to change. I also tried a DSN less connection in ADO with the Database property set. None of these worked.

Does anybody know how this can be done through ADO, Visual Basic?


Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[JamesLean]

I'm not sure I follow? Only server logins have passwords. Database users map to a login and don't have separate passwords. Therefore you can't change a password for a specific database. Can you tell me how you did this through Ent Mgr?

--James

 

[cpaige]

Well what do you know?

You are correct. I thought that was the case until someone demonstrated it to me. I guess I didn't watch closely enough. I probably need more sleep at night.

Either way.

Thanks! You answered my question quite well.

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"