DBExpress connecting SQL 2008 at runtime with Delphi 2009

I'm trying to connect at runtime with SQL Server 2008 with Delphi 2009 using DBExpress, it it's not working. When I set all the properties at design time, it works great, but at RunTime, I'm...

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer... (error code 3417)

For some reasons I moved this folder : (Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL) to another drive, then returned it to the same location, but sql server has stopped working,...

How to create copy of database using backup and restore

Using SQL Server Management Studio 2012, I'm trying to create a copy of a local database. I found a few variants of solution. One of them - backup and restore database as new one - HERE. Currently...

Extract data from Windows Server Update Services (WSUS) using SQL query

I have never used WSUS, so I really dont know how to get right data. The goal is to have a table with three columns: Computer Group, Computer Name, # of needed updates I found out here: Microsoft...

"Create Database"-SQL with name from variable fails

I used an existing database to generate a "CREATE"-Script via the MS SQL Server Management Tool. Then i replaced the string literals for the DB Name with variables. However, when i execute the...

Converted bigint to varchar in MSSQL

I have this column ContactNo and others like this e-g FaxNo etc. Problem is in MSSQL these columns were defined as bigint, and I changed them to varchar in MSSQL using Management Studio: The only...

C# Entity Framework Migrations adding weird characters to string

I have strings in my MsSql database with nvarchar column type. My seed method sample is this: protected override void Seed(Sro.Models.ApplicationDbContext db) { Konu iyimi = new Konu...

Writing datetime.datetime() column using pandas.to_sql()

I have a single column dataframe df which has column TS where In [1]: type(df.TS.values[0]) Out[1]: pandas.tslib.Timestamp I convert the column to type datetime.datetime() In [2]: import...

SQL Server Transactional replication - The process could not bulk copy into

So I have setup T-replication from Publisher (SQL Server 2014) Distributor (SQL Server 2014) Subscriber (SQL Server 2008 R2) and initialized it using a snapshot. Checking in the replication...

Node js knex and mssql error - 'TypeError: _this.driver.Connection is not a constructor'

Not a question, more of a heads up in case anyone else encounteres this - While setting up a new node project, I want to use knex to access a MSSQL database server. I'm initializing knex with...

How can I use Like operator in mssql(node.js)

I'm using mssql(node.js). I want to execute SQL having LIKE. But I can't find out in below page https://www.npmjs.com/package/mssql#input-name-type-value my code is this.But it doesn't work(result...

Copy tables from one database to another in SQL Server, using Python

Does anybody know of a good Python code that can copy large number of tables (around 100 tables) from one database to another in SQL Server? I ask if there is a way to do it in Python, because due...

What is the link in SAP Business One between Sales Orders, Deliveries, and Invoices

I'm trying to join ORDR, ODLN and OINV in a SAP Business One query, but I can't seem to find a field that they share in common. There must be some record somewhere that links one to another. Are...

How to insert binary data to SQL using Laravel 5.*

I would like to save an image into a varbinary(max) field in MSSQL. The store method in my controller looks like this: public function store(Request $request) { $vorname =...

Golang Error with Backing up the DBmssql: BACKUP DATABASE is terminating abnormally

I am trying to do a full backup for an MSSQL database using go. However, I tested the connection to the MSSQL server and it works like charm! By executing also a query into the code SELECT...

Connecting to MSSQL in Flask using Flask-SQLAlchemy and pyodbc

I am not able to connect to MSSQL Server 2016 database using Flask-SQLALchemy and pyodbc. I have searched through Google and none of the solutions work. I am getting the following...

Spring Boot Hikari can't find DriverClassName

I have a spring boot project,It run just fine when I execute via eclipse Project > Run as > spring boot app but when I build the project and execute it using java -jar myproject.jar or run it...

Hibernate: Schema-validation: missing table

I try to read from an existing table in a MSSQL Server 2016 Database. If I validate (hbm2ddl.auto --> validate) I get an Exception "Schema-validation: missing table". I compared the generated...

Generate synthetic partition keys for a DynamoDB table

I'm sure this is a trivial and common question with regards to DynamoDB but Google or AWS docs didn't help much. My question is simply: What is the pattern to generate partition keys? In an RDBMS,...

Docker initialize database tables and records in SQL Server

How do you specify initialization database script for SQL Server via docker-compose using SQL script file? docker-compose.yml database: image: microsoft/mssql-server-linux:2017-latest ...

result_fetch([email protected], n)': nanodbc/nanodbc.cpp:2966: 07009: [Microsoft][ODBC Driver 13 for SQL Server]Invalid Descriptor Index

I have problem with MSSQL in R language, similar like in https://stackoverflow.com/questions/45001152/r-dbi-odbc-error-nanodbc-nanodbc-cpp3110-07009-microsoftodbc-driver-13-fo , but a little...

need help formating type="datetime-local" in ColdFusion (not a cold fusion element)

Ok I have searched for 2 days and thought I found the solution but it's not working maybe I can get a hand here. I'm trying to allow the user to choose the date and time of their form post. I...

Restore a SQL Server DB.bak in a Dockerfile

I am running a .NET Razor application, an instance of gitea, and a SQL Server database each in separate containers that communicate with one another. I would like to start my database image with a...

Invalid reference format: Running Docker on MAC to have SQL Server 2019 in a container

I followed these steps in this link (https://database.guide/install-sql-server-2019-on-a-mac/) to install SQL Server 2019 on MAC. I was able to pull the image down. using this command. sudo...

How to terminate complicated queries to database from python?

I want to integrate MS-SQL with pandas dataframe over python library SqlAlchemy. Ther's nice way to do this by: import sqlalchemy as sa import pandas as pd conn_string= 'DRIVER={ODBC Driver 17...

How to fix Microsoft ODBC Driver 17 for SQL Server : SSL Provider ssl_choose_client_version:unsupported protocol

I have installed Sql Server 2019 Developer Edition and mssql-tools on my Ubuntu 20.04 minimal. I can connect to my localhost with no issue, but when I want to remote to another sql server: sqlcmd...

Mac M1 SQL Server SQLSrv OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed

I just bought a M1 Mac mini running Big Sur 11.6, I've installed PHP 7.3, msodbcsql17, mssql-tools, sqlsrv and pdo_sqlsrv. But when I try to connect using sqlsrv, the following error happens...

How to connect from VSCode to a mysql docker container?

I'm just testing the VSCode MSSQL extension, I have a simple MySQL server running on docker out of this docker-compose file. services: sql-server-db: container_name: testDB image: mysql ...

Spring boot Log4j2 version 2.15.0 EMPTY_BYTE_ARRAY error in wildfly server

I upgraded log4j version to 2.15.0 due to security vulnerability. but when deploying I get the "EMPTY_BYTE_ARRAY" error in wildfly server. Pom.xml: <properties> ...

Cypress TypeError: Cannot read properties of undefined (reading 'uid')

I have a Cypress project with TypeScript support using the Cucumber Preprocessor and all of a sudden it started to throw the below exception: TypeError: Cannot read properties of undefined...