Author Topic: Data Manage Connectivity Issues  (Read 3067 times)

Offline aliclowes

  • Full Member
  • ***
  • Join Date: Jan 2010
  • Posts: 12
  • Forum Citizenship: +0/-0
Data Manage Connectivity Issues
« 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

Offline ROBER82167

  • Full Member
  • ***
  • Join Date: Jul 2012
  • Posts: 7
  • Forum Citizenship: +1/-0
Re: Data Manage Connectivity Issues
« Reply #1 on: 19 Mar 2020 02:20:05 am »
"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?

Online MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,073
  • Forum Citizenship: +657/-10
  • Cognos Software Muppet
Re: Data Manage Connectivity Issues
« Reply #2 on: 20 Mar 2020 03:50:30 pm »
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!