Monday, September 17, 2018

ODBC > Connect to Netsuite ODBC using Classic ASP (Active Server Pages)

Customer would like to utilize NS ODBC Views and be able to connect to it using external application like ASP.
 
No need to install other driver except from the ones mentioned in the ERV Help Guide. These needs to be installed first in the Web Server running the PHP Application connecting to ODBC.
1.       Visual C++ 2008 Redistributables - http://www.slproweb.com/products/Win32OpenSSL.html, note that you need to pick the (x64) only if you're using a 64 bit machine.
2.       Win32 OpenSSL v1.0.1e Light - http://www.slproweb.com/products/Win32OpenSSL.html - note that you need to install Win32 OpenSSL v1.0.1e Light if you're using 64 bit machine.
3.       ODBC Driver
 

Sample Active Server Pages code: 

<%
 Dim con
 Set con = Server.CreateObject("ADODB.Connection")
 con.Open "DSN=Netsuite.com;UID=usernamr;PWD=password"

 ' Now database is open and we are connected
 ' Do some thing here
 'We are done so lets close the connection
 con.Close
 Set con = Nothing
%>  

No comments:

Post a Comment