How does a DSN connection string look?
Issue resolved. When requesting a database I did not specify the need for a static port. I assumed the port would be the typical static default port. As a result my database was created using dynamic ports. I went back to the Database team and specified that I needed a static port. They moved my database to an instance with a static port and now I’m able to connect.
You can create a data object to pull information from another database using the Query Builder > Add Data Source:
Manage Data Objects - CA Service Management - 14.1 - CA Technologies Documentation
We tried it that way. Get failed connection
What is the exact error you receive after selecting 'Test' from the 'Add Data Source' page?
You can also check ..\Service Catalog\logs\view.log after running the 'Test' to see what the exact exception is.
still need help?
Answer from Jason is the way to go. What error do you receive?
Thanks for the reply. Yes I still need help. I’ve been talking to Jason. I don’t get any errors. If I have a table with three rows and I select the second row, when it is submitted to the cart it will always default back to the first row being selected. I can’t get the values to transition to the cart.
Hi wes3 - Did Jason_Wolfe's response help answer your question? If so please mark as Correct Answer. Thanks!
No it didn’t work for us. Not sure where we are going wrong.
I am working with wes3. We are having trouble adding the data source. Can you give an example of the ODBC DSN that needs to be entered?
I created an 64-bit system dsn using SQL Server Native Client 11.0 as an example with a name of '< my hostname> dsn'.
When adding the data source in the query builder I entered the same dsn name string above ('< my hostname> dsn') along with the same credentials and the 'Test' returned successful.
Retrieving data ...