|Subject:||Troubleshooting Salesforce connection using ODBC|
|Creation date:||11/7/23 11:24 AM|
|Last modified on:||11/7/23 12:08 PM|
This page provides some useful tips if you run into problem connecting WinSQL to Salesforce.
The most common problem when connecting to Salesforce is related to the following error:
There are two main reasons for this error:
If this entry is missing, create it manually using the following steps:
C:\ProgramData\WinSQL\Drivers64\java\lib\sforce.jar, which is the location of the JAR file. Ensure the file exists.
where java.exe where jvm.dll
Both commands should return the path where these files are located. If any of these return an error, modify the PATH variable on your machine and add the folder containing these files. Note that these files are in different folders.
Assume java.exe is located in
C:\Program Files\java8\bin\java.exe, JVM.DLL will most likely be in
C:\Program Files\java8\jre\bin\server. You will need both of these folders in your System PATH variable.
Do you have a helpful tip related to this document that you'd like to share with other users?