Hi,
I've been attempting to follow;
Paper 111-31
A Pragmatic Programmers Introduction to
Data Integration Studio: Hands on Workshop
by Gregory S. Nelson
http://www2.sas.com/proceedings/sugi31/111-31.pdf
trying to do
TASK 2 – STEP
😧 CREATE METADATA FOR OUR SOURCE DATA
but am getting the error message below while
****************************************************************************************
NOTE: This session is executing on the NET_ASRV platform.
NOTE: (E9BX03) SAS 9.1.3 SP 4
NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
1 LIBNAME srcdata ODBC DATASRC=Northwind ;
ERROR: CLI error trying to establish connection: [Microsoft][ODBC
Driver Manager]
Data source name not found and no default driver specified
ERROR: Error in the LIBNAME statement.
*******************************************************************************************
Tried finding some explanations of the error message on the web, even installed the Office 2007 ODBC driver but still getting the error.
Any suggestions to get me past this logjam will be much appreciated.
Thnx