topic Re: CREATE METADATA FOR OUR SOURCE DATA in SAS Data Management

CREATE METADATA FOR OUR SOURCE DATA

deleted_user — Thu, 03 Feb 2011 21:08:22 GMT

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

Re: CREATE METADATA FOR OUR SOURCE DATA

sbb — Fri, 04 Feb 2011 12:45:41 GMT

Suggest you contact SAS Tech Support, open a track for further guidance with SAS 9.1.3 SP4 -- however also have you searched the SAS support website? There are multiple "hits" which mention this symptom and an associated HOTFIX, where the problem is corrected (source level) in SAS 9.2.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:;
odbc CLI error trying to establish connection site:sas.com

Re: CREATE METADATA FOR OUR SOURCE DATA

DaveR_SAS — Fri, 04 Feb 2011 14:41:16 GMT

The SAS 9.2 Intelligence Platform: Data Administration Guide includes this topic about connecting to SAS/ACCESS via ODBC:

http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/a003112372.htm

Re: CREATE METADATA FOR OUR SOURCE DATA

TimStearn_SASProductManagement_ — Fri, 04 Feb 2011 21:28:07 GMT

Hello Lorn9,

It's difficult to say without a few more specifics, but one thing to check is how you created the ODBC connection. Please make sure that you created it as a "system" rather than a "user" DSN. It may be that the SAS process is running as a different user than the one you created the DSN with, thus the error message about "Data source name not found". If this turns out not to be the case, please post again and we can look at something else.

Thanks

Tim Stearn

Re: CREATE METADATA FOR OUR SOURCE DATA

deleted_user — Thu, 10 Feb 2011 17:07:19 GMT

I did create the ODBC connection as a "system" rather than a "user" DSN.
Not sure what is meant by "It may be that the SAS process is running as a different user than the one you created the DSN with..."

I tried importing a table with Management Console, but the error persists.
The Result Error box says "No tables were retrieved from your query. Your connection information may be incorrect. Do you want to view the SAS log?"

I'm wondering now if I have the correct Associated Machine for the ODBC server I created. I'm getting confused with the default name appearing in the field, which has the name where SAS is running, and what I'm reading..."This is the server where the database is running." has me concerned, since the Northwind database is on my c drive. I tried putting my computer's name as the Associated Machine because
that is where the database is located. Unfortunately, it didn't work.

I have contacted SAS Tech Support to open a track.
I'll share their solution once they get one for me.
Thank you for posting ideas and pointing at links.
Much appreciated,
Lorn9

Re: CREATE METADATA FOR OUR SOURCE DATA

deleted_user — Wed, 16 Feb 2011 20:36:29 GMT

I was contacted by a SAS tech person and turns out I was creating the OBDC data source
in my cubicle computer. However, SAS/ACCESS is not licensed on my desk machine.
The answer was to create the ODBC data source on the server.
Once I did that, I was able to get past my logjam.
Many thanks to Varsha at Technical Support and this forum where the answer was given, but I was unable to decipher it on my own.
Thanks again,
Lorn09

Re: CREATE METADATA FOR OUR SOURCE DATA

deleted_user — Wed, 16 Feb 2011 20:39:39 GMT

Thanks again,
Lorn9 Message was edited by: Lorn9