Issues connecting to Smartsheets

Mike@EE

Hello,

Other areas of the business are exploring the use of smartsheet and they would like to connect our existing analytics tool (spotfire) to use smartsheet as a data source.

I've followed:

http://smartsheet-platform.github.io/odbc-docs/

and successfully installed the ODBC smartsheet driver, created a DSN, successfully connected but only when I am not on the corporate network (ie at home or through my iPhone as a hotspot)..

When I try to connect from the office I get the error:

An unexpected error occurred trying to contact the smartsheet service. Please verify that you are connected to the Internet and all network proxy settings are correct. (Exception code: 'The operation timed out (WIN32: 0x00002EE2)')

 

I've put in the proxy server config (the same as my browser) and I worked with the network guys but they say I need to find out what server, port number and protocol the smartsheet ODBC connection is using so they can allow the proxy server to pass this through. I installed fiddler to capture the http traffic but I could not see anything.

Shaine Greenwood

Hello,

Please reach out to our Support team to troubleshoot this further. I'm not sure if we're able to provide specifics on our server and port, but they can work with you on a solution.

Mike@EE

Thanks Shaine, will do.