Hi,

I am a newbie in databases, Sybase, ODBC, and al.
I need to install a (Windows) software which makes use of ODBC to connect a
sybase database.
I turned out that the software could not access a view (unfortunately, the
software does not give any error information on such errors). Using
sqlAdvantage, I saw that the view could not be accessed by the software
database user because of not enough permissions. I did a "grant all...", and
I could then see the view from within sqlAdvantage.

But the software still does not work.

I think I am missing something important there. Are ODBC permissions
different from "database" permissions ?
Thanks in advance for your help.

SerGioGio

"SerGioGio" <sergiogiogio@yahoo.fr> wrote in message news:<3fa60aef$0$4703$afc38c87@news.easynet.co.uk> ...
> Hi,
>
> I am a newbie in databases, Sybase, ODBC, and al.
> I need to install a (Windows) software which makes use of ODBC to connect a
> sybase database.
> I turned out that the software could not access a view (unfortunately, the
> software does not give any error information on such errors). Using
> sqlAdvantage, I saw that the view could not be accessed by the software
> database user because of not enough permissions. I did a "grant all...", and
> I could then see the view from within sqlAdvantage.
>
> But the software still does not work.
>
> I think I am missing something important there. Are ODBC permissions
> different from "database" permissions ?
> Thanks in advance for your help.
>
> SerGioGio



Have you looked at the readme for the software. More than likley if
you can use SQL adv to connect then the sybase side is OK. However
many applications require a DSN setup for a database connection. Look
at Microsoft site for details on how to setup a DSN (Data Source
Name).

Paul