I'm trying to use the P.2000i ActiveX controls for the first time, in a VB6 program [Win98].

I get this error when trying to access a table on a Netware 4.11 server...

"The VAccess control cannot complete the requested command until it has access to an IDS, but
HostConnect is set to FALSE. The command will fail with status 20."

I can access the data through Access/ODBC, and also through VB-Dos with btrBox95 and bdosstub.

I must be missing something pretty basic to access it with VB6. Can anyone please help?
--
Regards, John
jkane (AT) camozzi (DOT) co.uk

The message specifically mentions IDS.
IDS is an add on for the Windows (only) server platform.
Depending on how the ActiveX application is written it may be written
or configured to attach to an IDS data source instead of the normal
data source.

Of course a status 20 indicates that the requester is not present or
the wrong version.

Also ActiveX is an old interface to be using to develop a new
application. The current interface would probably be OleDB.
OleDB provides similar row-set functionality.

Leonard

On Wed, 14 Apr 2004 10:49:54 +0100, John Kane
<please.see (AT) signature (DOT) gov> wrote:

Leonard,

Thank you for your reply. I have just discovered what the problem was. In the VAccess Location
field it was automatically putting...

\\SERVER\VOLUME:\FOLDER\FILE.DAT

and changing it to...

F:\FOLDER\FILE.DAT

....works, although I don't know why the full path doesn't work.

Its interesting that you mention OleDB as the current interface to use. I've tried the
tutorial and got as far as 'Select the Pervasive OLE DB Provider' but its not in the list.
I've downloaded the P.SQL 2000i version of OLE DB and uninstalled and reinstalled a couple of
times, but it still doesn't appear. Any ideas?

--
Regards, John
jkane (AT) camozzi (DOT) co.uk

In article <45t280tb9bv835c5te5a5ban0othml7276 (AT) 4ax (DOT) com>, lharvey (AT) austin (DOT) rr.com says...

I can now see the Pervasive OLE DB provider after manually registering w3dadbv2.dll and
w3daerv2.dll. But I can't get a connection on the ADO Data Control if I 'Use Connection
String' and 'Build...'. But if I 'Use ODBC Data Source Name' it works and I get the data from
the Novell Server. However, if I use 'demodata' it works with the 'Build...' option. I'm a
little confused. What am I doing wrong?
--
Regards, John
jkane (AT) camozzi (DOT) co.uk

In article <MPG.1aeda07a4f4c20819896ac (AT) news (DOT) dircon.co.uk>, please.see (AT) signature (DOT) gov says...

I have not done any programming with the OLE DB provider but have a
couple of ideas.
'Use ODBC Data Source Name' goes into ODBC bridge mode and should
work with any valid data source.
If it works to the server in general but not a specific database I
wonder if the database passes the "Check Database" wizard.

Leonard

On Mon, 19 Apr 2004 11:58:39 +0100, John Kane
<please.see (AT) signature (DOT) gov> wrote:

The database is good, thank you. I've now got the P.OLEDB to work using code,
including Indexes, provided I use adCmdTableDirect when I open the Recordset. This option
doesn't appear in the properties of the MS ADO Data Control. If I just use adCmdTable I get
status 11 - 'The specified file name is invalid'. I think I'll stick to code now I'm winning

--
Regards, John
jkane (AT) camozzi (DOT) co.uk

In article <cda980hj7uffoessrvdd10ff045ed5iv8m (AT) 4ax (DOT) com>, lharvey (AT) austin (DOT) rr.com says...