Hello team,

I know this is an old thread but I need to know if the same logic applies to the first time a call is made grammatically from a C# Controller?
I am able to connect to the API using a browser( Chrome, IE, ,etc), but my controller keeps returning a NULL object because the API is returning "401 not found".

Kind regards,

Craig

Thank you Prasanna,

It was the driver version that was incorrect. Reverted to version 4.1 from 6.2.2 and reconfigured the JDBC Provider and Sources to reflect the correct details and the issue was resolved.

Have a fantastic day.

Cheers,
Craig

Hi Prasanna,

Thank you for coming back to me so soon.

1. URL == jdbc:sqlserver://mdrcsql04/sql03 (Must it have the database name in it? ;database=Breeze_Call_Priority)
If I use this URL {jdbc:sqlserver://mdrcsql04/sql03;database=Breeze_Call_Priority} then the connection fails saying (Invalid URL format - only letters, digits and [.-:/@;&%=#?] are allowed.)
2. User Name == Witness
3. JNDI Name == JDBC-Connection
4. sqljdbc jar version == sqljdbc41.jar
5. Driver class name from JDBC provider for your data source == com.microsoft.sqlserver.jdbc.SQLServerXADataSource

Regards,

Craig

Hi guys, I'm getting the same error on a MS SQL connection from the ED.
The System Engineer has installed the driver and configured the JDBC Provider and Source on SMGR.
Any ideas why I would still get this error from the snap-in?
I have added custom property "generateSimpleParameterMetadata" set to "true" to the JDBC Source config.