Troubleshooting connection errors
Posted: Mon Mar 28, 2022 5:28 pm
I'm using JDBCR4 to attempt connection to a SQL Server database. I've written several other programs that connect to one MSSQL database. But this is a new database, and I'm having issues. The error that gets returned by jdbc_ConnProp() is "Login failed for user."
I have an SQL client running on my laptop where I can connect directly to the database and run statements against my tables. It's using the same connection credentials that my program is using. It works and my program doesn't. This makes me confident I'm using the correct user name and password. I must have some issues with one of the other connection properties. I just can't figure out which one.
When JNI_CHECKERROR runs it spits out the java exception list to the screen, but I can't see the top of the list, and I can't do anything with it. The screen holds for 10 seconds and the exception list is gone. How can I go back and view that JVM console log after my program shuts down? I think if I could get a look at the java exceptions that get through by my connection attempt, I might be ale to figure this thing out.
I have an SQL client running on my laptop where I can connect directly to the database and run statements against my tables. It's using the same connection credentials that my program is using. It works and my program doesn't. This makes me confident I'm using the correct user name and password. I must have some issues with one of the other connection properties. I just can't figure out which one.
When JNI_CHECKERROR runs it spits out the java exception list to the screen, but I can't see the top of the list, and I can't do anything with it. The screen holds for 10 seconds and the exception list is gone. How can I go back and view that JVM console log after my program shuts down? I think if I could get a look at the java exceptions that get through by my connection attempt, I might be ale to figure this thing out.