9,624 questions
2
votes
1
answer
56
views
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
4
votes
3
answers
141
views
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 ...
0
votes
0
answers
61
views
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 ...
- 1
0
votes
0
answers
33
views
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
2
votes
1
answer
57
views
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 BeginDate
I am trying to filter the source data which has a field called TransDate before ...
- 21
1
vote
0
answers
113
views
Configure MariaDB DSN using Add-OdbcDsn in PowerShell
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")....
- 362
2
votes
2
answers
164
views
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
0
votes
0
answers
76
views
Indicator pointer is required by the driver to indicate NULL output data, but is not provided
While importing Snowflake view to SQL Server using SSIS package, it's throwing this error:
Error: SQLSTATE: 22002, Message: [Snowflake][ODBC] (10450) Indicator pointer is required by the driver to ...
- 149
0
votes
0
answers
99
views
ODBC:ERROR [HY000] [AmazonAthena][S3ClientError]
I have Athena ODBC driver 2.x version installed on windows server and Test Connectivity is successful then later i was trying to execute a sample query just trying to list top 10 rows. I am getting ...
0
votes
0
answers
59
views
odbc_connect(): SQL error: [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed, SQL state IM004 in SQLConnect
I have an AWS Lambda based on brefphp to connect to a snowflake data warehouse.
For this I use :
runtime: php-84
${bref-extra:odbc-snowflake-php-84}
I get this error, when calling obdc_connect:
&...
1
vote
0
answers
60
views
Pull in all the tables in Snowflake at once into R
I am pulling data from Snowflake via R, and have been pulling tables via ODBC connection with the dbGetQuery function from the DBI package in R. Is there a way that I can read in all of the tables ...
- 175
0
votes
1
answer
33
views
DolphinDB ODBC Connection Concurrency Issue
Multiple data synchronization tasks (synchronizing data from ClickHouse to DolphinDB) were submitted via submitJob. Each task function independently creates an ODBC connection. Observations show:
...
- 27
0
votes
1
answer
55
views
SQLAlchemy Operation Error that goes away after refreshing
I'm using SQLalchemy in Flask. When I run the server (through Docker) and let the server be inactive for some time, I get the following error after making a request on the page.
OperationalError
...
0
votes
0
answers
45
views
Oracle DB Connection to Excel
Oracle DB connection to Excel via ODBC is possible
e.g. Developer can create Excel. Get Data. from Database. Oracle. It asks for Server, SQL statement. and this ODBC works well.
however, Consumer ...
0
votes
0
answers
255
views
Delphi's FireDAC database driver reports "Unsupported MySQL version" -- how do you connect to an up-to-date database?
I have a Delphi 12 application that needs to connect to a MariaDB 11.4 LTS server. The built-in FireDAC database access component supports MariaDB servers between 5.5 and 10.6. This seems unusual, ...
- 1,582
0
votes
0
answers
63
views
Japanese Character set via ODBC to Access and Excel
I've hit an issue with UTF-8 characters and having had a trawl around here and the web I can find similar issues but everything I have tried doesn't work. For the record I'm self-taught so feel free ...
- 21
1
vote
1
answer
69
views
ODBC select * skips SQL Server columns (mismatch sp_columns vs. information_schema.columns)
The situation: Oracle 12.1 (linux) connects to SQL Server (Win) using dg4odbc and MS-SQLServer ODBC driver for linux. Reading from SQL Server via select * from schema.table@dblink works, basically.
...
- 39
2
votes
2
answers
67
views
Excel VBA ODBC reading field changes it to Null
Summary;
The first time I read a data field, I get 0, every time after, the same record field reads Null. This changes if I debug, step through and watch the values in the locals/watchlist, I get Null ...
- 123
1
vote
0
answers
109
views
sqlite3.OperationalError: unknown function: CONCAT_WS() when querying a virtual column with SQLiteODBC
I'm facing an issue with sqlite3.OperationalError: unknown function: CONCAT_WS() in my Python 3.12 application. I'm using the sqlite3 module to connect to an SQLite database via an ODBC driver (http://...
- 78
0
votes
1
answer
96
views
Authenticating into Azure from Python
I am trying to connect from Python to Azure SQL Server to create a table.
My code:
def create_and_store_dataframe_to_azure(df, table_name, server, database, password, driver="ODBC Driver 18 for ...
- 29
0
votes
1
answer
231
views
SSIS ODBC Google BigQuery (Simba) works in local but return ODBC-1 error when I launch pakcage from SQL Agent
I have configured an ODBC connection on my post to connect with Google BigQuery. I couldn't do it natively so I download Simba Drive that helps me to connect with Google BigQuery. I have created a ...
- 1,005
0
votes
0
answers
69
views
Can I create tables and insert data using Power BI?
I'm connected to a SQL Server via ODBC in Power BI. I'd like to take a spreadsheet and essentially copy/paste the spreadsheet columns and data into the SQL Server database via Power BI.
The write back ...
- 1
0
votes
0
answers
68
views
Sybase Advantage Database Server ODBC connection problems to encrypted data dictionary
Is anyone connecting to an Advantage Database data dictionary using ODBC?
I'm having problems trying to connect using an ODBC DNS entry. I'm using ADSODBC and ADSODBC64 from ADS ver 10.10. Here is ...
- 123
0
votes
0
answers
112
views
ODBC connection fails in Docker container but works in interactive shell
In Amazon Linux 2023.6 (AWS), I run a Docker container based on Ubuntu 20.04 that connects to SQL Server using sqlcmd and odbc::dbConnect() in R.
When I open an interactive shell inside the container ...
- 23
0
votes
0
answers
97
views
ODBC settings not getting saved in windows 11 Pro
I have a laptop with Windows 11 Pro. I am trying to create user DSN with "ODBC drive 18 for SQL Server". But my driver is setting back to "SQL Server" always and my server is also ...
- 93