A little background:

I'm trying install Pervasive.SQL 2000i client on a Windows 2000 server. The
P.SQL 2000i server is running on a Netware 6 server. The Win2K server is
accessing the Netware server using Native File Access. I have not been able
to get this to work.

The problem:

I've packet sniffed the attempted connection from my win2k P.SQL client to
the Netware P.SQL server. It requests \PIPE\BMKDE\FUNCTION.PIP and gets an
error: No permissions to perform the requested operation. I might be off on
a wild goose chase but I would like to know what function.pip is. This may
give me some clue about the cause of my problem.

If you need more information to better answer this let me know.

TIA

David

This is the named pipe that the database uses to establish a connection to
WinNT servers to pass security authentication information. Obviously, the
NetWare server is not responding to named pipes, so this request will fail, and
the system should fall-back to using NetWare-style calls.

Without the Novell client, however, it is unclear if the Pervasive.SQL
requester will be able to detect that the server is a NetWare box. Verify that
Runtime Server Support is enabled, just in case that helps. Also, try forcing
a username & password into here, just in case. (See the on-line manual for
details.)

If this still fails, then we mightbe able to manually tweak the SatEntry
database (in the registry) to make the connection work, but this should not be
needed. To verify valid TCP communications, make sure that you can PING by
NAME (not just by address) from the Win2K server to the NetWare box. (NetWare
does not set up DNS records by default, so this could be an easy solution to
the problem.)
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 18-20: See our web site for details!


David Ruggles wrote:

Thanks for the response. Comments Inline.

David

Bill Bach utilized atoms to convey:

I didn't know if NFA was supposed to support named pipes

I did not know about the Runtime Server Support and the ability to
force a username and password. I will search through the online manual
and the website, but I haven't had much luck with this before so if you
could give me some pointers here I would appricate it.

Yep, pinging was the first thing I did, and it works fine.

I went to your site and noticed the comment in the tech support section
that I needed a valid support contract for telephone support. If you
would please email me more information about that. I've been supporting
Pervasive since version 6.15 at my organazation but it would really be
great to have some one I could turn to when I needed it. (I waste a lot
of time searching Pervasive's site) (david at safedatausa dot com)
Thanks.

David

David Ruggles utilized atoms to convey:

I found the information about the Runtime Server Support. I have not
checked it yet but I will, however I'm not sure this will fix the
problem because the client just hangs, it doesn't return an error.

David Ruggles utilized atoms to convey:

Found the information about the Runtime Server Support. Tried both the
yes setting and the username password setting. Neither made any
difference.

Any other suggestions would be greatly appricated.

David

The problem may be due to NFA. Can you try the NOvell client? Or is this
off-limits?
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: March, 2004: See our web site for details!


David Ruggles wrote:

Well I'm trying to use IIS to serve pages off of the Netware server and it
was very unreliable on NT with the Netware Client. I haven't been able to
get it to work at all on Win2K with the Netware Client. With NFA serving
files is very stable and I haven't had any problems. But most of the website
rely very heavly on Pervasive Databases on the server so I can't use it
without the Pervasive Client.

So all that to say: The Netware Client isn't ruled out, but I haven't been
able to get it to work.

"Bill Bach" <bbach (AT) cncdsl (DOT) com> wrote

Note: Pervasive's Documentation says that Pervasive.SQL will work over NFA,
but I haven't found anything that says how to do it.