Feb 14, 2016 · Re: ADODB connection on 64-bit... The issue was that I was using mapped drives - and getting "path not found" errors. I changed to using UNC pathing and this worked, but …

Oct 22, 2017 · Dim cn As ADODB.Connection Set cn = New ADODB.Connection Dim rs As ADODB.Recordset Dim StrConn As String StrConn = "Driver = …

Nov 26, 2024 · How to properly update Recordset? Hi, I have an ADODB.Recordset that I use to retrieve values from database and populate my mshflexgrid. Then, with UI, I can update …

May 28, 2020 · ADODB. Command slow I have several stored procedures in MS SQL Server database. While the number of records in tables included in those SPs were not big everything …

May 28, 2013 · Re: [RESOLVED] ado.Recordset.Filter I think the main problem here is misunderstanding of what adoRecordset stands for - in the sample I posted it stands for …

Jun 13, 2012 · Dim conConnection As New ADODB.Connection Dim cmdCommand As New ADODB.Command Dim rsRecordset As New ADODB.Recordset Dim sqlString As String …

Dec 6, 2021 · I found that if an ADODB.Connection is opened, and then subsequently it is dropped for whatever external reason (e.g. server is disconnected, or the machine goes to …

Jan 20, 2019 · Set cmd = New ADODB.Command cmd.ActiveConnection = cnn cmd.CommandType = adCmdText Set rs = New ADODB.Recordset ' Query the workheet SQL …

Apr 6, 2007 · It stops on the rs.open line (2nd Time used) I have looked on google and found an answer about putting the strings in , but this didn't seem to make any difference. Dim cn As …

Mar 25, 2025 · conn.Open strConn Set rs = New ADODB.Recordset rs.Open "SELECT * FROM Cases", conn ' Process records If Not (rs.EOF And rs.BOF) Then rs.MoveFirst Do Until rs.EOF …