[unixODBC-support] cannot access data
deeprest at chatsubo.lt
Wed Feb 2 21:40:46 GMT 2005
On Wed, 2005-02-02 at 20:23 +0000, Nick Gorham wrote:
> Gedas wrote:
> >I've just set up a user DSN using ODBCConfig for PostgreSQL. Now when I
> >connect to that DSN with DataManager I can see all the tables of my
> >database but DataManager doesn't show any data that is contained in
> >those tables. When I use isql to access the data i get this:
> >SQL> select * from users
> >[ISQL]ERROR: Could not SQLExecute
> >but when I type 'help' command in isql prompt I get all the table names
> >that are in my database.
> >What might be the problem?
> Not sure, what does adding the -v opyion to isql show, that should show
> any error returns.
-v option led me to the solution. Some PostgreSQL access rules helped me
More information about the unixODBC-support