Re: [NOVICE] Schemas, and visibility of tables in MS-Query.

--- Harry Broomhall <harry(dot)broomhall(at)uk(dot)easynet(dot)net>
wrote:
> Jeff Eckermann writes:
> >
> > AFAIK (I haven't done this myself), you can issue
> a
> > "set search path" command in the "Connect
> Settings"
> > box in the DSN, which will limit the schemas seen
> to
> > whatever you put in the search path list.
>
>
> Nice idea - I hadn't spotted that in the driver
> config!
> Unless I'm doing it wrong though I've just tried it
> and it doesn't work! :-(

Harry,

I haven't worked with this to know what the issues
might be. I believe I remember seeing a similar
question come up before, but a quick archives search
brings up nothing useful.

I am forwarding your message to the pgsql-odbc list,
where you are more likely to get a helpful reply. If
you have not yet subscribed to that list, you may wish
to now.

Sorry I don't know enough about this feature to
diagnose your problems.

Jeff

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com