Solved

What protocol does the ADP use?

Posted on 2004-04-16
5
397 Views
Last Modified: 2011-09-20
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.
0
Comment
Question by:rstone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 65

Expert Comment

by:rockiroads
ID: 10842494
0
 

Author Comment

by:rstone
ID: 10842861
OK, but that article doesn't talk about MS Access or ADO.
0
 
LVL 5

Accepted Solution

by:
Krys_Wilson earned 500 total points
ID: 10842942
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
 

Author Comment

by:rstone
ID: 10842988
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
 
LVL 26

Expert Comment

by:Alan Warren
ID: 10842994
Hi rstone,

this may shed a little light.

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

Alan
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question