DOCUMENT:Q142883 11-AUG-1999 [foxpro] TITLE :HOWTO: Troubleshooting Btrieve Connections in Visual FoxPro PRODUCT :Microsoft FoxPro PROD/VER:3.0b OPER/SYS: KEYWORDS:kbvfp kbvfp300b kbvfp600 ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Visual FoxPro for Windows, versions 3.0b, 6.0 ------------------------------------------------------------------------------- SUMMARY ======= This article lists troubleshooting techniques you can use if you receive connectivity errors attempting to connect to a Btrieve data source. NOTE: Some products mentioned in this article are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability. MORE INFORMATION ================ Use the steps given in this article to resolve the following error message and other similar messages: "Connectivity error: [Microsoft][ODBC Btrieve Driver] Errors encountered while using the Btrieve DLL" Steps to Troubleshoot Error Message ----------------------------------- 1. Check the current Btrieve driver version being used in the ODBC Icon. In the Main group in Program Manager, double-click the Control Panel icon: a. In the Control Panel window, double-click the ODBC icon. The Data Sources dialog box appears. b. In the Data Sources dialog box, choose the Drivers button. The Drivers dialog box appears. c. In the Drivers dialog box, highlight the Btrieve driver and choose the About button. The following driver information is displayed: driver, file name, description, company, version, language, creation date, and size. 2. Make sure the Wbtrcall.dll file is in the Windows\System directory. If the .dll file is missing, you can obtain it from Btrieve. This file is part of the Btrieve for Windows product. The Wbtrcall.dll must be installed and accessible on the system. 3. Check the size of the Wbtrcall.dll file. There are two versions; one is 13K and the other is 51K. The 13K Wbtrcall.dll lacks full functionality and will cause an error. Be sure the 51K version is being used. 4. Check the version of the Btrieve data file being used. When you use a Btrieve 5.1 data file, the 51K Wbtrcall.dll file is needed. However, use the Btrieve client software when connecting to a Btrieve 6x file. 5. Check the Operating System. Presently, Microsoft ships the 16-Bit Btrieve driver. If the operating system is Windows NT or Windows 95, you must get the 32-bit ODBC driver. To do this, contact Btrieve directly at 1-800-287-4383 and choosing option 3. 6. Be sure the File.ddf and Field.ddf files are located in the same directory as the .dat files. The paths to the Btrieve data files are hard-coded in the .ddf files. The Btrieve driver uses the .ddf files when connecting to a Btrieve datasource. If the .ddf files are missing, then the Btrieve driver will not be able to connect. The .ddf files can be created using a third party .ddf builder such as Xtrieve, DDF Builder, or Btrieve Scalable SQL. Xtrieve and Btreive Scalable SQL are sold by Btrieve technologies, a vendor independent of Microsoft. 7. Make sure that you have the Btrieve 2.0 ODBC driver (this comes with Visual FoxPro Professional). You need this driver to connect to a Btrieve 6x file. The Microsoft ODBC Desktop Driver Kit 1.0 comes with a Btrieve ODBC driver that can connect to Btrieve 5.1 (16-bit driver). The Microsoft ODBC desktop Driver Kit 2.0 comes with Btrieve ODBC driver, which can be used to connect to Btrieve 5.1 or Btrieve 6x. 8. Make sure there are no non-alphanumeric characters in the table name. This will usually cause "Syntax Errors" when retrieving data. File naming conventions call for standard alphanumeric characters in table names. 9. Make sure Btrieve data sources are added correctly, by following the instructions outlined here. In the Main group in the Program Manager window, double-click the Control Panel icon. In the Control Panel window, double-click the ODBC icon. a. In the Data Sources dialog box, choose the Add button. The Add Data Source dialog box appears. b. In the Installed ODBC Drivers list, select the Btrieve driver and choose the OK button. The ODBC Driver dialog box appears. c. In the Btrieve ODBC Driver dialog box, enter the Data Source Name and the Connect String information, which should be made available by the Network Administrator. The Description can be set to whatever you want. For more information about these options, press the Help button in the dialog box. 10. Make sure the correct data source name is used in the ODBC Btrieve Setup dialog box. It should be a directory name or the current directory as indicated in the Setup dialog box. 11. Make sure the Btrieve table names don't begin with SQL keywords such as Update, In, Select, Create, Drop, Alter, or any other keyword. 12. Make sure the Btrieve.trn file exists and has not been renamed. 13. Check the Win.ini file for a [Btrieve] initialization option section. The Btrieve 5.x format should contain an Options statement similar to the one in the following example: [BTRIEVE] Options=/M:64/P:4096 /b:16 /f:20/l:40/n:12/t:Btrieve.Trn 14. If the Btrieve version is Btrieve.nlm (server-based version), check the Win.ini file (for Btrieve version 5.1x) or the Novdb.ini file (for Btrieve version 6.x), and include the following command example: [BREQUESTDPMI] datalength=4096 tasks=10 local=no Chkparms=no These troubleshooting steps should resolve the majority of connection errors, in the event none of these solutions correct the problem, please contact Microsoft Product Support for further assistance. REFERENCES ========== These sample configurations will depend on your installation requirements and setup. For additional details, parameters, and options, please see your Btrieve documentation. For more information about accessing a Btrieve database, please see the following article in the Microsoft Knowledge Base. Q115837 Using the Connectivity Kit to Access a Btrieve Database Additional query words: ODBC Btrieve SQL Server Tshoot ====================================================================== Keywords : kbvfp kbvfp300b kbvfp600 Technology : kbVFPsearch kbAudDeveloper kbVFP300b kbVFP600 Version : 3.0b Issue type : kbhowto ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 1999.