For those of you who have been following my problems getting OLE DB
access to databases with classic security on Netware...

We appear to have found the problem and solution.

The problem has basically been that when ever I set a database to classic
security Pervasive.SQL would reject connection attempts saying that
my userid/password was invalid. This, even when properly logged into NDS.


Having worked with a Pervasive support engineer it would appear that
something in the P.SQL server is looking for the user ID in the bindary
and not NDS.

For some time we've been running our servers without a bindary context
as nothing we have need it. However it would appear that the P.SQL server
does need the bindary context. I assume because it scans the bondary for
the user id.

We've added the appropriate bindary context, rebooted the netware server
and suddenly OLE DB access to databases with classic security is working.

I'm now waiting for confirmation of this from Pervasive.

Guy
-- --------------------------------------------------------------------
Guy Dawson I.T. Manager Crossflight Ltd
gnues (AT) crossflight (DOT) co.uk

From my understanding that should take care of the issue.
If you were using the Btriieve API there might be a couple of other
solutions but I believe that is it for OLE DB.

Leonard

On Wed, 27 Oct 2004 14:26:26 +0100, Guy Dawson
<gnues (AT) crossflight (DOT) co.uk> wrote:

Leonard wrote:
Yup. The existance of a bug and the need for a bindary context in
NDS to get OLE DB working on Netware with NDS logins has been confirmed.



--
Guy
-- --------------------------------------------------------------------
Guy Dawson I.T. Manager Crossflight Ltd
gnues (AT) crossflight (DOT) co.uk