>I have a problem when accessing a db in postgreSQL.
>On my server i have 2 databases. On the first i can access without problems.
>On the second i receive this message when i try to create a remote view on its connection. When i create the connection i have no problems
>The message is:
>"The Remote View Wizard was unable to obtain column information for this remote table.
>This may be the result of an ODBC error, or the remote table may not be owned by the current user. or the table doesn't have columns"
>
>In this database i have one simple take with two fields and i am using the user postgres like the other db
>
>Thanks

- Check access rights on postgres side.
- Set up the remote access without the wizard, and see if a meaningful error message is returned.
- Use same credentials and run the SELECT on the postgres GUI. See the errormessage there.