Solved
SQL Insert / SQL Server Execute Snaps
We have a process today that does a SQL insert into a transactional database and returns the ID value for use in later steps. We have tried the SQL INSERT SNAP and ID is not returned. Also tried th...
Forum Discussion
hi @pvsharish9 ,
Is the user emp added to the DB where you trying to connect to? with the right password?
If Yes,
Which JDBC Jars are you using have you tried this?
JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
And maybe try also only with this Url properties:
- selectMethod : cursor
Or do you need those other properties?
Advanced properties:
Regards
Jens
