Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    andrei-muresanu
    @andrei-muresanu
    hi
    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
    connections hang
    ideas ?
    andrei-muresanu
    @andrei-muresanu
    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
    one reconnects
    the other hanged
    other timea both reconnect fine
    Aaron Anderson
    @aaranderson
    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
    amishraa
    @amishraa
    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?
    David Engel
    @David-Engel

    @andrei-muresanu Try filing an issue at https://github.com/Microsoft/mssql-jdbc.

    @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.

    alfredo ortega
    @fm4lch3mist_twitter
    hi, it works only on ubuntu?, anyone tried with archlinux?
    chenzefu
    @chenzefu
    中文可以吗？
    Bryan Jackson
    @bryanjack
    Anyone try the linked server with oracle DB?
    David Engel
    @David-Engel
    @bryanjack Yes.
    Bryan Jackson
    @bryanjack
    @David-Engel are you running MSSQL Server on Centos OS?
    David Engel
    @David-Engel
    @bryanjack No. I've only used linked servers on Windows connecting to Oracle DBs.
    Bryan Jackson
    @bryanjack
    @David-Engel Okay, Thanks btw. I'm using mssql on Centos right now, and i'm unable to use linked servers to Oracle DB
    David Engel
    @David-Engel
    @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.
    3zzooz0mh
    @3zzooz0mh
    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
    @LUUHUY2017
    hello
    Raj
    @RajvJ_gitlab
    Hi
    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
    darrix
    @darrix_twitter
    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.
    David Engel
    @David-Engel
    @darrix_twitter If you are doing integrated auth, you need an additional DLL installed on the machine:
    https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017#Connectingintegrated
    The DLL is available in the download package on Microsoft's website.
    darrix
    @darrix_twitter
    @David-Engel Ah, I see. Thanks much for your help.
    Stefan
    @stefanhk31
    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.
    David Engel
    @David-Engel
    @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.
    Stefan
    @stefanhk31
    Thanks @David-Engel !
    djabber2019
    @djabber2019
    hi
    this is Engineer Dhaif Jabber
    is it possible to us it with sql server 2012
    djabber2019
    @djabber2019
    hi all
    djabber2019
    @djabber2019
    hey there
    djabber2019
    @djabber2019
    hiii
    hi
    Pavel Kohout
    @pkohout_twitter
    Hi, does anyone can recommend MacOS MS SQL client tools?
    swa
    @swa256_gitlab
    Hi, I am planning to do certifications related to .net and sql
    any suggestions please
    David Engel
    @David-Engel
    @djabber2019 Yes. You can use SQL Server 2012.
    @pkohout_twitter The mssql-tools package is available on macOS and includes the sqlcmd and bcp command line tools.