Thursday, September 20, 2018

Install and Use ODBCTest for testing ODBC connection timeout and errors

Customer is reporting a connection problem on their ODBC for Netsuite.
They are using a third-party application and is generating an error that might not be understandable for the QA and Development team to find out the real problem.

QA and Dev team has recommended this simple application to verify the connection being made for ODBC.
 
Installing the ODBCTest

1. Download from http://www.datadirect.com/support/downloads/tools/index.ssp
2. Select OdbcTest(unicode)
3. Save the compressed file odbcunicode.zip, and extract.
4. Run ODBCT32W.EXE

Using the ODBCTest

1. On ODBC Test (UNICODE) window, click Conn and select Full Connect
2. On Full Connect window, select NetSuite.com
3. Type in your Username and Password for the account
4. Successful connection should be made (see example)

Full Connect(Default)
Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

Successfully connected to DSN 'NetSuite.com'

5. Run the SQL query of the customer that seems to get the error.
6. Click on Run (!) Exclamation icon.
7. Check on the logs at the bottom.

Full Connect(Default)
Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3
Successfully connected to DSN 'NetSuite.com'

No comments:

Post a Comment