Connection String Machine Independent.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Manny (mcanasc_at_hotmail.com)
Date: 12/04/04 

Date: Sat, 4 Dec 2004 16:08:57 -0700

Hi there,

I've been researching on the diferent newsgroups to find out how to do this,
but no luck so far.

I'm developing a client/server windows application with VB.NET, MSDE is my
backend database.

This is sample connection string to connect to my server:
data source=MACHINE_NAME\MSDE; initial catalog=DatabaseName; user
ID=sa;password=sa

Now, when I distribute this application, the Server will have to be
installed in one machine in the LAN, now the connection string it's
hardcoded right now to look for a specific machine name and the instance
name.

So, how can I build, if it's possible, the connection string machine
independent?

Thanks very much,

Manny

Relevant Pages

  • Connection String Machine Independent.
    ... but no luck so far. ... I'm developing a client/server windows application with VB.NET, ... This is sample connection string to connect to my server: ... Now, when I distribute this application, the Server will have to be ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • RE: vb6 app no longer connects to Access DB on Term Server 2003
    ... we recently upgraded the Terminal Server from the 2000 version to ... we have tried simplifying the connection string by removing the ... Microsoft ActiveX Data Objects 2.8 Library ... We even tried it on Windows Server 2003 ...
    (microsoft.public.data.oledb)