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

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're having trouble connecting to NetSuite's ODBC. Here are a few things you might want to check: 1. Driver: Make sure you're using the correct ODBC driver provided by NetSuite. 2. Connection String: The connection string should be correctly formatted with all the necessary parameters. It should look something like 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>"

Make sure to replace

xxx

with the correct values. 3. Permissions: Ensure that the role you're using has the necessary permissions to access the data via ODBC. 4. Data Source: The data source name should be the same as the ODBC name. 5. SuiteAnalytics Connect: If you're using SuiteAnalytics Connect, make sure it's enabled for your account. If you've checked all of these and you're still having trouble, the error message suggests that there might be an issue with the string or buffer length. This could be due to a problem with the connection string or the data you're trying to retrieve. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******