My error is "he database 'C:\USERS\DEVESH\DOCUMENTS\VISUAL STUDIO 2015\PROJECTS\CONCEPT CLASS\CONCEPT CLASS\BIN\DEBUG\DEVESH.MDF' cannot be opened because it is version 782. This server supports version 655 and earlier. A downgrade path is not supported.
what to do now?
Install a myor Sql
Install a major SQL Server version
got an issue with connections hanging when failing over an sql2017 ag
using already multisubnet=true
6.4 driver both jdk 1.7 and 1.8 (multiple apps)
both behave the same
actually, we connect to 15 ag from the same jvms
single ip every one
but 1 jb
1 jvm connects to only one ag
and behaves the same
acrually we have two of thoae
the other hanged
other timea both reconnect fine
Hi, I'm working through the getting started sections for C# with SQL server and I'm getting an error for section 2.1 where it states that there is "incorrect syntax near the keyword if" the SQL concerned is this. String sql = "DROP DATABASE IF EXISTS [SampleDB]; CREATE DATABASE [SampleDB]"; The only code I've changed is my string builder so I can connect to the server. https://www.microsoft.com/en-us/sql-server/developer-get-started/csharp/win/step/2.html
I am trying to follow the instructions for setting up connection string on R for SQL Server, and it does not appear to like backslash for my server name. Anyone else run into this issue?
@aaranderson Are you connecting to Azure SQL DB or a locally installed SQL Server instance? I don't think that code sample will work correctly against an Azure SQL DB.
hi, it works only on ubuntu?, anyone tried with archlinux?
Anyone try the linked server with oracle DB?
@David-Engel are you running MSSQL Server on Centos OS?
@bryanjack No. I've only used linked servers on Windows connecting to Oracle DBs.
@David-Engel Okay, Thanks btw. I'm using mssql on Centos right now, and i'm unable to use linked servers to Oracle DB
@bryanjack You won't be able to do that from SQL Server on Linux. It's not currently supported. https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-release-notes?view=sql-server-2017#Unsupported The reason behind that is because SQL Server on Linux is basically SQL Server for Windows inside a special package for Linux. All the files for the linked server would have to already exist in the "SQL Server package". You cannot add your own files to it; i.e. the Oracle OLE DB provider for the linked server and underlying Oracle Net libraries for Windows.
Hi everyone. I wanna ask about How to connect SQL server extension in VS code to a Flutter project. if you have link or anything to help .... thanks
Lưu Đức Huy
I wanna to know about exact SQL server download... If I can get link to download sql server 2017/sql server 2014... I just wanna to code backend for my project
Hi, should I be able to use the maven package for the sqlserver driver to do Windows Auth? I'm getting errors attempting a windows auth connection to sql server. I've checked that the firewall isn't in the way and that the TCP protocol is enabled.
@darrix_twitter If you are doing integrated auth, you need an additional DLL installed on the machine:
The DLL is available in the download package on Microsoft's website.
@David-Engel Ah, I see. Thanks much for your help.
Hi, I'm new to SQL Server Express, and trying to go through Microsoft's "Create C# apps using SQL Server on Windows" tutorial. How do I find what port to set the builder.DataSource to? I'm getting a "server was not found or was not accessible" exception when I try to apply the code given in the tutorial.
@stefanhk31 SQL Server Express, I believe, by default only listens to named pipe connections. You can simply use a connection string like "<computer_name>\sqlexpress", or configure SQL Express to listen for TCP connections (https://web.synametrics.com/sqlexpressremote.htm) if you want to be able to specify a port.