By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,684 Members | 1,439 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,684 IT Pros & Developers. It's quick & easy.

website and database on same server

P: n/a
Hi,

I have an asp.net 2.0 website and a sql database on the same server. In the
web config file I have set up a connection to the database using this
connection string....

connectionString="Data Source=myServer;Initial Catalog=MyDatabase;Persist
Security Info=True;User ID=LoginUser;Password=LoginPassword"
providerName="System.Data.SqlClient" />

Should the server be referenced using "localhost" or something? Would that
be more efficient? If I use the server name does that incur a network
overhead as asp.net uses the network to find the server without knowing it
doesnt actually have to because the database is on the same server as the
website.

I suppose the question is what it the best way to set up a connection string
to reference a database on the same server as asp.net.

thanks
Jun 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi,
If you are running SQL Server or MSDE on the same machine as your ASP pages,
you are probably tempted to use the hostname "localhost." This doesn't always
work, due to different configuration issues, so try (local), 127.0.0.1, the
actual host name, or simply a period (".").
ref:http://databases.aspfaq.com/database...look-like.html
--
Hope this helps.
Thanks and Regards.
Manish Bafna.
MCP and MCTS.

"NH" wrote:
Hi,

I have an asp.net 2.0 website and a sql database on the same server. In the
web config file I have set up a connection to the database using this
connection string....

connectionString="Data Source=myServer;Initial Catalog=MyDatabase;Persist
Security Info=True;User ID=LoginUser;Password=LoginPassword"
providerName="System.Data.SqlClient" />

Should the server be referenced using "localhost" or something? Would that
be more efficient? If I use the server name does that incur a network
overhead as asp.net uses the network to find the server without knowing it
doesnt actually have to because the database is on the same server as the
website.

I suppose the question is what it the best way to set up a connection string
to reference a database on the same server as asp.net.

thanks
Jun 11 '07 #2

P: n/a
Thanks, would there be any performance benefit of using (local),"." or the IP
address over using the server name?

I thought by maybe using (local) or "." that that would improve performance
because asp.net would know the database is on the same server rather than
using the network to find the server.

"Manish Bafna" wrote:
Hi,
If you are running SQL Server or MSDE on the same machine as your ASP pages,
you are probably tempted to use the hostname "localhost." This doesn't always
work, due to different configuration issues, so try (local), 127.0.0.1, the
actual host name, or simply a period (".").
ref:http://databases.aspfaq.com/database...look-like.html
--
Hope this helps.
Thanks and Regards.
Manish Bafna.
MCP and MCTS.

"NH" wrote:
Hi,

I have an asp.net 2.0 website and a sql database on the same server. In the
web config file I have set up a connection to the database using this
connection string....

connectionString="Data Source=myServer;Initial Catalog=MyDatabase;Persist
Security Info=True;User ID=LoginUser;Password=LoginPassword"
providerName="System.Data.SqlClient" />

Should the server be referenced using "localhost" or something? Would that
be more efficient? If I use the server name does that incur a network
overhead as asp.net uses the network to find the server without knowing it
doesnt actually have to because the database is on the same server as the
website.

I suppose the question is what it the best way to set up a connection string
to reference a database on the same server as asp.net.

thanks
Jun 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.