Re: sql help with serv-u
Dale E. Reed Jr. ( (no email) )
Mon, 03 Mar 1997 11:29:31 -0800
Erik Lundby wrote:
> OK I installed serve-u for my authenticated ftp. It seems to work great,
> so-far. One problem, I have not had a default directory for anybody that
> I have created to date. Do I have to go and put one in manually for every
> user currently in the system?, or can I create a default directory with
> usernames for all my current ppp, and pppx2, and pppx3 accts with isql?
There are two issues:
A) Setting the field in SQL Server
B) Creating the directory
A) Use a SQL Statement like:
Set HomeDir = "\\server\share\" + login
Where AccountType = "PPP"
Repeat as often as needed changing PPP to what you need.
B) Create the directories.
What I did a while back was this query:
Select cmd="MD " + homedir