Date:         Wed, 16 Feb 2011 11:45:14 -0600
Reply-To:     matt.pettis@THOMSONREUTERS.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Matthew Pettis <matt.pettis@THOMSONREUTERS.COM>
Subject:      Re: SAS/ACCESS ODBC: Problem viewing tables with 'libname odbc'
              engine (but ok with passthrough)
Comments: To: djnordlund@FRONTIER.COM
In-Reply-To:  <988B051675D54E0B85813A70FDF5A3E5@Aragorn>
Content-Type: text/plain; charset="utf-8"

Hi Dan,

Thanks for the help.  That worked -- sort of.  I now see tables, but they aren't the ones I expect.  I'm not sure what I'm viewing.  I assume it's the dbo schema, but under a different database.  The dbo schema for which I'm trying to view tables is 'StorageData' -- I figure I have to pass that argument somehow to the libname engine as well...

Thanks again for your help,
Matt

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Daniel Nordlund
Sent: Wednesday, February 16, 2011 11:03 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: SAS/ACCESS ODBC: Problem viewing tables with 'libname odbc' engine (but ok with passthrough)

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Matthew Pettis
> Sent: Wednesday, February 16, 2011 7:16 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: SAS/ACCESS ODBC: Problem viewing tables with 'libname odbc'
> engine (but ok with passthrough)
>
> I meant to add that this is a Microsoft SQL Server.
>
>
>
> From: Pettis, Matthew (Legal)
> Sent: Wednesday, February 16, 2011 9:10 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: SAS/ACCESS ODBC: Problem viewing tables with 'libname odbc'
> engine (but ok with passthrough)
>
>
>
> Hi,
>
>
>
> I am trying to find the right incantation to view tables via the
> 'libname odbc' engine.  I can correctly query tables with passthrough
> sql, but when I try to view the individual tables with the 'libname
> odbc' engine, no tables are in the explorer for me to see.  I think the
> issue is that I don't know how to specify all of the correct pieces in
> the libname statement.  Below is an example of two libname statements
> (both succeed in connecting, but explorer for the assigned libname
> doesn't show any tables).  Any help to make the libname engine work is
> appreciated.
>
>
>
> Thanks,
> Matt
>

Matt,

Try setting schema=DBO .


Hope this is helpful,

Dan

Daniel Nordlund
Bothell, WA USA