Communication to Sql server

There are different ways you can communicate to sql server:

1. Shared memory: on the local server

2. Named Pipe: over LAN

3. TCP/IP : on internet

The detail on this is on below link:

http://msdn.microsoft.com/en-us/library/ms187892.aspx

using ODBC connection you can use TPC/IP or named pipe protocol.

Sql server uses OLEDB to communicate between relational engine and Storage engine.

Thanx

Vinay

About these ads
This entry was posted in General, What I learned today and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s