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

Data Manage Connectivity Issues

Started by aliclowes, 17 Mar 2020 06:21:26 AM

Previous topic - Next topic

aliclowes

Hi

We are still using data manager, due to ODBC restrictions, however we have been experiencing issues of late where by there are connectivity issues when trying to connect to our SQL Server database, theses appear to be random and not always at the same time or in the same Jobstream

Does anyone have any ideas as to how to either investigate or monitor or fix

thanks

Alison

ROBER82167

"Of late" suggests something in your environment has changed. Random connectivity issues are not likely to be an issue with Data Manager itself; more likely network or possibly SQL Server.

Any examples of the error messages from SQL Server?

MFGF

Quote from: aliclowes on 17 Mar 2020 06:21:26 AM
Hi

We are still using data manager, due to ODBC restrictions, however we have been experiencing issues of late where by there are connectivity issues when trying to connect to our SQL Server database, theses appear to be random and not always at the same time or in the same Jobstream

Does anyone have any ideas as to how to either investigate or monitor or fix

thanks

Alison

Hi Alison,

Is there a specific reason you're using ODBC to connect to SQL Server? Data Manager also supports the ability to connect to SQL Server using the SQL Server Native Client. It's a little newer (and less restrictive) than connecting via ODBC, and you might see better data throughput.

If you're stuck with ODBC, I'd be looking at running an ODBC Trace to see what is happening when you get connectivity issues. Also, are you seeing anything in your Data Manager build logs that pinpoint a specific error code from the database or ODBC driver?

Good luck!

MF.
Meep!