SUP Connecto To SQL Server Strange Behavior

[Former Member]

Hello!

A strange situation is happening

In my aplication I Need and MBO to connect to SQL Server database.

And I Have 3 databases, One for DEV(Development) other for QA(Quality) and other to PRD(Production).

The Problem is that when I  configure the PRD or QA Database in SUP Workspace the results returned by the MBO are all from DEV database

What i change in the conection is just the URL, that are the following for DEV, QAS and PRD.

I Also configured the Connection in SCC so I dont know what I'm doing Wrong.

jdbc:sqlserver://<MachineIP>:1433;databaseName=AppDEV

jdbc:sqlserver://<MachineIP>:1433;databaseName=AppQAS

jdbc:sqlserver://<MachineIP>:1433;databaseName=AppPRD

Thanks a lot guys

Laguerta

[Jitendra_Kansal · Accepted solution]

You can create 3 different workspaces and import project from dev to QA and to PRD. Keep the same SQL DB connection name in all workspaces so that you dont need to bind its connection to MBO(s) explicitly.

eg. In DEV workspace, you have CONNECTION NAME as SQLDEV, in the settings you must have provided DEV backend details. Keep the same name "SQLDEV" in other workspaces but change the backend details respectively.

I hope it makes sense now.

Regards

JK

[Former Member · Accepted solution]

Hello Jitendra!

The problem was that the queries definition has the db in the query.

something like:

Select * from <SQLServer DEV Data-base>.dbo.<SQLServer Table>

Even the connection is pointing to QA the MBO brings DEV data.

Its Strange.

Thanks for your time,

Laguerta