How to enable Logging for ODBC PowerPack

There will be a time when you like to troubleshoot more about ODBC PowerPack Errors. Basically there are two ways you can log ODBC requests. 

Enable logging for ZappySys ODBC Driver (User / System DSN)

Use this method to enable logging for ZappySys ODBC drivers so you can capture errors and other details. 

1. Search for ODBC in the Start menu and open ODBC Data Sources
2. Find your DSN on Users or System Tab
3. Double-click DSN to edit. and configure logging as below
4. Click on Advanced View (some drivers e.g. Salesforce / JDBC Bridge dont have Advanced View then look for the Logging section on UI)
5. Change Log Level to other than None (e.g. change to Debug) 
6. Enter log file path (e.g. c:\temp\mydata.log)
7. Click OK to save UI

Enable Logging

Click on the Advanced View option and specify LogLevel and Log File Location.

NOTE: Log level = Info will generate too much log so do not use it unless asked by zappysys support team or you have a special troubleshooting need.

NOTE: After you done logging make sure to disable logging else it may fill up your disk space in old version. New version has Rolling log (default 50mb)

Enable logging for ZappySys Gateway Data Source

If you have to enable Logging for Gateway Data Source then there are 2 places you can enable Logging. 

Enable Service Level Logging

1. Search Gateway in Start menu and open ZappySys Data Gateway
2. Go to the General Tab and change Log level (e.g. Debug). Do not set Logging=Info unless you need. It generates maximum log)

Enable Data Source Level Logging

Now lets see how to enable Data Source Level Logging.

1. Go to Data Source Tab
2. Click on Edit link for desired Data Source you like to log
3. Perform following actions to enable logging once UI appears.

Click on the Advanced View option and specify LogLevel and Log File Location.

NOTE: Log level = Info will generate too much log so do not use it unless asked by zappysys support team or you have a special troubleshooting need.

NOTE: After you done logging make sure to disable logging else it may fill up your disk space

Enable System Level ODBC Trace (Global Logging for all DSN)

There is another way to capture details for ODBC calls. Open ODBC Manager (Type odbc in start menu open ODBC Data Sources). This is OS feature and it by passes the ZappySys Logging Engine. Dis advantage of this method is it will log all DSN created for that machine (Not only ZappySys DSN but all).

NOTE: 32bit vs 64 bit Tracing is separate so pick correct ODBC UI below in Step#1  

To enable System level ODBC Trace perform these steps.

1. Search ODBC in the start menu and launch ODBC Data Sources Administrator
   Choose 64bit if your App is 64bit else choose 32bit ODBC
   
   
   
   
2. Go to the Tracing Tab you can specify the Tracing file path (i.e. log file) and click Start Tracking. In some cases, you may have to check Machine wide tracing for all user (specially when the driver is called by the service account). 
3. Click on Start Tracking Now

NOTE: After you done logging make sure to disable logging else it may fill up your disk space

Enable JDBC Bridge Logging

If you like to enable detailed logging for JDBC Bridge then perform the following steps

1. Go to C:\Program Files (x86)\ZappySys ODBC PowerPack\JdbcBridgex86
2. Create a new file named "JdbcBridge.properties"
3. Enter the following value in text file

4. app.logfile= c:/temp\JdbcBridge_log.txt

5. Copy the same properties file to the following 2 locations
   C:\Program Files (x86)\ZappySys\ZappySys ODBC PowerPack\JdbcBridgeDriverX64
   C:\Program Files (x86)\ZappySys\ZappySys ODBC PowerPack\ZappySys.TdsServer.WindowsService

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/