I have a Tabular model in SSAS 2019 on prem. The data source is SQL Server running on the same machine. I need to reroute the data source to Snowflake. I created a legacy data source using an ODBC (64-...

I am trying to connect to a legacy HFSQL (HyperFileSQL) Client/Server database using Python (pyodbc) on a Linux Ubuntu machine. I have followed the official documentation to install the specific ODBC ...

Running PHP 8. I have just upgraded CodeIgniter from 3.0.4 to 3.1.13. Before the upgrade, the affected_rows() worked fine and gave me the correct quantity. Now it just gives me a TypeError. This is a ...

I am connecting to an Excel file from PHP via PDO. When executing a query, Excel returns data, but it defines the first row of results as column names. How do I make Excel return all rows, including ...

We are planning to switch from password-based authentication to key-pair authentication for SAS to Snowflake connection. Our current requirement is: 1. Overnight batch/service account: use key-pair ...

I'm using Power BI Desktop with Amazon Redshift in DirectQuery mode. Data loads initially (sometimes at least / sometimes it has errors), but when I scroll down in a visual (e.g., table), I eventually ...

I am doing an app for a client and he wants to read data from .xlsx, .csv and .xls. For CSV files, I have already created a data parser, and for XLSX files, I had used QXlsx. With large files (>1M ...

I am trying to fetch a user-defined opaque column (opaque_col) via the ODBC driver using SQL_C_BINARY to access the internal binary format: const char* query = "SELECT opaque_col FROM opaque_test&...

In SQL Server I have defined a table with column: test_scale (numeric(10,2), null) and inserted a row with value -123456.78. In ODBC code from C: SQLExecDirect(hstmt, (SQLCHAR*)"SELECT TOP 1 ...

I have a parameter coming in from the excel table that is formulated as date time. 7/28/2025 12:00:00 AM name BeginDate I am trying to filter the source data which has a field called TransDate before ...

Platform MacOs Sequoia 15.5. My objective is to enable an application to find a dynamic library. My plan is to use launchctl to set the environment variable DYLD_LIBRARY_PATH and then lanch the ...

I'm trying to configure a MariaDB ODBC DSN automatically in PowerShell my code so far is this: $DriverName = (Get-OdbcDriver -Name "MariaDB*" | Where-Object Platform -eq "64-bit")....

I’m maintaining a legacy VB.NET 3.5 Windows Forms app that worked perfectly on Windows 10 32-bit using MySQL ODBC Connector 5.1/5.3. Recently, we migrated to a Windows 11 64-bit machine. Without ...

Like said in the title i am trying to bind a string column for a table valued parameter using ODBC. So far i created a table like that: CREATE TABLE [dbo].[TVPItem] ( ItemNo INT IDENTITY(1,1) ...

We have an ODBC linked service on Azure Synapse which connects to a VM which in turn connects to an Oracle@Azure Database. The linked service has been tested successfully on Azure Synapse. We need to ...