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
"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?
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.