I've got an application that works off an SQL 7/2000 database. For our clients who do not have an sql server we want to be able to set up our database with msde. I know how to install msde but cannot find the right information on how to install our database and connect to the msde. I also need to setup the user that our application logs in under. The application looks for a filedsn that is configured with our hardcoded username and password. I know how to setup the dsn but come back to the same issue of setting up our username and password so that it is the dbowner of the database.
I prefer to create this setup myself so that I can support any new fetures that may be required but would be willing to look at any 3rd party solution.
Thanks for any help with this.