isql -v NetSuite produces just the error of [ISQL]ERROR: Could not SQLConnect

Hi,

I have a 64 bit unixODBC driver, and I have installed a 64 bit Netsuite ODBC driver on the machine. I have configured the odbc64.ini and odbcinst.ini as shown below:-

odbc64.ini-

[ODBC Data Sources]
NetSuite=NetSuite ODBC Drivers 7.2

[NetSuite]
Driver=/opt/netsuite/odbcclient64/lib64/ivoa25.so
Description=Connect to your NetSuite account
Host=odbcserver.na3.netsuite.com
Port=1708
ServerDataSource=NetSuite.com
Encrypted=1
Truststore=/opt/netsuite/odbcclient64/cert/ca.cer, /opt/netsuite/odbcclient64/cert/ca2.cer, /opt/netsuite/odbcclient64/cert/ca3.cer
CustomProperties=AccountID=1074600;RoleID=3
logging = yes
logfile = /opt/netsuite/odbcclient64/odbc64.log
enable_user_catalog = yes
enable_synonyms = yes
metadata_dont_change_case = no
metadata_dont_do_schema = no
metadata_id = no
limit_long = 0

[ODBC]
Trace=0
IANAAppCodePage=4
TraceFile=odbctrace.out
TraceDll=/opt/netsuite/odbcclient64/lib64/ddtrc25.so
InstallDir=/opt/netsuite/odbcclient64

odbcinst.ini-

[ODBC Drivers]
NetSuite ODBC Drivers 7.2 = Installed

[NetSuite ODBC Drivers 7.2]
APILevel = 1
ConnectFunctions = YYN
Driver = ivoa25.so
DriverODBCVer = 03.52
FileUsage = 0
SQLLevel = 1
Logfile = /app/var/lib/tomcat8/webapps/plugins/NetSuiteODBCDrivers_Linux64bit/odbclog64.txt


And have set the appropraite paths in my source bashrc file

export ODBCSYSINI=/opt/netsuite/odbcclient64
export ODBCINI=/opt/netsuite/odbcclient64/odbc64.ini
export OASDK_ODBC_HOME=/opt/netsuite/odbcclient64/lib64
export LD_LIBRARY_PATH=/opt/netsuite/odbcclient64/lib64

However, I am getting just the [ISQL]ERROR: Could not SQLConnect when doing a isql -v NetSuite


I checked the environmental variables-

env | grep ODBC
OASDK_ODBC_HOME=/opt/netsuite/odbcclient64/lib64
ODBCSYSINI=/opt/netsuite/odbcclient64
ODBCINI=/opt/netsuite/odbcclient64/odbc64.ini

And they are pointing o the right file

I checked the strace files as well.

strace -e trace=open isql NetSuite 2>&1 | grep odbc64.ini

open("/opt/netsuite/odbcclient64/odbc64.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_WRONLY|O_CREAT|O_APPEND, 0666) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbc64.ini", O_RDWR) = 3

strace -e trace=open isql NetSuite 2>&1 | grep odbcinst.ini

open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/opt/netsuite/odbcclient64/odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3
open("/root/.odbcinst.ini", O_RDONLY) = 3

The strace logs show the following issue-

stat("/opt/netsuite/odbcclient64/odbc64.ini", {st_mode=S_IFREG|0755, st_size=573, ...}) = 0
getuid() = 0
getuid() = 0
stat("/opt/netsuite/odbcclient64/odbc64.ini", {st_mode=S_IFREG|0755, st_size=573, ...}) = 0
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 1), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f7047b2d000
write(2, "[ISQL]ERROR: Could not SQLConnec"..., 34) = 34
munmap(0x7f703f84c000, 1402304) = 0

I don't understand why I am getting this error, when the odbc files are correctly being pointed to, and there is no mismatch in the bit versions, and the login is correct.

I will be glad with any pointers I could get.

Thanks!

When I try to open odbcserver.na3.netsuite.com, I get (on this ipad)

Safari cannot open the page because it could not connect to the server

Which suggests that’s not the correct URI for Host

When I try to open odbcserver.na3.netsuite.com, I get (on this ipad) Code: Safari cannot open the page because it could not connect to the server Which suggests that’s not the correct URI for Host

I am able to ping the host from the machine and get packets back without loss

ping odbcserver.na3.netsuite.com

PING odbcserver.na3.netsuite.com (72.34.169.32) 56(84) bytes of data.
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=1 ttl=229 time=22.1 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=2 ttl=229 time=22.0 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=3 ttl=229 time=22.1 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=4 ttl=229 time=22.0 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=5 ttl=229 time=22.1 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=6 ttl=229 time=22.3 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=7 ttl=229 time=22.1 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=8 ttl=229 time=22.0 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=9 ttl=229 time=22.1 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=10 ttl=229 time=22.1 ms
64 bytes from odbcserver.na3.netsuite.com (72.34.169.32): icmp_seq=11 ttl=229 time=22.1 ms
--- odbcserver.na3.netsuite.com ping statistics ---
11 packets transmitted, 11 received, 0% packet loss, time 10999ms
rtt min/avg/max/mdev = 22.074/22.136/22.322/0.169 ms

So, I don't think that is the issue here.

Originally Posted by subra I am able to ping the host from the machine and get packets back without loss So, I don't think that is the issue here.

I can ping the host too...only means the server is on-line. ping uses an IMCP protocol and port.

You're trying to make a TCP connection to port 1708 (Right?)

http://odbcserver.na3.netsuite.com:1708/

gives me

The connection was reset The connection to the server was reset while the page was loading.

(now on Firefox).

Maybe that's not the correct port number? (I'm just guessing now...)

What does NetSuite support say?

I am able to telnet to the environment successfully though.

telnet odbcserver.na3.netsuite.com 1708
Trying 72.34.169.32...
Connected to odbcserver.na3.netsuite.com.
Escape character is '^]'.

I also have just opened a ticket with NetSuite support on this.

Were they able to solve the issue?
If so, what generated it?
___________________________________
Marius from ERP software