Post reply

MSDE - Connection / ADP Files

  • October 29, 2001 at 8:09 am

    #63759

    I guess i'm missing something obvious ....

    I have a VB6 App which connects to Sql 7 using either a StandardUser Login or

    Reporter Login

    Now I wish to use MSDE in either single user or 2 - 3 person multi-user environment.

    I have successfully attached a copy of my Db

    to a local copy of MDSE on my Pc using sqldmo. I have also started and stopped MSDE.

    What I don't understand is where these ADP files join the party. Eventually I'm going to include my App, Msde, and a Database in a wise install package.So I guess I need to distribute an ADP file.

    How do I go about creating a non machine specific ADP ?

    How do I get my Logins / users into the MSDE DB

    Thanks in advance

    Andy

  • October 29, 2001 at 10:41 am

    #419456

    You can use DMO to create logins/users as well.

    Steve Jones

    steve@dkranch.net

  • October 29, 2001 at 10:41 am

    #419455

    Sorry, or a SQL script.

    Steve Jones

    steve@dkranch.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply