Re: using (local) server on SQL 2K

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

From: Chris Taylor (chris_taylor_za_at_hotmail.com)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 18:30:21 +0300

Hi Patrick,

You should definately consider putting the connection string in a
configuration file so that it can be changed easily. You can localhost or
127.0.0.1.

Hope this helps 

-- 
Chris Taylor
http://dotnetjunkies.com/weblog/chris.taylor
"patrick" <patrick@discussions.microsoft.com> wrote in message
news:9D27AEBA-4F9E-4C33-8035-79E9881C17AA@microsoft.com...
> I am trying to create my first SQL Server 2000 app deployment. What I am
concerned about is the app won't be able to connect to another machine via
MSDE 2000 once installed because I have my own machine name/SQL server name
coded into the connection string. I know how to make the string use
variables, but how do I find the right variables for a foreign machine, ie.,
machine name and server name?
>
> When I used SQL server 7 or the MSDE version from 1998, I could set my
conn str server property to
>
> server=(local)
>
> and that would work. But I think I was using ODBC, not OLDB for sqlserver,
and it wasn't in .NET. I have never been able to connect to my SQL 2000
using the (local) setting. Why not? None of the books I have says much on
this except that I should be able to connect via (local). TIA,
psully@nospam.eatel.net
>
>

Relevant Pages

  • Re: MSDE and IIS - Web Hosting
    ... sites getting over 3M hits per month and MOST of those hits were on ... when going to Windows 2003 Server and running very SMALL sites using ... coding for MSDE instead of Access because it's really our only option. ... but not as well as SQL Server who knows. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE help
    ... there is no limit to the number of connections on an MSDE server. ... I'm working with SQL Server Magazine to put together a weekly newsletter ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: version & instances
    ... Microsoft MVP ... Hitchhiker’s Guide to Visual Studio and SQL Server ... MSDE has a limited database size ...
    (microsoft.public.sqlserver.msde)
  • Re: version & instances
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... SQL 2000 SP3a for Antivirus app ... Consider that MSDE as a product is somewhat dated ...
    (microsoft.public.sqlserver.msde)
  • Re: Building SQL connection string in code-behind file. Works on my machine, not on server.
    ... Then you need to show the connection string that was built to get help. ... You say you're using sql server authentication. ...
    (microsoft.public.dotnet.framework.aspnet)