Hi all,
I need to connect to 9.1D Progress databases (on Unix box) from Windows
(NT/2000) client.
I start my db with _mprosvr.

I 've installed Client networking on the client and have Merant 3.6

The test connection is ok but a ODBC request leads to the following error:
[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access
denied(Authorisation failed) (7512),S1000,-20228

Do you have a idea ?

Thanks in advance

Nicolas

"Nicolas" <nikos@free.fr> wrote in
news:403ca4b7$0$21675$636a15ce@news.free.fr:

> Hi all,
> I need to connect to 9.1D Progress databases (on Unix box) from
> Windows (NT/2000) client.
> I start my db with _mprosvr.
>
> I 've installed Client networking on the client and have Merant 3.6
>
> The test connection is ok but a ODBC request leads to the following
> error: [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access
> denied(Authorisation failed) (7512),S1000,-20228
>
> Do you have a idea ?
>
> Thanks in advance
>
> Nicolas
>
>
>

Have you created a user in the Database and GRANTed select access?? You
need to do this from the SQLExplorer tool (on the Unix box)..

Kevin

Thanks for your answer,

How can I to do that ? In DataAdministration ?

Is there any references in the documentation about the security ?

Nicolas

"Kevin" <Joe@Joe.com> a écrit dans le message de news:
Xns949AAE755E83CJoeJoecom@195.8.68.218...
> "Nicolas" <nikos@free.fr> wrote in
> news:403ca4b7$0$21675$636a15ce@news.free.fr:
>
> > Hi all,
> > I need to connect to 9.1D Progress databases (on Unix box) from
> > Windows (NT/2000) client.
> > I start my db with _mprosvr.
> >
> > I 've installed Client networking on the client and have Merant 3.6
> >
> > The test connection is ok but a ODBC request leads to the following
> > error: [DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access
> > denied(Authorisation failed) (7512),S1000,-20228
> >
> > Do you have a idea ?
> >
> > Thanks in advance
> >
> > Nicolas
> >
> >
> >
>
> Have you created a user in the Database and GRANTed select access?? You
> need to do this from the SQLExplorer tool (on the Unix box)..
>
> Kevin

"Nicolas" <nikos@free.fr> wrote in news:403db44d$0$2440
$626a14ce@news.free.fr:

> Thanks for your answer,
>
> How can I to do that ? In DataAdministration ?
>
> Is there any references in the documentation about the security ?
>
> Nicolas
>

Yes, you could use the Data Admin tool..

Yep. But it is all in the SQL92 Guide and Reference.

Kevin