Skip to content
Advertisement

Tag: sql-server

Add Providers MSSQL Linux

i want add a new linked server in my SQL Server (14.3026.27) Linux Red Hat Enterprise 7.5, before i add a linked server to other SQL Database, but now when i want add a linked server to MySQL i cant. I check my SQl Server linux and i found that i not had any provider in the section “Server Objects”

Unable to connet to SQL server using soci library

I am beginner in c++,my problem on Linux for connecting to SQL Server with soci library, my code this but I have error and I don’t found solution for my problem, my code this: I have error: Here is the code: Answer Your ODBC connection string in incorrect, your first parameter specifies a datasource called “ODBC”, which you haven’t configured

Not able to create SSIS DB Catlog in linux RHEL 7

I am not able to create SSIS DB Catalog on my MS SQL Server which is installed on Linux RHEL 7 Server. Though I have installed SSIS on Linux RHEL 7. Whenever I am trying to create SSIS DB Catalog i am getting this error. TITLE: Microsoft SQL Server Management Studio The path to the catalog backup file could not

Why does MSSQL in Docker return “The last operation was terminated because the user pressed CTRL+C” on sql queries?

I’m on Archlinux 64x (4.17.4-1-ARCH) with Docker (version 18.06.0-ce, build 0ffa8257ec). I’m using Microsoft’s MSSQL docker container CU7. Each time I’m trying to enter a query or to run a SQL file I get this warning message: Then when I check in the database with Datagrip, the query hasn’t been executed! Here are my commands : My question is How

SQL Server on Linux : Data source name not found

I followed the instructions to install Sql server natively on my machine which runs linux mint sonya based off ubuntu xenial. Ive had no trouble installing the service: When trying to connect the the DB, i get this error: Answer Turns out after all that I did not install the unixodbc-dev package. The error message kind of threw me off.

How to view execution plans in SQL Server on Linux

I have SQL Server installed on Linux. It was installed from Microsoft’s repos as described here: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu In MySql I used to write EXPLAIN in front of my query to see the execution plan. In SQL Server it doesn’t seem to work. But I don’t have the studio program installed, only just SQL Server and the sqlcmd tool. How do

MSSQL Server for Linux Docker Versions

I currently have Microsoft SQL Server 2017 (CTP2.1) – 14.0.600.250 (X64) May 10 2017 12:21:23 Copyright (C) 2017 Microsoft Corporation. All rights reserved. Developer Edition (64-bit) on Linux (Ubuntu 16.04.2 LTS). Are there any earlier versions available? SQL Server 2012, 2014, 2016? I don’t want to run into the problem where I need to back up and restore a database

Error during insert with parameter(s) over 30 characters

Issue Performing an insert using prepared statements with PDO and an ODBC driver gives the following error when at least one of the parameters is over 30 characters: Inserts work for any bound string that is <= 30 characters in length. I have no issues with SELECT queries. Using INSERT with isql and sqlcmd does not produce an error, but

Advertisement