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

Jan 29, 2022 · ADODB for 64-bit Hello: We just upgraded to SolidWorks and PDM 2021. I have some programs that utilizes accessing some spreadsheets to obtain data. Those programs …

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 …

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 …

Aug 2, 2022 · Re: Using ADODB with MSOLEDBSQL in Visual Basic 6.0 Maybe read Using ADO with OLE DB Driver for SQL Server and related articles. Be wary of example code there for VB …

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 …

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 …

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 …

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 …