Cognos Connection Create SQL Server Database Connection

-




Cognos Connection Create SQL Server Database Connection



In this video we are going to learn about how to create a SQL Server Database connection to use it in Cognos.



In our tutorial video we used SQL Server 2005 as a Database Server. Steps are same for other database

1. SQL Server 2005

2. SQL Server 2008

3. SQL Server 2008 r2

4. SQL Server 2012

5. SQL Server 2014

6. SQL Server 2016

7. SQL Server 2017



We know this video is too long for a simple database connection but covered 5 ways to connect SQL Server Database.



We also face an issue while trying to connect SQL Server Database using ODBC. Below is error details



QE-DEF-0285 The logon failed.

QE-DEF-0325 The logon failed for the following reason:

RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:

    testDataSourceConnection



UDA-SQL-0031 Unable to access the "testDataSourceConnection" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.

UDA-SQL-0107 A general exception has occurred during the operation "attach".

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

BME-EX-0144 Trace back:

BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction

BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction

QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()

QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()

QFSSession.cpp(2034): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()

Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE

Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE



Script Stack Trace



Action No=1   Action Name=TestDataSourceConnection



For resolving this issue we need to change IBM Cognos Services Log on account.





Useful URL:

Our Website: https://vlemonn.com

Comments

Post a Comment

Popular posts from this blog

Android Download File from WebView using Kotlin

-
In this video, we will learn How to handle the file download for a Web View using Kotlin Programming Language? We will cover following points in the video 1. Check External Storage Permission 2. Download Listener 3. DownloadManager.Request 4. allowScanningByMediaScanner() 5. setNotificationVisibility 6. setDestinationInExternalPublicDir 7. webView.setDownloadListener Tutorial Post: https://vlemon.com/blog/android/android-webview-how-to-download-a-file-using-kotlin Support Us: PayPal: https://www.paypal.me/vlemonn Patreon: https://www.patreon.com/vlemonn Useful URL: Our Website: https://vlemon.com Tutorial Post: https://vlemon.com/blog/Android/android-webview-how-to-download-a-file-using-kotlin Facebook: https://www.facebook.com/VlemonStudio Twitter: https://twitter.com/vlemonstudio Google Plus: https://plus.google.com/+MayankSanghvivlemonn YouTube: https://www.youtube.com/c/mayanksanghvi Whats App: +91-8818882120 (Only for Vlemon Premium Users) Hire Me: Charges may apply.
Read more

How to Install Unity3D in MAC OS High Sierra

-
Image
How to Install Unity3D in MAC OS High Sierra In this video, we are going to download and install Unity3D on our MAC OS High Sierra This video is the first step in our other tutorial video. Check the following tutorial series related to this video 1. Unity3D Game Development 2. Unity3D 2D Game Development Support Us: PayPal: https://www.paypal.me/vlemonn Patreon: https://www.patreon.com/vlemonn Useful URL: Our Website: https://vlemonn.com Facebook: https://www.facebook.com/vLemonn Twitter: https://www.facebook.com/vLemonn Google Plus: https://plus.google.com/112993831877465971811 Whats App: 8818882120
Read more

Adobe XD Symbols : Status and Navigation Bar

-
Image
How to use Symbols in Adobe XD CC 2018 In this video, We are going to create Status Bar and Navigation Bar. Finally, we will convert it into the Symbols so we can use it on multiple Artboards. Tutorial Post: https://vlemonn.com/tutorial/adobe-xd... If you want to download the Adobe XD Document for this video, visit the tutorial article page. Key Points 1. What is Symbols in Adobe XD CC 2018? 2. Why to use Symbols in Adobe XD CC 2018? 3. How to use Symbols in Adobe XD CC 2018? 4. Create a Status Bar in Adobe XD CC 2018. 5. Create a Navigation Bar in Adobex CD CC 2018. 6. Combine multiple Symbols. Note: If source code is not updated, please let us know. Support Us: PayPal: https://www.paypal.me/vlemonn Patreon: https://www.patreon.com/vlemonn Useful URL: Our Website: https://vlemonn.com Tutorial Post: https://vlemonn.com/tutorial/adobe-xd... Facebook: https://www.facebook.com/vLemonn Twitter: https://www.facebook.com/vLemonn Google Plus: https://plus.google.com/...
Read more