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