I am querying from SQL server database using the ODBC stage.
The query is just selecting a single column from the source table.
I have created a ODBC Connection string in the DS Server. I have a user name / pwd for the same. I validated the test connection in the Server.
When entering the "Data Source Name", "username", "Password" in the ODBC stage and clicking the "Get SQL Info" button throws an error as follows:
Not sure how this is happening.DSR.MetaGeta(GET.DSNINFO)(SQLConnect('DSMISSqlSvr','MISCENTRALINTEGRATION')): BCI Error:
SQLSTATE=37000,CODE=4060,[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'MIS'. Login fails.
If anyone has any thoughts please share.
Have to do a delivery by today.
Regards,