I have a Amount column in database which is in Varchar datatype, I am retrieving the data from table and I am casting for the amount should be returned as (12345.0,111.00) like this, so here I am casting with decimal,…
I have an issue with my ASP.NET WebApp. I store and retrieve my data from MySQL, but the thing is, my data is very huge, resulting in getting this error message: MySql.Data.MySqlClient.MySqlException: 'error connecting: Timeout expired. The timeout period elapsed…
I'm working on a project where I have to add the functionality of searching for phone numbers using dot net core. on SignUp, we are storing phone numbers in SQL Server using the country code eg: "+923007418819". So if the…
I have the following code to check if a SQL table exists: using (var conn = new SqlConnection(SqlServerConnectionString)) { conn.Open(); var selectQuery = $"SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '{tableName}'"; var cmd = new SqlCommand(selectQuery, conn); var reader =…
I am working on a MacBook Pro with M1 CPU so I can't use the "normal" mssql docker image. I am using azure-sql-edge that doesn't have sqlcmd to initialize the database (create schema, database, login). I have created a sql…
I want to connect Laravel (version 8), with a SQL Server database (SQL Server 2008 R2). I've done the installation and followed some tutorials with steps like the following, where the version I installed adapts to SQL Server 2008 R2,…
I started working on Github actions to build some sample containers instead of doing my builds locally. Less reliance on my machines, etc. It seems though that building and pushing on my MAC works, but creating an Action to do…
first of all, im really noob.(sorry for that) secondly, iam trying to connect php to mssql server. thirdly, i already install sqlsrv, pdo_sqlsrv, and msodbcsql.msi but still get error message when trying to connect my php version is 8.0.10, x64;…
I have the following error while trying to connect SQL Server: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate] I'm on Ubuntu 20, PHP 7.4 FPM, nginx. Server Microsoft SQL Server [11.00.3128 Microsoft SQL Server…
I need help connecting my Web App to a remote database (SQL Server). I have tried many suggested solutions but I can't seem to come right. This is how I connect to a local database, it works 100%: <add name="DBCS"…