I was able to get this figured out with some research on here, by adding the following two lines of code I corrected the issue:
JDBC_setProp(prop: 'encrypt' : 'true');
JDBC_setProp(prop: 'trustServerCertificate' : 'true');
Search found 3 matches
- Tue Jan 30, 2024 6:32 pm
- Forum: JDBCR4
- Topic: Error connecting with JDBCR4
- Replies: 2
- Views: 2231
- Tue Jan 30, 2024 4:52 pm
- Forum: JDBCR4
- Topic: Error connecting with JDBCR4
- Replies: 2
- Views: 2231
Re: Error connecting with JDBCR4
I attached the errors that I'm seeing when it tries to connect, it looks like it might be certificate related or some security setting
- Java connection errors 1-30-24.png (214.05 KiB) Viewed 2222 times
- Tue Jan 30, 2024 3:33 pm
- Forum: JDBCR4
- Topic: Error connecting with JDBCR4
- Replies: 2
- Views: 2231
Error connecting with JDBCR4
I'm getting the following error from JDBCR4 when I attempt to connect to our MS SQL database, how would I go about troubleshooting the cause? Thanks, Michael Smith Message . . . . : Java Virtual Machine is IBM Technology for Java. PID(31290) Cause . . . . . : JAVA_HOME environment variable is /QOpen...