Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives -1votes
0answers
33views
isql error when trying to set up ODBC for MariaDB on Linux
MariaDB "Ver 15.1" (installed using "Software Manager" i.e. apt) on Linux Mint 22 working fine.Now I want to set up an ODBC data source.I started on this MariaDB page (ODBC/...
- 16.1k
0votes
0answers
24views
How can I connect to HFSQL C/S using python on Linux?
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 ...
2votes
1answer
70views
CodeIgniter 3 odbc affected rows
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 ...
- 1,599
4votes
3answers
155views
Connecting to Excel from PHP using PDO
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 ...
Advice
0votes
1replies
61views
SAS Snowflake ODBC authentication using Key pair
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 ...
- 21
0votes
0answers
70views
Power BI DirectQuery to Redshift: ODBC error with pg_catalog.date_add(...) does not exist
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 ...
2votes
0answers
131views
C++/Qt: QODBC always ignores first row
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 ...
0votes
0answers
38views
Informix ODBC: fetch user-defined OPAQUE column as internal binary (SQL_C_BINARY) without server-side casts
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&...
- 53
0votes
1answer
89views
Reading SQL_NUMERIC_STRUCT via ODBC from SQL Server loses decimal places
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 ...
- 143k
2votes
1answer
58views
Error with MS Excel power Query ODBC Context
I have a parameter coming in from the excel table that is formulated as date time.7/28/2025 12:00:00 AM name BeginDateI am trying to filter the source data which has a field called TransDate before ...
0votes
0answers
66views
MacOS launchctl setenv DYLD_LIBRARY_PATH
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 ...
- 56.2k
1vote
0answers
119views
Configure MariaDB DSN using Add-OdbcDsn in PowerShell
I'm trying to configure a MariaDB ODBC DSN automatically in PowerShellmy code so far is this:$DriverName = (Get-OdbcDriver -Name "MariaDB*" | Where-Object Platform -eq "64-bit")....
- 362
0votes
0answers
24views
VB.NET 3.5 OdbcDataAdapter.Fill causes OverflowException after moving from Windows 10 x86 to Windows 11 x64
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 ...
2votes
2answers
171views
Trying to bind a string column for table valued parameter using ODBC
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) ...
- 173
0votes
0answers
30views
How to connect to a Oracle@Azure via VM using ODBC linked service, using Azure Synapse Notebook?
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 ...
- 25
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- About \def parameter list
- Murphy's Theorem 3.3.2 on positive linear functionals
- Expected number of upsets in a knockout tournament
- How to use an iPad as an external monitor with Mac mini 6.1 (Late 2012) for installing Ubuntu?
- Making a case for a defensive infantry wedge formation
- What is the difference between V-inf+ことない and V-stem+ない
- What is the point of All In?
- Simple current source with bjt
- Teil vs Unter for Mathematical Structures
- A (probably wrong) proof that the fundamental Poisson brackets are independent of the special choice of the canonical variables
- Can missed approach procedures be used for a PT?
- Software serial and RS485
- What is the meaning/utility of __[] AKA BlankSequence[][]?
- Spectraly extremal connected trees, a conjecture on majorisation of Laplacian eigenvalues
- Is there an asymmetric standard applied to zero probability events?
- Why optional studs on MTB shoes?
- How to run a command in a terminal only if the previous commands succeed?
- Bridge Edge Loops not working between 2 clearly defined Edge Loops
- Dual nationality citizen registering for EES in Switzerland
- Why do my Raspberry Pi 5 SD cards have unwritable partition tables?
- How should I apply Cure Wounds to a Find Steed mount?
- Extreme outlier in real data
- Does the intersection of a variety with rational singularities with a smooth variety have rational singularities?
- Fool a program it has a pty of specific size