RaSQL Tech Support

RaSQL Tech Support

Most Common RaSQL/B “Snafu's”

Have You?... Issued N_XLOGIN() at the start of the program?

Have You?... Upgraded to the latest version of RaSQL/B?

Required for Btrieve version 6.x or later.

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...

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?

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

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?

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?
Use BUTIL.EXE to determine the exact length as follows (for example):
> BUTIL -STAT filename
On server:
> LOAD BUTIL.NLM -STAT ...FullNetworkPath... > LOAD BUTIL.NLM -STAT SYS:APPL\DATA\ARCUST.