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 used to work …

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 …

Oct 20, 2008 · Hi Guys, I have written a program that uses adodb and can conncet to a database and write to the values, however after looking at some tutorials I have begun to get a bit stuck in parts. I …

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

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 sleep and then later is …

May 16, 2007 · Re: How to Select a New ADODB.Recordset from an Existed ADODB.Recordset Nope. Since rs1 is a straightforward select query then use "from Personal_Info_Table" in rs2 select query …

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 …

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 use the …

Jul 10, 2008 · ADO Recordset Null Value My program copies permissions from SQL Server to Oracle. I have a table in Oracle (called dblist) that has a list of servers and databases for SQL. When i pull …

Dec 13, 2022 · Hello, I'm trying to update the SQL provider in a VB6 program that uses ADODB, so that we can use TLS 1.2 encryption in the connection. I've tried SQL Native Client 11 and MS OLE DB …