[unixODBC-support] cannot access data

Gedas 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:
> 
> >Hello,
> >
> >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?
> >  
> >
> Hi,
> 
> 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
out.

Thanks

--
Gedas





More information about the unixODBC-support mailing list