Date:         Mon, 13 Sep 2010 18:14:57 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: FileMaker to SAS via ODBC?
Comments: To: Roger A WIRT <Roger.A.Wirt@state.or.us>
In-Reply-To:  <201009132258.o8DKPMNE031339@willow.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Is it any different if you use a connect to ODBC rather than a libname?  IE,
a 'select * from connection to odbc (... filemaker pro commands ...)' after
using 'connect to odbc (string)' ?  Some SQL2005 databases that I connect to
I can't use LIBNAME access because they're behind a schema behind a schema,
which SAS won't go two deep - but select * from connection to odbc (...)
works since I can use DBMS specific language in that select.

-Joe

On Mon, Sep 13, 2010 at 5:58 PM, Roger A WIRT <Roger.A.Wirt@state.or.us>wrote:

> We'd like to use SAS 9.2 to extract data via ODBC from FileMaker (Pro 11
> Advanced) but have hit a snag.  With a confirmed ODBC DSN and FileMaker
> internal privileges & permissions set, we obtained these results on a
> Windows XP system:
>
> Simple test database (3 rows, 2 columns):
>  Worked with Excel 2007(which successfully read the FM data via ODBC);
>  Didn't work with SAS or SPSS (using same DSN as Excel):
>   SAS 9.2 created libname for table, but clicking viewtable icon elicited
> message that 'table either does not exist or cannot be displayed'.
>   SPSS 18 behaved similarly, displayed column headings but wouldn't fetch
> data.
>
> More complex test database didn't work at all:
>   Excel 2007 displayed an hourglass (which we terminated after 1/2 hour).
>   SAS again displayed icons for table occurrences but wouldn't fetch data.
>   SPSS recognized table-occurrences, displayed column headings, no data.
>
> Any comments would be much appreciated.
>
> Roger Wirt, Oregon DHS Public Health Division, Portland
>  I wonder if this would work as a connection string:
>    Roger<dot>A<period>Wirt{-a-t-}state<period>or<dot>us ??
>
> version numbers:
>   FM 11.0.2.0, FM ODBC driver 11.0.61
>   SAS 9.2 M0 with associated (SAS 9.2) ODBC driver
>   SPSS ('PASW') 18.0.0
>   XP Pro SP3
>