Solved

Netware 5.1 + Btrieve + VPN

Posted on 2003-11-06
11
937 Views
Last Modified: 2006-11-17
Hi,

I have a server with Netware 5.1 with is running a Btrieve database.

Now i want to scces the btrieve database trough the internet.

The server has a static ip-adres and the clients a dynamic.

How must i do this?

Can you give me tips how to handle.

Greetings Hendrik
0
Comment
Question by:lrtontjes
  • 7
  • 4
11 Comments
 
LVL 35

Expert Comment

by:ShineOn
ID: 9699987
IIRC, Btrieve uses NCP over IPX.

You may have to set up an IPX tunnel on your VPN, or use compatibility mode.
0
 
LVL 10

Expert Comment

by:DSPoole
ID: 9735056
nope - Pervasive SQL2000 has TCP listeners on it now (new in NetWare 5.1) -

You need to NAT a Public IP address to the servers Private interface and then open up IP ports in your firewall that allow for Pervasive communication, which is on port:s:  1583 and  3351 - see:

http://support.novell.com/cgi-bin/search/searchtid.cgi?/10072805.htm

for getting Pervasive SQL 2000i working via TCP/IP

0
 
LVL 35

Expert Comment

by:ShineOn
ID: 9735321
I said * Btrieve. * You said * Pervasive SQL2000. *

Two different (although related) products.  

NetWare 5.1 still had Btrieve 7, IIRC, NOT Pervasive SQL-anything...
0
 
LVL 10

Accepted Solution

by:
DSPoole earned 125 total points
ID: 9735635
nope - Novell NetWare 5.1 shipped with Pervasive SQL2000 (7.51) - which is freely upgradeable to Pervasive SQL2000i (7.94).

The modules that allow for TCP/IP communication are BTCPCOM.NLM -

It was Novell NetWare 5.0 that still used the Novell-branded BTrieve database.

In case you didn't know, BTrieve *IS* Pervasive SQL - or should I say Pervasive SQL2000 *IS* BTrieve.  Novell sold the rights to BTrieve to Pervasive before NetWare 5.1 shipped.  Pervasive simply renamed it, upgraded it and changed the licensing (from unlimited users to 2-user vesions) and thus Pervasive SQL 2000 was born (and deployed with NetWare 5.1).

Trust me, you don't want to argue this point with me, I've got BTrieve applications running on NetWare 4.2 and 5.1 servers including ARCserve 7 for NetWare.  I know BTrieve and Pervasive configurations inside and out.  It's a sore point with me because of ARCserve and AMSI....

You can't run a BTrieve database on a NetWare 5.1 server unless you go thru Pervasive SQL2000 to do it.  The NLM's would conflict with each other if you attempted to install BTrieve on a NetWare 5.1 server (I did some research on this to see if it was possible as a workaround to the licensing issue).  This is because they are the same name (BTRIEVE.NLM).  However, Pervasive SQL 2000 is fully backwards compatible with  Novell's branded BTrieve database service.  It's all in the BTI.CFG...

the NetWare module that is Pervasive these days is NWMKDE.NLM
0
 
LVL 35

Expert Comment

by:ShineOn
ID: 9735814
btrieve wasn't novell-branded.
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 35

Expert Comment

by:ShineOn
ID: 9737014
Btrieve was owned by Novell for a while, and it wasn't called Pervasive SQL 2000 until 1999.  Actually, Pervasive.SQL is a combination of the old Btrieve and another database engine that Pervasive already owned.  They combined features and cut their line down to the one database platform.

from http://www.btrieve.com/html/past.asp -
"1999   Pervasive launches its flagship data-management product, Pervasive.SQL 2000, which included a new server platform: Linux. "

and even then, I remember having the choice of taking Pervasive.SQL or Btrieve 7 with NetWare 5.1 when I installed ARCServe on 5.1.

Pervasive SQL 2000i didn't come out until 2001.

So, we're once again both right, you a tad more than me this time... ;)
0
 
LVL 35

Expert Comment

by:ShineOn
ID: 9737034
Oops,  it wasn't *Btrieve* that was owned by Novell, it was Pervasive, formerly SoftCraft, that had Btrieve, which Novell acquired way back when, and which was spun off later into its own company again...
0
 
LVL 35

Expert Comment

by:ShineOn
ID: 9737053
Anyway, NWMKDE and any of the other MKDE's out there are all still Btrieve "under the hood."  That's why it uses "BTI.CFG" and not  "PERVASIVE.SQL.CFG."
0
 
LVL 35

Expert Comment

by:ShineOn
ID: 9737073
Back to the question.  If lrtontjes says he's running btrieve and not pervasive.sql.2000 on his netware 5.1, I believe him.

I still say the difference is that Btrieve 7 still used NCP over IPX, or perhaps it was SPX calls - one or the other - and in order to go "pure IP" with the Btrieve stuff you had to switch from Btrieve 7 to Pervasive.SQL 2000.  Call me crazy, but that's what I remember from about that time, when I was putting up my first 5.1 servers.
0
 
LVL 10

Expert Comment

by:DSPoole
ID: 9737400
You can't load BTrieve on NetWare 5.1 - because Pervasive SQL 2000 uses NLM's with the same name and backreving the internal database will screw up NetWare's installed application (NWCONFIG) database.  Novell has said - DON'T backrev.

However, Pervasive SQL is backwards compatible with BTrieve at the database level (will ever write version 6.x of the database files instead of version 7.x if you so desire).

So, it's possible to run a BTrieve application on a NetWare 5.1 using the Pervasive SQL 2000 engine to do it - the BTrieve app won't know the difference - this I have DONE (AMSI).

0
 
LVL 10

Expert Comment

by:DSPoole
ID: 9737481
Besides, he said he was running a "BTrieve database" not that he was running "BTrieve database server" on his NetWare 5.1 box ;)

When we run AMSI (a Btrieve database originally running on NetWare 4.2 for our org) we run it under Pervasive SQL2000i (7.94) upgraded from Pervasive SQL2000 (7.51).  Instead of going to the BTrieve Monitor and displaying the database server stats on the NetWare console, you use the Pervasive SQL Monitor under Windows - you can see (after selecting your Pervasive SQL server) what database files are in use by which users, the protocol being used, handles, etc.

Simply follow the TID I provided, which explains how to access the database services via TCP (albiet under NetWare 6, but that comes with Pervasive SQL2000i (7.94) preinstalled - but you can freely update your 7.51 to 7.94 using Pervasive SQL2000i Service Pack 4, either way, the update is available on Pervasives' web site).

Follow the instructions to force Pervasive (BTrieve) engine to communicate via TCP.

Once that is done (and verified) - then assign a STATIC Public IP address to the STATIC Private IP address of the server running the BTrieve database.  This is called NAT - it's how a server with an internal (Private) IP address can be seen on the Internet with a different external (Public) IP address.  Then, if you have port filtering on a firewall, you will need to open the two TCP ports I mentioned above in your firewall.

Once that is complete and communication can be verified, simply point a "client" to the Public IP address, NAT should take care of the rest.

0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now