Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Nick
    @nj-db
    Hi, can anyone please point me in the direction of some information to do with using a SQL FileTable in a document versioning system? Thanks
    matrixbot
    @matrixbot

    gympuma > <@gitter_nj-db:matrix.org> Hi, can anyone please point in the direction of some information to do with using a SQL FileTable in a document versioning system? Thanks

    Could you explain a little more? You want to log versioning in SQL? Generate documents from t-sql into a file system?

    matrixbot
    @matrixbot

    gympuma > <@gitter_marcelosf:matrix.org> Message Iteration=2|SQLState=IM006|Native Error=|Message=[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed[Message Iteration=3|SQLState=08001|Native Error=|Message=[Microsoft][SQL Server Native Client 10.0]Client unable to establish connection]'.

    What connection string are you using? (blank out sensitive info before sendind)

    Adedamola Adedapo
    @adedamola-ad
    Hi, can anyone please help with this error , I am trying to connect to an mssql server on vscode running on ubuntu, and i keep getting this error.mssql: Failed to connect: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught) ---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (00000005, 6): No such device or address
    at System.Net.Dns.InternalGetHostByName(String hostName)
    at System.Net.Dns.GetHostAddresses(String hostNameOrAddress)
    at Microsoft.Data.SqlClient.SNI.SNITCPHandle.Connect(String serverName, Int32 port, TimeSpan timeout)
    at Microsoft.Data.SqlClient.SNI.SNITCPHandle..ctor(String serverName, Int32 port, Int64 timerExpire, Object callbackObject, Boolean parallel)
    at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType, SqlAuthenticationProviderManager sqlAuthProviderManager) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool, SqlAuthenticationProviderManager sqlAuthProviderManager) at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass40_0.<TryGetConnection>b__1(Task1 _)
    at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
    at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
    --- End of stack trace from previous location where exception was thrown ---
    at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
    --- End of stack trace from previous location where exception was thrown ---
    at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>cDisplayClass30_0.<<OpenAsync>b0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ManagedBatchParser\ReliableConnection\ReliableSqlConnection.cs:line
    kmteam
    @kmteam
    Hi
    kmteam
    @kmteam
    I have a database in which some tables have a lot (millions) of rows with binary data. The database is having a lot of I/O problems so we want brake it down to store the data into different disks.
    Is there any option to do this without break it down into two separate databases?
    Can I assign a table into different storage?
    Thnks!
    Mike Mahon
    @jetstreamin
    question? When a Entity Framework connects to sql server, what port is utilized?
    Shreyas Patil
    @pshreyasv100
    I have a requirement of writing a pandas dataframe to SQL server via stored procedure so I'm using df
    df.to_sql() but there seems to be some limitation with this approach since sql server supports only 2100 cells at a time while writing to db say for instance I have 10 rows then I will be able to write only 210 rows in one batch , and writing is happening very inefficiently, could anyone suggest a more efficient approach to writing a pandas dataframe to SQL server ?
    Fr0z
    @Fr0zBeats_twitter
    oh hi
    thank you for all the cool tech
    im appreciating every moment of learning innovation
    Christian Gann
    @doublegsoft
    hello! i wanna develop a ssms extension to prevent some accidental sql execution, could anyone provide some information about its development tutorials or introduction of ssms extension framework?
    reheinz
    @reheinz
    Dear sir. I'm starter of vsc. plz help me. I can't connect the server.
    image.png
    reheinz
    @reheinz
    I can connect like this way by MSSM studio.
    image.png
    how can I connect by VSC?
    rbhagwane123
    @rbhagwane123
    sir i need to connect mysql to vs codfe
    1 reply
    plzz help
    Egorka Voronyansky
    @vrnsky
    Hey, guys! Can you help me please. I don't understand why I got next error. I have the
    update orders o
    set inn = s.inn,
        ogrn = s.ogrn
    from (select id, inn, ogrn from public.limits) as s
    where s.id = o.limit_id;
    Simple SQL update and when I try execute it via Flyway a got an error
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'SET'.
    Hugh Gleaves
    @Korporal
    Hi I have a question, in principle, would it be possible for SSMS to display not just a column name in the column header, but the column name prefixed by table name?
    This would be helpful when doing ad hoc queries that contain joins and where several tables have columns with same name
    Im not sure of the data sent back by the server contains enough info for this, but if it did then this could be possible.
    Hugh Gleaves
    @Korporal
    My error !
    amishraa
    @amishraa
    @Korporal Why not simply alias your columns?
    garyng2000
    @garyng2000
    has anyone seen this error before ? "mssql: mssql: Failed to connect: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: HTTP Provider, error: 0 - )
    1 reply
    I tried to connect to SQL server running under linux(from vscode running under linux).
    For the same server, I can connect using standard SSMS or even pyodbc
    only the mssql plugin for vscode gives me this error
    oh and I have tried vscode under window and basically the same error
    Egorka Voronyansky
    @vrnsky
    Hi, @everyone!
    I just faced with next problem
    java.lang.IllegalStateException: Cannot load driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
    I have driver in classpath, my app works correctly on local machine, but on the server I got that error. What I can do or what is possible reason for this error?
    Sam
    @MgSam
    Anyone know anything about a future version of SQL Server? It's crazy that it's been two years since 2019 and MS hasn't said a peep publicly about what's next yet. I'm wondering if this means MS is shifting resources away from SQL Server...
    alexanderbright
    @alexanderbright

    Hi colleagues,

    I have a problem when I don't know who or which application service makes insert/update request to a particular table. Could you tell me please if it is possible to get this information from MS SQL using a specific query?

    tunbk1002
    @tunbk1002
    Hi everyone! I have one question. mssql extension doesn't work on Arch right?
    foxale
    @foxale
    I use mssql extension for VS Code and was able to successfully add Azure SQL Database with AAD, but after some time it stops working throwing a "token expired" error. Any way to make it refresh the token automatically?
    Jignesh Parmar
    @jvparmar99_twitter
    Hello,
    Can anyone help to identify duplicate records based on two columns in SQL server table?
    Buğra
    @BgR8
    Hi,
    I'm getting mssql registry error.
    computer then restarts
    how can I fix it
    Yuen Yalung
    @yuen-os
    Hi i have a question regarding always encrypted, i've used MSSQL_JAVA_KEYSTORE for a java app but i can't encrypt existing columns to the database, is that the expected behavior? because on the MSSQL_CERTIFICATE_STORE it can encrypt existing columns on db
    CHANDAN NANDY
    @NANDYCHANDAN
    Hi
    I am not able to connect MS mysql with visual studio
    it is asking to give hostname\instance I know it's localhost I don't know the instance
    How do I get to know the instance name
    amZ200
    @amZ200
    hey
    How can I connect to sql server?
    What should I write in the server field?
    amZ200
    @amZ200
    The sql server program always gives me a message: Error and ...