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


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
>
>
>



Relevant Pages

  • Email Problem
    ... we are using SQL database. ... (Server Side -- Backward COmpatability) ... attendees. ... Do i need to install any specific componet, ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Windows 2008 RemoteApp - publish exe from another server
    ... I installed the client .exe in terminal ... server 2008 and published that in RemoteApp. ... I wanted to publish the .exe on the SQL Database server in the ... You probably don't want to install the database on the TS - it would slow down SQL. ...
    (microsoft.public.windows.terminal_services)
  • RE: +++Install SMS 2003+++
    ... server on a workstation and install Window server 2003 with SMS 2003 on it. ... it on the ISA server and keep the SQL database on the same server, ...
    (microsoft.public.sms.setup)
  • Re: sql drivers
    ... The ODBC drivers only have to be installed on the client machines, ... i am trying to connect to an SQL Database with Access as the front end. ... i can connect on a machine with windows xp but the server i'm trying to ... install on the win 2000 server ???? ...
    (comp.databases.ms-access)
  • Re: SBS 2003 SP2 Memory
    ... I can use perfmon however I normally do not know what should be my baseline. ... This counter is one of the better indicators of actual pagefile usage ... Its the only server in my network and I'm running the following: ... Symantec Backup Exec (sql database) ...
    (microsoft.public.windows.server.sbs)