sql server connect: friends,
can i get some information (links , etc. ) on database
connectivity strategies (TCP/IP, ODBC , etc.).
Thanks in advance.

Named Pipes is default, but TCP/IP sockets is faster. You can only
configure that from SQL Client Network Utility, SQL Server Network Utility
and ODBC (click client configuration on the login credential screen).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1a_7fcj.asp

Usually, when it comes to programming, OLE DB is what you'll use (see link
below). If you are copying data with DTS, I have no reference, but from
personal experience OLE DB providers work well with Windows Authentication
connections to SQL 2000/7.0. If you are making a SQL authentication
connection or going to a SQL 6.5 database, the ODBC provider for SQL server
seems a little more stable.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_61yb.asp


I think what you may need to read up on the most at MSDN though is the
differences between RDS, .NET, etc. That will affect your programming the
most, the calls made to SQL from IIS.

--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@NOMORESPAM.yahoo.com

Please remove NOMORESPAM before replying.

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

This posting is provided "as is" with no warranties
and confers no rights.

*******************************************************************
[quoted text, click to view]