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