It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×10,908
×7,383
×5,997
×12
×2
×2

question asked: Jan 20 '15, 4:29 a.m.
question was seen: 4,305 times
last updated: Jan 20 '15, 5:11 a.m.

Related questions

FAQ - How this Forum works

Why do I get an “A connection could not be obtained" error for the SAP Connector?

0
Gerd Schiering (122●1●13●16) | asked Jan 20 '15, 4:29 a.m.
JAZZ DEVELOPER
edited Jan 20 '15, 5:11 a.m.
Setting up the IBM Rational SAP Connector with an MS SQL server database throws a connection error when accessing projects in the UI in the web browser.


jdbc error message 


"A connection could not be obtained for driver class "com.microsoft.sqlserver.jdbc.SQLServerDriver"....  
You may have specified an invalid URL."

The same message details is also found in
C:\IBM\SapConnector\server\tomcat\logs\localhost.2015-01-15.log

The DB server can be accessed from RQM without errors and other databases on that same SQL server can be reached as well.


One answer

Most liked answers|Newest answers|Oldest answers ↑

0
permanent link
Gerd Schiering (122●1●13●16) | answered Jan 20 '15, 4:32 a.m.
JAZZ DEVELOPER

The root cause was a missing semicolon at the end of the jdbc connection string property in

C:\IBM\SapConnector\server\conf\sapconnector.properties

A semicolon: ";" is needed to terminate each line in the sapconnector.properties file.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.