Hi Guys,
I am trying to connect Microsoft SQL Serv...
# suitescripta
AB
09/21/2022, 1:33 PMHi Guys,
I am trying to connect Microsoft SQL Server Management Studio with NetSuite but am unable to connect. Here is the screenshot,
Can someone help on this?
c
Craig
09/21/2022, 8:53 PMYou're out of luck, I just removed my config that I was using for a previous client.
Craig
09/21/2022, 8:54 PMI used the JDBC driver; you need to make sure to get the connection string correct, that was the key part for me.
a
AB
09/22/2022, 4:42 AMHi @Craig, Yes, the connection string is correct
c
Craig
09/22/2022, 1:42 PMDid you use a driver downloaded from NetSuite or something that shipped with SQL server studio?
a
AB
09/22/2022, 2:48 PM@Craig yes, I am using Netsuite Driver
c
Craig
09/22/2022, 2:49 PMand all the usual checks? - permissions, the feature being enabled on the account
Craig
09/22/2022, 2:49 PMI think JDBC access needs SuiteConnect enabling
a
AB
09/22/2022, 2:50 PMYes, I gave permission
c
Craig
09/22/2022, 2:50 PMI see you're using netsuite2
Craig
09/22/2022, 2:51 PMI think I only used netsuite
Craig
09/22/2022, 2:51 PMNetSuite2 has a different table structure for analytics I think
Craig
09/22/2022, 2:51 PMYour connection string looks very short too
a
AB
09/22/2022, 2:51 PMI am getting error if I use NetSuite only
AB
09/22/2022, 2:52 PMI added Username, role etc... in string but still getting error.
c
Craig
09/22/2022, 2:52 PMmessage has been deleted
Craig
09/22/2022, 2:52 PMMy string was something like that
a
AB
09/22/2022, 2:53 PMI am not using JDBC
AB
09/22/2022, 2:53 PMI am using ODBC
c
Craig
09/22/2022, 2:53 PMmessage has been deleted
Craig
09/22/2022, 2:53 PMNo idea about ODBC - would assume it's the same sort of thing but maybe not
Craig
09/22/2022, 2:53 PMcopy that videp
Craig
09/22/2022, 2:54 PMMaybe even try using DataGrip then when it's working there, try to copy the conf over to your MS tool.
a
AB
09/22/2022, 2:54 PMOkay, checking
AB
09/22/2022, 8:12 PMHi @Craig, there was an issue in the Data source. NetSuite support team helped with this.
Thanks!
👍 1
c
Craig
09/23/2022, 1:22 PM@AB What data source string did you end up using?
a
AB
09/23/2022, 1:35 PMHi @Craig, data source name should be same as odbc name
👍 1
24 Views