RE: How can I have a user select a local MS SQL database using vb.net?
From: Mal .mullerjannie_at_hotmail.com> (.mullerjannie_at_hotmail.com)
Date: 11/08/04
- Next message: Mark Harris: "RE: Deleting Backups"
- Previous message: Malcolm Cook: "Re: SQL Code for Archiving Server Event Logs"
- In reply to: sal_at_spp.net: "How can I have a user select a local MS SQL database using vb.net? TIA SAL"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 8 Nov 2004 09:12:01 -0800
What we do when shipping our applications :
We always have the system configuration looking at a file, ini or cfg or
whatever you tell it to look at, then when you install this package you get
installshield or whatever distribution tool your using to prompt the user for
specific locations names etc.
You then record these settings to your config file and once your system
starts , it's got all the settings needed to operate on the new environment.
I think it's a small time investment for the reward.
Otherwise in SQL there's good amount of system procs available to get
database names, hosts etc.
Hope this help.
Mal
"sal@spp.net" wrote:
> Greets
>
> I have sucessfully created a sql database and vb.net program locally connecting to my local server.
> (I used visual studio 2003)
> I would like to send the database along with the compiled vb.net code to the user. The problem is the users
> machine and msde server are going to have different names. How do I change this in my code to have
> the user select thier sql server and sql database located locally on his/her machine.
>
> PS the user will have msde installed
>
> TIA
>
>
>
- Next message: Mark Harris: "RE: Deleting Backups"
- Previous message: Malcolm Cook: "Re: SQL Code for Archiving Server Event Logs"
- In reply to: sal_at_spp.net: "How can I have a user select a local MS SQL database using vb.net? TIA SAL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|