DotNetNewsgroup.com  
web access to complete list of Microsoft.NET newsgroups
   home   |   control panel login   |   archive  |  
 
  carried group
academic
adonet
aspnet
aspnet.announcements
aspnet.buildingcontrols
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
assignment_manager
datatools
dotnet.distributed_apps
dotnet.general
dotnet.myservices
dotnet.nternationalization
dotnet.scripting
dotnet.security
dotnet.vjsharp
dotnet.vsa
dotnet.xml
dotnetfaqs
framework
framework.clr
framework.compactframework
framework.component_services
framework.controls
framework.databinding
framework.drawing
framework.enhancements
framework.interop
framework.odbcnet
framework.performance
framework.remoting
framework.sdk
framework.setup
framework.webservices
framework.windowsforms
framework.wmi
frwk.windowsforms.designtime
lang.csharp
lang.jscript
lang.vb
lang.vb.controls
lang.vb.data
lang.vb.upgrade
lang.vc
lang.vc.libraries
  
 
start date: Tue, 21 Aug 2007 09:22:29 -0700,    posted on: microsoft.public.dotnet.framework.aspnet        back       

Thread Index
  1    Tina
          2    Steve
          3    Peter Bromberg [C# MVP]
          4    Bahadýr ARSLAN
          5    Braulio Diez


connectionstring to 127.0.0.1   
I have a project that someone else wrote that I have to figure out.  The 
database connection string is as follows:
sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"

What is this connection to??
Thanks,
T
Date:Tue, 21 Aug 2007 09:22:29 -0700   Author:  

Re: connectionstring to 127.0.0.1   
127.0.0.1 is the "local" computer. In other words, whatever computer
uses that connection string connects to itself.


Steve C.
MCAD,MCSE,MCP+I,CNE,CNA,CCNA


Tina wrote:

> I have a project that someone else wrote that I have to figure out.  The 
> database connection string is as follows:
> sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
> 
> What is this connection to??
> Thanks,
> T 
> 
> 
Date:Tue, 21 Aug 2007 12:39:49 -0400   Author:  

RE: connectionstring to 127.0.0.1   
127.0.0.1 is "localhost" - meaning, whatever SQL Server instance is installed 
on the same machine. If SQL Server is somewhere else, then all you need to do 
is change the connection string to match the machine name or IP address 
instead of 127.0.0.1

-- Peter
Recursion: see Recursion
site:  http://www.eggheadcafe.com
unBlog:  http://petesbloggerama.blogspot.com
BlogMetaFinder:    http://www.blogmetafinder.com



"Tina" wrote:


> I have a project that someone else wrote that I have to figure out.  The 
> database connection string is as follows:
> sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
> 
> What is this connection to??
> Thanks,
> T 
> 
> 
> 
Date:Tue, 21 Aug 2007 18:36:02 -0700   Author:  

Re: connectionstring to 127.0.0.1   
Hi,

Don't you want to connect to a database?
I couldn't see your DB name.

In connection string you have to set database name via Initial Catalog or 
Database properties.
sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes; Initial 
Catalog=AdventureWorks";

"Tina" , iletisinde unu yazd, 
news:uHB859A5HHA.1168@TK2MSFTNGP02.phx.gbl...

>I have a project that someone else wrote that I have to figure out.  The 
>database connection string is as follows:
> sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
>
> What is this connection to??
> Thanks,
> T
> 
Date:Wed, 22 Aug 2007 09:34:16 +0300   Author:  

Re: connectionstring to 127.0.0.1   
Bahadir is right, 

  Maybe the connection string that you are using is not the complete one. To 
check about connection strings:

http://www.connectionstrings.com

  You can use instead of 127.0.0.1, "localhost" as sombedy mentioned before, 
it's easier to understand.

  HTH
    Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------




"Bahadır ARSLAN" wrote:


> Hi,
> 
> Don't you want to connect to a database?
> I couldn't see your DB name.
> 
> In connection string you have to set database name via Initial Catalog or 
> Database properties.
> sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes; Initial 
> Catalog=AdventureWorks";
> 
> "Tina" , iletisinde şunu yazdı, 
> news:uHB859A5HHA.1168@TK2MSFTNGP02.phx.gbl...
> >I have a project that someone else wrote that I have to figure out.  The 
> >database connection string is as follows:
> > sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes"
> >
> > What is this connection to??
> > Thanks,
> > T
> > 
> 
> 
Date:Wed, 22 Aug 2007 01:02:00 -0700   Author:  

Google
 
Web dotnetnewsgroup.com


COPYRIGHT ?2005, EUROFRONT WORLDWIDE LTD., ALL RIGHT RESERVE  |   Contact us