does anyone know how to connect to the Netsuite’s ODBC to make an SQL request? I tied this:

isql -v "DRIVER={/var/task/config/odbcclient/lib64/libodbc.so};HOST=<http://xxx-sb1.connect.api.netsuite.com;PORT=1708;ServerDataSource=NetSuite2.com;AccountID=xxx_SB1;RoleID=3;AuthenticationType=TBA;ConsumerKey=xxx;ConsumerSecret=xxx;Token=xxx;TokenSecret=xxx;UseSSL=true;EncryptionMethod=SSL|xxx-sb1.connect.api.netsuite.com;PORT=1708;ServerDataSource=NetSuite2.com;AccountID=xxx_SB1;RoleID=3;AuthenticationType=TBA;ConsumerKey=xxx;ConsumerSecret=xxx;Token=xxx;TokenSecret=xxx;UseSSL=true;EncryptionMethod=SSL>"

(replacing

xxx

with the correct value) But I keep having this issue:

[S1090][unixODBC][Driver Manager]Invalid string or buffer length
[ISQL]ERROR: Could not SQLConnect

IIRC it won't let you connect to that using the Administrator role. Try using a different role that has the proper permissions.

thank you @RJMNS! It is common to have an error message that is not realy describing the problem?

It happens. 🤷 Though NS Support might tell you that using the Admin role constitutes an "invalid string." 🙂