Hi

Our clients website is hosted by the same machine that runs their DBMS.
We have no network protcol (tcp | named pipes | etc..) defined in the
connection string.
Which method will be used accessing the database? Would it be more efficient
to specify the protocol and then which protocol should we use?

TIA!
mortb

Mortb,

If I understand you well, than has it all not much to do with each other.

Can you explain a little bit more what you want.

Cor

Show quoteHide quote

I'm asking what connection method the connection will default to (tcp |
named pipes | shared memory ... etc)
and what method I should use in the senario where the webserver and sql
server is on the same computer.

Any clearer ;)

/mortb



Show quoteHide quote

Hi Mortb,

If the app and the SQL server are on the same machine, and you're accessing
the machine with "." or "(local)", shared memory will be used. Of course,
shared memory is the most efficient way to access the database.

You can also specify the network protocol in the connection string. Please
check the following link for how to specify the network library.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfSystemDataSqlClientSqlConnectionClassConnectionStringTopic.asp

Hope that helps.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Create my own db connection wizard
asp.net sql connection problem
SqlConnection - Timeout Property is read-only?
Operation must use an updateable query... while trying to write to Excel file
Using @@Identity with access