Change Password in connection string for File DB

Feb 15, 2011 at 7:55 AM

Hi Again,

I want to secure my Effiproz FILE DB with a password so that someone cannot query it with a query tool. When I add a password to my connection string for a new database it throws an error saying un-authorized access? How can I do this?

Thanks

Coordinator
Feb 15, 2011 at 8:26 AM
Edited Feb 15, 2011 at 8:26 AM

Use following SQL to change default (blank) password,

set identified by <password>;