Results 1 to 4 of 4

Thread: Create New Users SQL 2000

  1. Jan 17th, 2003, 03:42 AM #1
    hawk1217
    hawk1217 is offline

    Thread Starter
    New Member
    Join Date
    Jan 2003
    Posts
    5

    Create New Users SQL 2000

    Help!
    I'm trying to add new sql server users at run time from a vb app. I am trying to use sp_addlogin which works from query analyser but won't work from vb. The user I'm using is a member of sysadmin and security admin but it won't work. Any ideas or alternatives?
    Reply With Quote Reply With Quote
  2. Jan 17th, 2003, 04:10 AM #2
    axion_sa
    axion_sa is offline
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724
    In the SQL Server help - Contents -> Building SQL Server Applications -> SQL-DMO -> Collections -> L -> Logins Collection.
    Reply With Quote Reply With Quote
  3. Jan 17th, 2003, 04:57 AM #3
    hawk1217
    hawk1217 is offline

    Thread Starter
    New Member
    Join Date
    Jan 2003
    Posts
    5
    I don't know anything about SQL-DMO. I have been using ADO so far in the application. If possible I'd like to find a solution using ADO. If your solution can be done using ADO then maybe you could tell me a bit more. Thanks.
    Reply With Quote Reply With Quote
  4. Jan 17th, 2003, 04:59 AM #4
    axion_sa
    axion_sa is offline
    Frenzied Member axion_sa's Avatar
    Join Date
    Jan 2002
    Location
    Joburg, RSA
    Posts
    1,724
    Nope, SQL-DMO is quite separate to ADO.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width