'Cannot install nodemsqlv8 in heroku

I am trying to install msnodesqlv8package in Heroku. I need this package installed because I am trying to install MSSQL database rather than MySQL database. I have already purchased and added the MSSQL database addons in my Heroku app. This package helps me communicate with the database server. I have been using this package successfully in my Windows OS computer.

remote:        npm ERR! In file included from ../src/OdbcConnection.h:22,
remote:        npm ERR!                  from ../src/BeginTranOperation.cpp:1:
remote:        npm ERR! ../src/stdafx.h:37:14: fatal error: sqltypes.h: No such file or directory
remote:        npm ERR!    37 |     #include <sqltypes.h>
remote:        npm ERR!       |              ^~~~~~~~~~~~
remote:        npm ERR! compilation terminated.
remote:        npm ERR! make: *** [sqlserverv8.target.mk:181: Release/obj.target/sqlserverv8/src/BeginTranOperation.o] Error 1
remote:        npm ERR! gyp ERR! build error
remote:        npm ERR! gyp ERR! stack Error: `make` failed with exit code: 2

I understand that Heroku does not use Windows OS and uses Ubuntu so I have to install the ODBC drivers. To do this I have added an AptFile which has

unixodbc
unixodbc-dev

I followed this post on how to do this. But I am still getting this error. Most of the time when I work with Heroku I can install the packages easily. This is the first time I am having to deal with something like this. Can someone give me some direction on how I might install this package?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source