Architecting, installing and maintaining your SAS environment

Difference between Generic ODBC Access Engine versus Vendor Specific Access Engine

Reply
New Contributor
Posts: 2

Difference between Generic ODBC Access Engine versus Vendor Specific Access Engine

Good Afternoon

 

I'm trying to understand the difference between the generic SAS ACCESS/ODBC Engine and that or the Vendor specific ACCESS engine. In this case MySQL. Any guidance would be very much appreciated.

Super User
Posts: 6,946

Re: Difference between Generic ODBC Access Engine versus Vendor Specific Access Engine

The ODBC ACCESS engine uses the standardized ODBC layer to connect to a database; this removes the necessity for SAS to know the specifics of the DBMS. On the machine in question, you only need the ODBC driver of the DBMS.

With ACCESS to Relational Databases for MySQL, you need the DBMS client installed and configured. But you have the luxury that SAS can make better use of DBMS-specific capabilities when doing implicit pass-through.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 2

Re: Difference between Generic ODBC Access Engine versus Vendor Specific Access Engine

Thank you Kurt, very much appreciated.

Ask a Question
Discussion stats
  • 2 replies
  • 130 views
  • 1 like
  • 2 in conversation