Re: How can I have a user select a local MS SQL database using vb.net? TIA SAL

From: Val Mazur (group51a_at_hotmail.com)
Date: 11/10/04 

Date: Tue, 9 Nov 2004 19:03:45 -0500

Hi,

Rule is simple - never hardcode server name , database name and user
information into application. What you could do is to create login form to
ask user to put this information and build your connection string
dynamically. Then you could store database and server name in a settings
file or in a registry, so next time, when user runs application, you could
read these values and prepopulate this information in a login screen 

-- 
Val Mazur
Microsoft MVP
"sal" <sal@spp.net> wrote in message 
news:Xns959BB0301D1B7salsppnet@216.77.188.18...
> 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

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)