Confused about Pervasive connection...

[PMedema]

I have Novell SBS 5 and I am running the DHCP server on the Novell box along with NAT to provide internet connectivity.
I recently purchased a Firewall appliance and hooked it up to our LAN. I told the appliance to handle the DHCP services and shutdown the 1 NIC in the Novell box (it has 2, 1 for connection to the LAN and 1 for the Internet, I shutdown the internet one)
My Pervasive clients are set to run over SPX and I made no changes to the NIC that handles the SPX traffic. But after I disabled the DHCP in Novell and the NIC that handled the TCP/IP internet traffic all of a sudden we could not access our Pervaisve database from the Win98 clients, the W2K and XP workstations could access it no problem... (all workstations are set to use SPX as their preffered protocol)
So I put everything back the way it was and it all started working again... my question is Any ideas as to why? Pervasive is supposed to be working over SPX, I only made a change to the TCP/IP... I can't figure out what went wrong...
Thanks
Paul

 

[mirtheil]

Is TCP/IP actually disabled in the Pervasive setup? If not, then it's probably using TCP/IP. Pervasive's preferred protocol is TCP/IP and it will use it first if it finds it at the client, server, and the "Supported Protocols" setting even if SPX is listed first.
You could use Pervasive System Analyzer Network Test or SmartScout to verify which protocol is being used.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[PMedema]

I run the network analyzier and I got this:
Pervasive.SQL was verified as version 7.90 for Netware using the Winsock IPX/SPX protocol(s).This means your workstation is communicating properly.

So I assume that it is using IPX/SPX...
I have also removed all the protocols from the Client configuration so that only Microsoft SPX is listed. (It didn't want to save the configuration if I selected the Novell SPX protocol)

If there are any other suggestions to this wierdness I'd appreciate it... it has me baffled so far...

PM

 

[mirtheil]

The only way it would save Novell SPX is if you are using the Novell client and the Novell SPX protocol stack. In most cases, the Microsoft SPX is the correct stack.
WHat errors are you getting when you can't connect? Does the Network test still work when the applications can't connect?

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[PMedema]

I'm running AccPac accounting software and when I was having the trouble I would get an error from AccPac that the database was not available. If I recall correctly the Perviasive Network Analyzer also failed...
To me it is just weird that all this happened when I didn't make any changes to the SPX protocol...
Something else I noticed... The 2 or 3 workstations that were able to keep working with the database show up on the Novell System Console as being authenticated with an IP address all the others show authenticated with IPX/SPX address. Even though all my workstations have IPX as the preffered protocol in the Novell Client properties...