When attempting to connect to SAP ERP using our driver, you may encounter an error related to the SAP JCo library not being found. This issue can be resolved by ensuring that the correct JAR file is present and configuring the necessary native libraries.
To resolve the "SAP JCo library not found" error, follow these steps:
Retrieve Native Libraries from SAP: To connect to SAP ERP using our driver, you will need the native libraries from SAP. These libraries can be obtained from SAP directly.
Copy the JAR and DLL Files: Once you have obtained the required JAR and DLL files from SAP, place them in the following default directory on your system:
C:\Program Files\CData\CData JDBC Driver for SAP ERP 2023\lib
Opening the JAR File: It's important to note that the process for opening the JAR file in SAP ERP is slightly different. Attempting to double-click the cdata.jdbc.saperp.jar and entering your credentials may result in the "library not found" error.
Using Command Prompt (CMD): To open the JAR file correctly, follow these steps:
Open a Command Prompt (CMD).
Navigate to the default directory where the JAR files are located.
cd C:\Program Files\CData\CData JDBC Driver for SAP ERP 2023\lib
Enter the following command:
java -cp "sapjco3.jar;cdata.jdbc.saperp.jar" cdata.jdbc.saperp.SAPERPDriverMain
After executing the command, the JAR file will be opened, allowing you to enter your SAP ERP credentials. If the credentials are correct, you should see a successful test connection.
Once a successful connection is established, it's necessary to add the SAP ERP JAR file to the Classpath of the tool you intend to use for running the solution.
If you encounter any other issues don't hesitate to reach out to CData Support for assistance.