Forum Discussion
New2API
7 years agoFrequent Contributor
Hi, looks like in your connection string you have a '\'. (I have highlighted in red)
def sql =Sql.newInstance("jdbc:sqlserver://LRO-QA-SQL\QADB3;Database=DBname;integratedSecurity=true","com.microsoft.sqlserver.jdbc.SQLServerDriver")
}
def row = sql.firstRow("select top 1 from community")
see if you can use SQL server name without any instance or try using a escape character as shown below.
def sql =Sql.newInstance("jdbc:sqlserver://LRO-QA-SQL\\QADB3;Database=DBname;integratedSecurity=true","com.microsoft.sqlserver.jdbc.SQLServerDriver")
}
def row = sql.firstRow("select top 1 from community")
Regards!
Related Content
- 4 years agoPUM-Prodat-SQL
- 7 years agoGaleG
Recent Discussions
- 6 days agoruchisingh