Netsuite Connectivity Issue

Question

Netsuite Connectivity Issue

Bigiron 110

Hi,

I have a requirement to load data from Netsuite to Azure SQL Database. I created a new VM and installed SHIR successfully. I downloaded and created ODBC 64 bit driver , but when I tried to create a linked service I am getting the following error

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Activity ID: d7c77aea-9635-48bb-86a2-ebaa4352ad62.

DRIVER={NetSuite};User ID=******@abc.com;Password=12345;Account ID=437102

Please advice.

Thanks

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-07-25T05:53:11.2133333+00:00
Hi Bigiron,

Thank you for posting query in Microsoft Q&A Platform.

The error message you are seeing indicates that the ODBC driver is not installed correctly or the Data Source Name (DSN) is not configured properly. Here are some steps you can follow to troubleshoot this issue:

Verify that the ODBC driver is installed correctly on the VM. You can do this by checking the installation directory for the driver files. The driver files should be located in the C:\Windows\System32 directory for a 64-bit driver.

Verify that the DSN is configured correctly. You can do this by opening the ODBC Data Source Administrator tool on the VM and checking the DSN configuration. Make sure that the DSN name matches the name you are using in the linked service configuration.

Verify that the ODBC driver is listed in the System DSN tab of the ODBC Data Source Administrator tool. If the driver is not listed, you may need to add it manually.

Verify that the linked service configuration is correct. Make sure that the DSN name and other connection details are correct. You can also try using a different driver, such as the ODBC Driver for SQL Server, to see if that resolves the issue.

Check the permissions for the ODBC driver files and the DSN configuration. Make sure that the user running the ADF pipeline has the necessary permissions to access the driver files and the DSN configuration.

If you are still having issues, try restarting the VM and/or the ADF Integration Runtime to see if that resolves the issue.

Please let me know how it goes. Thank you.
Bigiron 110 Reputation points

2023-07-25T14:26:07.21+00:00

@ShaikhMaheeThanks, have you seen my screen shot? the DSN is same as that on the ODBC Administrator that was mentioned in the connection string and yes everything is done as you mentioned but still the same error

2 answers

Your answer

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-07-25T05:53:11.2133333+00:00

Hi Bigiron,

Thank you for posting query in Microsoft Q&A Platform.

The error message you are seeing indicates that the ODBC driver is not installed correctly or the Data Source Name (DSN) is not configured properly. Here are some steps you can follow to troubleshoot this issue:

Verify that the ODBC driver is installed correctly on the VM. You can do this by checking the installation directory for the driver files. The driver files should be located in the C:\Windows\System32 directory for a 64-bit driver.

Verify that the DSN is configured correctly. You can do this by opening the ODBC Data Source Administrator tool on the VM and checking the DSN configuration. Make sure that the DSN name matches the name you are using in the linked service configuration.

Verify that the ODBC driver is listed in the System DSN tab of the ODBC Data Source Administrator tool. If the driver is not listed, you may need to add it manually.

Verify that the linked service configuration is correct. Make sure that the DSN name and other connection details are correct. You can also try using a different driver, such as the ODBC Driver for SQL Server, to see if that resolves the issue.

Check the permissions for the ODBC driver files and the DSN configuration. Make sure that the user running the ADF pipeline has the necessary permissions to access the driver files and the DSN configuration.

If you are still having issues, try restarting the VM and/or the ADF Integration Runtime to see if that resolves the issue.

Please let me know how it goes. Thank you.
Bigiron 110 Reputation points

2023-07-25T14:26:07.21+00:00

@ShaikhMaheeThanks, have you seen my screen shot? the DSN is same as that on the ODBC Administrator that was mentioned in the connection string and yes everything is done as you mentioned but still the same error

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 2

ShaikMaheer-MSFT 38,546 Microsoft Employee Moderator

Hi Bigiron,

Glad to know your issue resolved. Mentioned resolution details for community benefit too.

Below format of connection string helped to resolve issue.

DRIVER=NetSuite Drivers 32bit;Host=<ServiceHost>;Port=1708;Encrypted=1;AllowSinglePacketLogout=1;Truststore=system;SDSN=NetSuite.com; UID=******@netsuite.com;PWD=<password>;CustomProperties=AccountID=<accountID>;RoleID=<roleID>

Kindly consider hitting Accept Answer button. Accepted answers help community as well. Thank you.

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-07-31T07:39:39.5933333+00:00

Hi Bigiron, Just checking if you get chance to mark above answer as accepted answer. Please note, accpeted answers help community as well. Thank you.

Share via

Netsuite Connectivity Issue

2 answers

Your answer