ODBC OLE DB and DB-Libraries 
Author Message
 ODBC OLE DB and DB-Libraries
Can someone tell me how the Network Libraries that you install with SQL 7
(TCP/IP, Named Pipes, etc,) fit into a program writen to use ODBC or OLE DB?


Thu, 08 Nov 2001 03:00:00 GMT
 ODBC OLE DB and DB-Libraries

They are the protocol underneath ODBC / OLE DB, whereas these are
programming interfaces, TCP/IP and Named PIpes are network protocols.

--
Tony Rogerson MCP,SQL Server MVP
Torver Computer Consultants Ltd.


Quote:
> Can someone tell me how the Network Libraries that you install with SQL 7
> (TCP/IP, Named Pipes, etc,) fit into a program writen to use ODBC or OLE
DB?



Fri, 09 Nov 2001 03:00:00 GMT
 ODBC OLE DB and DB-Libraries
Sean,

 The network libraries run under ODBC, OLE-DB etc.  See the SQL Resource Kit
for in-depth diagrams/details of this sort of stuff, where TDS fits in etc.

Quote:
> Can someone tell me how the Network Libraries that you install with SQL 7
> (TCP/IP, Named Pipes, etc,) fit into a program writen to use ODBC or OLE DB?

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp


Fri, 09 Nov 2001 03:00:00 GMT
 ODBC OLE DB and DB-Libraries
Have a look at the "Communications Components" topic in the SQL Server 7.0
Books Online, it discusses how the Net-Libraries are used.

--
Alan Brewer
Technology Lead
SQL Server Documentation Team



Fri, 09 Nov 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Microsoft OLE DB provider for ODBC-internal client library error

2. ODBC to OLE DB bridge: translation library issue

3. EXPRESS OLE DB LIBRARY : Ideal data access library

4. DB-Library error 10040: DB-Library network communication layer not loaded

5. OLE DB vs ODBC for Oracle DB access

6. Difference between OLE DB 8.0 and OLE DB

7. Latest Versions: Net-Library, DB-Library, ODBC Driver

8. OLE DB for SQL vs. OLE for ODBC

9. Additional libraries for OLE DB

10. Microsoft's OLE DB Simple Provider 1.5 Library isn't cutting it :(

11. ODBC to OLE DB and a ODBC question

12. MS OLE DB provider for ODBC sources and ADABAS ODBC drivers


 
Powered by phpBB® Forum Software