Issue I am relatively new to VBA and need some assistance. I have been piecing together this application from other bits and samples. This was working on Friday but now it isn’t and I don’t understand what may be causing
Continue readingTag: ado
[SOLVED] ADO Parameterized Queries with Subqueries Error
Issue I have a legacy classic ASP application running with SQL Server 2012 (also tested with 2016) that I am trying to switch over to using parameterized queries. All the site’s queries run through a function which expects a sql
Continue reading[SOLVED] Sending SQL Queries to CSV file on Excel VBA doesn't work for Date Columns
Issue I am trying to get some data from a csv file having more than than 3 million rows. I’ve set an ADODB connection to my csv file and everything works fine except for querying date columns. Here is how
Continue reading[SOLVED] Azure Pipelines terraform init -backend-config throwing exit code 127
Issue Have a simple pipeline for terraform planning and deployment Getting an error (exit code 127) when running a terraform init in my pipeline via a template Here’s the template that holds the init steps steps: – task: [email protected] displayName:
Continue reading[SOLVED] CopyFromRecordset method isn't moving the cursor to last row output
Issue I am using ADO to query a table in MS Access 2003, and outputting the data to Excel 2003 worksheets using the CopyFromRecordset method. The table has more than 65536 records, so I cannot use DoCmd.TransferSpreadsheet and need to
Continue reading[SOLVED] How can I connect to an Oracle database as SYS using an ADO connection string?
Issue I am trying this: Provider=MSDASQL.1;Persist Security Info=False;User ID=sys;Password=pwd;Initial Catalog=DATABASE;Data Source=OdbcDataSource;DBA Privilege=SYSDBA But I get the error: [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed I’m using Delphi, but answers in any language are welcome. Clarification: I am able to connect as
Continue reading[SOLVED] How to connect to MS Dataverse using ADODB Connections in VBA
Issue I have been successful in connecting to a MS SharePoint list in VBA with the following sub-routine: Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim sConn As String Dim sSQL As String sConn = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;" &
Continue reading[SOLVED] How can I connect to an Oracle database as SYS using an ADO connection string?
Issue I am trying this: Provider=MSDASQL.1;Persist Security Info=False;User ID=sys;Password=pwd;Initial Catalog=DATABASE;Data Source=OdbcDataSource;DBA Privilege=SYSDBA But I get the error: [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed I’m using Delphi, but answers in any language are welcome. Clarification: I am able to connect as
Continue reading[SOLVED] How to connect to MS Dataverse using ADODB Connections in VBA
Issue I have been successful in connecting to a MS SharePoint list in VBA with the following sub-routine: Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim sConn As String Dim sSQL As String sConn = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes;" &
Continue reading[SOLVED] Excel/VBA hangs when trying to change journal mode of an SQLite database via ADODB/SQLiteODBC
Issue The code below creates a new blank SQLite database in the Temp folder, creates a table, populates it, and pauses. Then the database is opened in DB Browser for SQLite interactively, and one value is changed, but the change
Continue reading