If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unable to connect to SQL Server in Report Studio

Started by Mfg, 21 Mar 2018 12:35:32 PM

Previous topic - Next topic

Mfg

Hi,

Environment:
Cognos 10.2
Authentication: Microsoft Active Directory.

Query:
Created a data source to connect SQL Server using external namespace (MS Active directory) through OLEDB. The connection is getting succeeded when i try to test it.

But when i try to write a SQL in report studio using this data source, application gives me an error.

Please find the error below attachment

Do anybody have come across this issue. Please suggest.

Thanks in advance.
MFG

Mfg

MFG

MFGF

Quote from: Mfg on 22 Mar 2018 09:18:24 PM
:-[ any help will be appriciated...!!!!

Have you checked that the SQL is valid? Why are all your column names in square brackets?

MF.
Meep!

Mfg

I copied a working sql from SSMS. still I ll check sql by removing all unnecessary brackets.

But when I try to start a fm project using this data source I get jdbc driver error. I will post the screen shots shortly.

Thanks for your time.
MFG

MFGF

Quote from: Mfg on 23 Mar 2018 06:18:44 AM
I copied a working sql from SSMS. still I ll check sql by removing all unnecessary brackets.

But when I try to start a fm project using this data source I get jdbc driver error. I will post the screen shots shortly.

Thanks for your time.

I thought you were connecting via OLEDB? If so, you need to un-check the option in FM that says "Use Dynamic Query Mode" when creating a new project. If you want to use Dynamic Query Mode, you will need the SQL Server JDBC driver copied into webapps\p2pd\lib on your Cognos server, and you will need to define the connection on the JDBC tab of your data source connection dialog in the Admin Console.

MF.
Meep!

Mfg

Hello There,

Requirement:
Fetch Data from 2 SQL Seevers, 1 MS Analysis Services Cube.

Cube is already there in Cognos. I have created 2 data sources for 2 servers using OLEDB.
I have  created a dummy package using any one of the above data source.

I opened a report with this dummy package. Dragged 2-SQL, have given data sources which have been already created for two different sql servers, wrote 2 sql's for two different servers.

I am able to fetch Data from both of these servers using tha data sources created by writing SQL's in Report Studio. But by the moment I add cube as a package to this report, jdbc errors appear while validating the report.

In the above 2 data source I have configured only OLEDB. I am not sure about cube data source. If cube data source is using OLEDB only, making proper jdbc connections will solve the issue?

Attached screenshots for everything.

Thanks in advance.
MFG