I have written a code in node.js code that is connected to MS-SQL server. It's working perfectly fine. Now i want to deploy it on my LIVE IIS server .
Need a guidance in this regard
I have "https://github.com/tjanczuk/iisnode" but its not working and i am not in intention to do any more experiments on live server.
Anybody plesae help me. i am bady stuck ...
need help ---> muhammadikhan@live.com
@David-Engel thanks for your help and response. No doubt this is a unique task and i have leant a new thing which is not common.
I did my task from the help of below-mentioned link.
https://dev.to/massivebrains/deploying-node-express-app-on-a-windows-server-2l5c
If anyone need help regarding IIS or any .net framework, node.js integration with .net. please do me a query.
many thanks
have peace and stay blessed.
:smiley:
builder.UserID = "sa"; // update me
builder.Password = "your_password"; // update me
builder.InitialCatalog = "master"; with vere do I get these information from?
Hello! I need some help, first time with docker and I made a little console program with docker for MAC. And everything is working on my Mac, but when I try to open my program on another Mac I get error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught).
What have I missed or what do I Need to do?
@naughtong The ODBC standard has been around for a long time and is likely the most popular for C++ apps. I'm not familiar with sqlapi.
@gittewebmus_twitter You get those values from the database you configured for use with your application.
@isabelpebaque That depends on where your program is trying to connect to the database. Both Macs will need a database installed if you have specified "localhost" for your server. If you have a separate database server, you can point your program to that specific server name and the program can work from either machine (assuming they have appropriate network access to each other).
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
PHP Warning: PHP Startup: Unable to load dynamic library 'ssdeep.so' (tried: /usr/lib/php/20190902/ssdeep.so (/usr/lib/php/20190902/ssdeep.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/ssdeep.so.so (/usr/lib/php/20190902/ssdeep.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlsrv.so' (tried: /usr/lib/php/20190902/pdo_sqlsrv.so (/usr/lib/php/20190902/pdo_sqlsrv.so: cannot open shared object file: No such file or directory), /usr/lib/php/20190902/pdo_sqlsrv.so.so (/usr/lib/php/20190902/pdo_sqlsrv.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
Configuration File (php.ini) Path => /etc/php/7.4/cli
Loaded Configuration File => /etc/php/7.4/cli/php.ini
Scan this dir for additional .ini files => /etc/php/7.4/cli/conf.d
Additional .ini files parsed => /etc/php/7.4/cli/conf.d/10-mysqlnd.ini,
@intclassproject Ensure SQL Server is installed and configured correctly for network access. If you are running SQL Server in a docker image on Windows, either the docker image is not running, or you did not map the network port Windows to the docker image. Here's a reference doc for a Linux docker container:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&preserve-view=true&pivots=cs1-powershell
I recommend these forums over this one for quicker community responses:
SQL Server on Microsoft Q&A
DBA Stack Exchange
@Mixage51 It sounds like your PHP configuration is incorrect. Assuming you have followed the instructions on the docs site, the test script at the end (https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#testing-your-installation) should help identify problems. If you can't figure it out, try PHP-specific forums (https://www.php-forum.com/phpforum/, https://forums.phpfreaks.com/), or, if you can't get help there, file an issue in the PHP drivers for SQL Server repo: https://github.com/microsoft/msphpsql/issues.
@David-Engel
in line to the link to GORM should be corrected: https://gorm.io/
in the first code window this code doesn't work
go install github.com/denisenkom/go-mssqldb
Error:
go install: version is required when current directory is not in a module
Try 'go install github.com/denisenkom/go-mssqldb@latest' to install the latest version
But even if this code is used it doesn't work
Maybe something has changed in golang. I know that this works because I found one working open-source-golang-project working with mssql. And that's why I wanted to follow these instructions. But the first code produces some errors and it would be a good idea to provide some code working "out-of-the-box" fo golang newbies like me :-)
Scroll down a little to the "Or, download a free specialized edition" and download the developer edition.
Be sure to check the support matrix to see if your version of Ubuntu is supported, too: https://docs.microsoft.com/en-us/sql/connect/php/microsoft-php-drivers-for-sql-server-support-matrix?view=sql-server-ver15
/opt/homebrew/include/sql.h
$PATH variable is set to: /opt/homebrew/opt/php@7.4/sbin:/opt/homebrew/opt/php@7.4/bin:/opt/homebrew/bin:/opt/homebrew/sbin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
If you still face issues, you can reach out to https://github.com/Microsoft/msphpsql for additional support.
