Search results
22 gru 2023 · 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.
16 cze 2021 · I get a runtime error 3709 when trying to connect via VBA to a SQL Server using Windows authentication. The problem occurs on this line: .ActiveConnection = conn. Here is the complete code used to connect: Dim strConn As String. Dim wsReport As Worksheet. Dim col As Integer. strConn = "Provider=SQLOLEDB;"
21 lut 2016 · I can no longer connect to sql using ssms through vpn after a windows 10 update. When I try and connect I get the following error: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.
20 sty 2022 · I am using VBA to try and connect to SQL server. Here is the code: Sub GetDataFromADO () 'Declare variables' Set mConn = New ADODB.Connection. Set mRS = New ADODB.Recordset. Dim strSQL As String. 'Open Connection'
16 maj 2018 · After the new windows 10 update (may 10) my program cant connect to the sql server anymore. The executable is on a shared folder on another computer. I've tried to run it as administrator, disable...
19 sie 2021 · Set connection = New ADODB.connection. Connection String. This is the main thing of ADODB connection, to be able to connect to the database. You need to know at least the provider, server name, database name and authentication method. For MS SQL use SQLOLEDB.1 as provider.
11 lip 2024 · When connecting to SQL Server, you may receive the following error message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)
