Solved

Netware 5.1 + Btrieve + VPN

Posted on 2003-11-06
11
941 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Groupwise IMAP 2 1,146
finding permissions 6 634
Novell time synchronisation 7 315
Misc Groupwise 2014 Android users unable to use ActiveSync 1 70
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Cloud-based technologies and services will continue to grow in popularity in 2017 thanks to the simple, scalable and cost-effective solutions they deliver. Here are three areas where cloud adoption is poised to really take off.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

22 Experts available now in Live!

Get 1:1 Help Now