I am trying to connect to PostgreSQL via odbc. I am able to connect
to the database server but can only access the tables in the "public"
directory.
odbc list
Data Source Name Driver
-------------------------------------------------------------------------------
Visual FoxPro Database Microsoft Visual FoxPro Driver
Visual FoxPro Tables Microsoft Visual FoxPro Driver
dBase Files - Word Microsoft dBase VFP Driver (*.dbf)
FoxPro Files - Word Microsoft FoxPro VFP Driver (*.dbf)
MS Access Database Microsoft Access Driver (*.mdb)
Excel Files Microsoft Excel Driver (*.xls)
dBASE Files Microsoft dBase Driver (*.dbf)
MQIS SQL Server
PostgreSQL30W PostgreSQL Unicode
-------------------------------------------------------------------------------
. odbc query "PostgreSQL30W"
DataSource: PostgreSQL30W
Path : XXX
-------------------------------------------------------------------------------
prodSH
After a little digging I found that the same issue occurs with SAS and
that it is a driver issue
(http://archives.postgresql.org/pgsql-odbc/2007-08/msg00035.php). Has
anyone else run across this problem in STATA? If so, how did you
resolve it?
Back in August there was some discussion of developing a plugin for
postgresql (http://www.stata.com/statalist/archive/2007-06/msg00910.html).
Assuming it is complete, would it resolve my issue?
Thanks in advance,
Kevin
P.S. I am running Win 2000, STATA 9, and Postgresql 8.2.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
