title: NetSuite ODBC driver configuration
body: <p>Let me preface this by saying I don't have a lot of experience with LAMP environment. I get around but I have crashed the server a couple times poking around. That said...</p>
  
  <p>I'm installing the NetSuite 64bit ODBC driver on an Ubuntu 14.04.4 box on AWS. I also have the Windows driver which I tried using a WAMP setup. On the WAMP setup on my desktop, I can get the connection to work and can query the NetSuite database. On the server, the ODBC driver is set up properly and I have been able to get it to work using isql using the odbcisql64 that is provided by NetSuite. </p>
  
  <pre><code>ISQL&gt; connect "usr"*"pwd"@netsuite
  SQL: connecting to database: netsuite...
  Elapsed time 1336 ms.
  </code></pre>
  
  <p>This means that the DSN is set up properly. When I run the PHP code to access the database using the driver, I get this error:</p>
  
  <pre><code> Fatal error: Call to undefined function odbc_connect() in /var/www/html/www.xxxxx.com/xxxx/GetNSData_1.php on line 5
  </code></pre>
  
  <p>My PHP code looks like this:</p>
  
  <pre><code>error_reporting(E_ALL);
  ini_set('display_errors', '1');
  
  $conn = odbc_connect("NetSuite", "usr", "pwd");
  if (!$conn) { 
      die(' Could not connect: ' . odbc_error()); 
  }
  $query = odbc_prepare($conn, "Some Query");
  $success = odbc_execute($query, array('Data'));
  if($success)
      odbc_result_all($query);
  </code></pre>
  
  <p>So this means that there is a missing package on the LAMP server.  I'm not sure exactly sure which ones to install. I've tried a whole bunch including unixODBC and FreeTDS.  When I install these packages, I get a different error that says this: </p>
  
  <pre><code>Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/html/www.xxxxx.com/xxxxxx/GetNSData_1.php on line 6
  </code></pre>
  
  <p>After fixing the linkage in the odbcinst command to be sure that the driver is installed, then I get an error that tells me nothing. There's no error code or anything- not even an odbc_error() response:</p>
  
  <pre><code>Warning: odbc_connect(): SQL error: [unixODBC], SQL state in SQLConnect in /var/www/html/www.xxxxx.com/xxxxxx/GetNSData_1.php on line 5
  Could not connect:
  </code></pre>
  
  <p>So What I suspect is happening is that some path is not getting to the driver anymore. I've tried things online like this: <a href="http://www.debugthat.com/connecting-to-netsuite-using-linux-and-odbc" rel="nofollow">http://www.debugthat.com/connecting-to-netsuite-using-linux-and-odbc</a> but I'm missing something. I know it has to do with the configuration but I'm not knowledgeable enough to see what I'm missing. </p>
  
  <p>If anyone could give me some help on this I would be eternally grateful! Thanks!</p>