connectionstring to 127.0.0.1

[Tina]

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

[Steve]

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

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

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

[=?iso-8859-9?Q?Bahad=FDr_ARSLAN?=]

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" <Ti**********@nospamexcite.com>, iletisinde þunu yazdý,
news:uH**************@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

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

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" <Ti**********@nospamexcite.com>, iletisinde şunu yazdı,
news:uH**************@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