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 DSN Data Source (User / System DSN)

Use this method to capture ZappySys driver specific calls / errors. 

First open your ZappySys ODBC DSN (search odbc in start menu and click on ODBC Data Sources)

1. Search for ODBC in 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

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

Enable logging for 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 General Tab and Configure Logging (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 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 ZappySys Logging Engine. Dis advantage of this method is it will log all DSN created for that machine (Not only ZappySys DSN but all).

To enable System level ODBC Trace perform these steps.

1. Search ODBC in the start menu and launch ODBC Data Sources Administrator
2. Go to 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\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. Go to C:\Program Files\ZappySys ODBC PowerPack\JdbcBridgex64
6. Repeat step 2 to 4 for above path

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/