What protocol does the ADP use?

I've got an Access 2000 ADP file that connects up to SQL Server 2000.  I have been asked by a client "What protocol does your software use?"  I know that the network uses TCP/IP, but that's not exactly what they're asking.  The client is asking if it's ODBC, OLE DB, or what?  I'm not sure exactly what the difference is but I gather that TCP/IP, Named Pipes, etc. are the means of actually passing the data, but ODBC, OLE DB, etc. are the means of communicating with the database.

Is that right?  If so, what do I tell the client?  This is 500 points due to the urgency of the question.
rstoneAsked:
Who is Participating?
 
Krys_WilsonConnect With a Mentor Commented:
Rstone,

According to the book:  Access 2000 Developers Handbook.  Volume 2: Enterprise edition

ADP's use this method to access server data.

ACCESS -> SQL Server OLE DB Provider -> SQL Server Software -> SQL Server Database

Access 2000 uses a direct OLE DB connection to SQL server for data storage.

P.S  I would highly recommend both Volume 1 and Volume 2 of the above if you use a lot of ADP projects.  It has proved invaluable in creating and maintaining my ADP's.

HTH

Chris
0
 
rockiroadsCommented:
0
 
rstoneAuthor Commented:
OK, but that article doesn't talk about MS Access or ADO.
0
 
rstoneAuthor Commented:
I do have that book, but it's been quite some time since I've read it.  I didn't think to look there.
0
 
Alan WarrenApplications DeveloperCommented:
Hi rstone,

this may shed a little light.

From DAO to ADO
http://www.databasejournal.com/features/msaccess/article.php/1490571

Alan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.