Why doesn't my ODBC Klip display any data?

Problem:

Your ODBC Klip is not displaying any data.

Solution:

Note: This article discusses advanced features that are only available in the licensed, commercial version of Klipfolio Dashboard.

Here are the top 3 commonly asked questions about writing an ODBC Klip using Klipfolio's ODBC engine.

Be sure to read through the how-to article on writing an ODBC Klip first.

How do I know if my connection string syntax is correct?

The syntax for the connection string differs depending on what kind of database server you are trying to connect to. Refer to your database software's documentation, or try looking it up on the web. Many develpers have found http://www.connectionstrings.com/ to be very useful as well.

Can I get some indication as to what the problem is with my Klip?

You can get error output into the Debug Window if you use JavaScript to set up your connection string and query. The easiest way for this is to use our sample ODBC Klip that uses JavaScript, which includes the Engines.ODBC.getLastError() function in its script to output errors from your ODBC driver.

Why does my Klip say "0 0" instead of the expected data?

This would indicate that your Klip has been able to successfully retrieve data from your database, but your stylesheet doesn't match the returned data format. Read the Stylesheet and How can I tell what the returned XML data looks like? sections of the how-to article on writing an ODBC Klip to make adjustments to your <style> block.