# Q2 Driver Tips of the Quarter

**URL:** <https://community.cdata.com/t/q2-driver-tips-of-the-quarter/158>\
**Category:** CData Drivers\
**Tags:** discussion, newsletter, driver\
**Created:** [April 24, 2023, 3:41pm UTC](https://community.cdata.com/t/q2-driver-tips-of-the-quarter/158 "2023-04-24T15:41:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lori](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lori/32/1929_2.png) [@Lori](https://community.cdata.com/u/Lori)\
**Post date:** [April 24, 2023, 3:41pm UTC](https://community.cdata.com/t/q2-driver-tips-of-the-quarter/158/1 "2023-04-24T15:41:08Z")

</div>

Whether you are a new or an existing customer using CData connectivity drivers, here are a couple of helpful tips.

**Tip #1:&nbsp; Turn on logging**

Logging is a very valuable feature that helps support help you if you run into errors or issues.

There are four types of logging

1. **Basic Logging** – is a filepath that designates the name and location of the log file
2. **Log Verbosity** – there are five levels of verbosity which determines the amount of detail in the log
3. **Sensitive Data** – is found in verbosity levels 3 and higher and you may not want to share this information outside of your organization (see details in the article link below)
4. **Advanced Logging** – is used to refine the exact information recorded in the log file (see details in the article link below)

The logging options are basically the same for all editions ([ADO.NET](http://ADO.NET), ODBC, JDBC, SSIS, etc.)

Here is a [detailed technical logging article](https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcdn.cdata.com%2Fhelp%2FRFH%2Fado%2Fpg_advancedlogging.htm&data=05%7C01%7Clorettag%40cdata.com%7C50692a7ee819494cb4a308dafa5ac62e%7Cbf6e4267a9fb419bae7b7586fab0ff66%7C1%7C0%7C638097565028512582%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=u%2Bt%2BcalbxOrz6zfK%2BU8RKCuUGhRSMKExf8PE9GSjFAc%3D&reserved=0) with definitions, and for turning on logging.

**Tip #2** : **Creating linked server connections using SQL Gateway with ODBC Drivers**

Many organizations need access to data from outside of SQL Server, for example, desktop applications, flat files, on-prem SharePoint, etc. Linked Servers give you virtual access to data from within your SQL Server interface. Typically, it’s used to allow access to a remote SQL Server database from within a local database. With CData, you can access non-SQL Server data in the same way.

Using&nbsp;a CData ODBC driver to connect to any ODBC data sources as a linked server.&nbsp;Reference this article for the detailed steps: [https://www.cdata.com/kb/articles/sqlgateway-linked-server.rst](https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cdata.com%2Fkb%2Farticles%2Fsqlgateway-linked-server.rst&data=05%7C01%7Clorettag%40cdata.com%7C50692a7ee819494cb4a308dafa5ac62e%7Cbf6e4267a9fb419bae7b7586fab0ff66%7C1%7C0%7C638097565028512582%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Fu8oECibKjeYXmC%2B6SCJl2OGU468ntHr44TD5p54XZE%3D&reserved=0)