Communication Horizons Knowledgebase: R00001

© Copyright 2001 Communication Horizons LLC.
“NetLib” and “Encryptionizer” are Registered Trademarks of Communication Horizons.
US and international patents pending.
Updated 29 Dec 2001

Knowledgebase

>>ITEM: R00001

>>DATE: Jan 1, 1996

>>TYPE: Information

>>TITLE: RaSQL & Btrieve SNAFU's

>>PRODUCT(S):
RaSQL/B for Clipper
RaSQL/B for Fox
RaSQL/X for Scalable SQL

>>PLATFORM(S):Btrieve

>>SUMMARY:
Please review these items if you are experiencing problems, especially if you are new to RaSQL or Btrieve.

Required for Btrieve version 6.x or later.

	Have You?... Issued N_XLOGIN() at the start of the program?
	Have You?... Upgraded to the latest version of RaSQL/B?
	Have you "patched" up to the latest maintenance release?
	Clipper 5.3 requires maintenance release 6.1C
	FoxPro requires maintenance release 2.1C

Are You Seeing?... Error "Btrieve not loaded", "Can't find Btrieve" or "Error 20"? Then check these...

These files must be in the Windows directory, the Windows System directory, or along the DOS PATH.

	DOS Standalone: Have you loaded BTRIEVE.EXE?
	DOS Networked: Have you loaded BREQUEST.EXE on the work station and started the Btrieve NLM on the server? Issue BSTART at server console.
	Windows Standalone: Can Windows find files WBTRCALL.DLL and WTR32.EXE?
	Windows Networked: Can Windows find file WBTRCALL.DLL see above? Have you started the Btrieve NLM on the server? Have you loaded BREQUEST.EXE on the workstation? Required for Btrieve 6.15 or earlier.

Trouble?... Opening Btrieve file? Then check these...

Are you using Btrieve version 5 to open a file that has been created with Btrieve version 6? Usually results in error 2 or error 10002 - I/O error.

If using NetWare Btrieve, are you attempting to open a file on a local drive? Usually results in Error 20 "Btrieve not found" or "Btrieve not loaded".

Silly as this may sound, have you specified the correct filename and filetype? If a file has no type then it should have a '.' at the end of the name. E.g., "ARCUST." is correct; "ARCUST" is not.

If using DDF files, are they up to date? If in doubt, check with whomever created the DDF files.

If using structure strings: Have you constructed the structure string/array correctly?

Use BUTIL.EXE to determine the exact length as follows:
> BUTIL -STAT filename
On server:
> LOAD BUTIL.NLM -STAT ...FullNetworkPath... > LOAD BUTIL.NLM -STAT SYS:APPL\DATA\ARCUST. for example

	Make sure field names are exactly 20 characters, are left justified and are upper case. Make sure field types are exactly 2 characters, are left justified and are upper case.
	Do the sum total of the field lengths in the structure string (excluding variable length field, if any) match the Btrieve record length?

Can't Find?... BUTIL.EXE or BUTIL.NLM? Or don't have Btrieve 6.x?

Contact Communication Horizons for a specially priced developer's license of the latest Btrieve.

Still having Btrieve problems?

Download Smart Scout from Pervasive Software. It assists in diagnosing various problems related to multiple version of Btrieve, multiple and bad INI settings, and client conflicts.

Knowledgebase Top Home