Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
5 subscribers
Views
1509 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
I am trying to connect to external Microsoft SQL server database using QueryData
himanshug
over 10 years ago
I am trying to connect to external Microsoft SQL server database using QueryDatabase smart service.I configured the server URL,username,password and required query statement in the setup tab.But this is giving me below error -
(RDBMS Validation)
Errors
There was a problem during the validation of the SQL statement with the database
There was a problem in connecting to database. com.microsoft.sqlserver.jdbc.SQLServerDriver from [Module "deployment.suite.ear:main" from Service Module Loader]
Can anyone help me to get out of this....
OriginalPostID-91777
OriginalPostID-91777
Discussion posts and replies are publicly visible
Parents
0
Sathya Srinivasan
Appian Employee
over 10 years ago
Make sure you have the driver in the correct location. (see
forum.appian.com/.../Configuring_Relational_Databases)
Ideally, you should try to create a JNDI configuration where the connection is established instead of manually entering the secure credential at design time. I suggest you take that approach.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sathya Srinivasan
Appian Employee
over 10 years ago
Make sure you have the driver in the correct location. (see
forum.appian.com/.../Configuring_Relational_Databases)
Ideally, you should try to create a JNDI configuration where the connection is established instead of manually entering the secure credential at design time. I suggest you take that approach.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data