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;"
19 sie 2021 · ADODB Connection. After setting up the references You can declare connection of ADODB library. Dim connection As ADODB.connection. Set connection = New ADODB.connection. Connection String. This is the main thing of ADODB connection, to be able to connect to the database.
8 gru 2022 · Some connection attempts generate error messages when the connection fails. Examples include ‘the EMS System encountered a problem,’ ‘protocol error in TDS Stream’ and ‘unknown token received from SQL Server’.
10 maj 2023 · Problems with old SMB and SSL protocols since Windows 10 Pro 22H2. Hello! I have several old VB applications that connect via OLEDB to an old MS SQL Server 2000 that is not accessible (for an upgrade) to me.
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'
To optimize performance, minimize network traffic, and reduce multi-user access to the SQL Server database, use as few connection strings as possible by sharing connection strings over multiple record sets.
