Mar 8, 2010 · I created a thread about this issue a while back and was told I was incorrectly using a recordset to execute a SQL delete query, and that I should use the execute method of the ADO …

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 then failed …

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 records selected by …

Apr 22, 2024 · We do not want you using ADODB anymore. We have been warning about this since VS2008. So we will cryptically make it difficult for you to use ADODB from now on. I should make a …

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

Feb 29, 2024 · Hi all, I am new to VB6 but have been working Excel VBA. I am converting my VBA project to VB 6.0. I am using excel WorkBook as database for now. I am having problem in creating …

May 26, 2016 · Set CN = New ADODB.Connection ' <-- since you NEw the connection object here (which is safer), you do not need it on the previous line CN.connectionstring=connection string here …

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 sqlString = …

Jan 13, 2012 · The error occurs at the last line, when using ' to obtain a parameter value like 'XXX%' (required by Oracle). Can someone please help me how to add the single quote to the parameter …

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 New …