Connecting to SQL Server and KeepAlive

[OneEyeMan]

Hi,
I'm trying to write a program in MSVC to connect to SQL Server and wondering if it is possible to set KeepAlive parameter on the connection from the code. Or it should be done from the ODBC Driver Manager and it can't be done from the C++.

Thank you.

[Paras Kumar]

Hi,

Yes, you can set the KeepAlive parameter on a connection to SQL Server from your code in MSVC. You can do this by setting the appropriate connection string attributes or using SQL commands in your C++ code. However, some settings might also need configuring in the ODBC Driver Manager.

Thanks!