Skip to main content
9,625 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-3 votes
0 answers
127 views

Consider following: qry2 = L"INSERT INTO abcattbl SELECT ?, ?, (SELECT object_id FROM sys.objects o, sys.schemas s WHERE s.schema_id = o.schema_id AND o.name = ? AND s.name = ?), ?, 8, 400, \'N\'...
Igor's user avatar
  • 6,467
2 votes
1 answer
881 views

I recently (as of November 2025) had some working SQL via pyODBC to import an existing CSV file to a table in an Access database. cursor.execute(f""" INSERT INTO [{table_name}] ([Date], ...
maptuv's user avatar
  • 25
0 votes
0 answers
42 views

I use unixODBC to perform database actions on an Informix database. The situation is as follows: I have a result set from which I read records using SQLFetch. In between, autocommit must be disabled. ...
Marco's user avatar
  • 151
1 vote
0 answers
89 views

I'm using the SimbaSparkODBC driver provided by DataBricks on Windows to connect to a DataBricks instance which is running in Azure. Most of the sqls are running fine, but sometimes the result ...
Codeinator's user avatar
  • 709
Advice
0 votes
0 replies
38 views

This is not actually a question: I simply stumbled upon a solution. In setting up a new (Win11) computer I was having trouble making my usual connection between MS Access on my machine and a MySQL ...
phc_joe's user avatar
  • 103
0 votes
0 answers
110 views

I tried the following (error handling omitted for clarity): query1 = "SELECT a,b,c FROM foo;"; query2 = "INSERT INTO bar VALUES( ?, ?, ? );"; SQLAllocHandle( SQL_HANDLE_STMT, ...
Igor's user avatar
  • 6,467
1 vote
0 answers
91 views

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 ...
Angel Panda's user avatar
  • 41
3 votes
1 answer
88 views

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 ...
Conny Olsson's user avatar
  • 1,619
4 votes
3 answers
163 views

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 ...
Виктор Виктор's user avatar
  • 31
Advice
0 votes
1 replies
75 views

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 ...
Nivazz's user avatar
  • 21
0 votes
0 answers
75 views

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 ...
merlin's user avatar
  • 1
2 votes
0 answers
138 views

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 ...
Adrián Mon Maroto's user avatar
  • 21
0 votes
0 answers
41 views

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&...
altchist's user avatar
  • 53
0 votes
1 answer
94 views

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 ...
M.M's user avatar
  • 143k
2 votes
1 answer
60 views

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 ...
Josh Emmick's user avatar
  • 21
0 votes
0 answers
72 views

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 ...
djna's user avatar
  • 56.2k
1 vote
0 answers
136 views

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")....
gee3107's user avatar
  • 362
0 votes
0 answers
27 views

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 ...
John Romel Tinasas's user avatar
  • 1
2 votes
2 answers
172 views

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) ...
tftoclik's user avatar
  • 173
0 votes
0 answers
30 views

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 ...
S. Hasan's user avatar
  • 25
0 votes
0 answers
88 views

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 ...
Sathyanarayanan's user avatar
  • 149
0 votes
0 answers
49 views

In Self Hosted Integration runtime, In Linked service when i'm trying to connect to ODBC driver, I get this following error. ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found ...
Bhargav's user avatar
  • 147
0 votes
0 answers
110 views

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 ...
user1956972's user avatar
  • 1
0 votes
0 answers
40 views

I have an MS Access database on a client computer providing a front-end to a database in SQL Server 2017 on another computer (using tcp:...,1433). I have set up a login/user in the database to be used ...
Zenilogix's user avatar
  • 1,413
0 votes
0 answers
63 views

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: &...
user30842678's user avatar
  • 1
1 vote
0 answers
74 views

I am using Crystal Reports 2025, 64-bit and have downloaded the PostgreSQL ODBC driver from the following link: https://odbc.postgresql.org/. I created a .rpt file, and although I can see the database ...
José's user avatar
  • 15
1 vote
0 answers
65 views

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 ...
user30397791's user avatar
  • 175
0 votes
0 answers
17 views

I am using code charge studio 5.1 and just trying to create a new project. I am using odbc connection to mysql. On a new project if try to use the grid builder and use the connection1 I setup it ...
BSPIT's user avatar
  • 11
0 votes
1 answer
33 views

Multiple data synchronization tasks (synchronizing data from ClickHouse to DolphinDB) were submitted via submitJob. Each task function independently creates an ODBC connection. Observations show: ...
Stella.W's user avatar
  • 27
0 votes
0 answers
130 views

I have Ubuntu 24.04 and php 8.3. I'm trying to connect to an Access DB through PDO ODBC running on the command line. Here is what I have enabled: $ php -i | grep PDO PDO PDO support => enabled PDO ...
raphael75's user avatar
  • 3,268
0 votes
1 answer
66 views

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 ...
Aditya Raute's user avatar
  • 5
1 vote
0 answers
174 views

I have a *.db file that came from SQL Anywhere 17, I need to create an ODBC connection to later connect to Power BI, but the Bank does not start at all. I searched Google, ChatGPT, reinstalled SQL ...
Guilherme Rosendo's user avatar
  • 11
0 votes
0 answers
50 views

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 ...
Prasad tonds's user avatar
  • 7
2 votes
1 answer
219 views

I do connect to a Power BI endpoint via python via the following connection string but I am unable to get it properly working in R via DBI & odbc packages: could someone give me a hand please? Did ...
yeahman269's user avatar
  • 779
0 votes
0 answers
278 views

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, ...
jstarek's user avatar
  • 1,582
0 votes
0 answers
74 views

I am running migration scripts via Alembic, and they are executing successfully. All the tables, including the users table, are created in the SQL Server database without issues. However, when I try ...
Fesisko's user avatar
  • 21
0 votes
0 answers
64 views

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 ...
N G's user avatar
  • 21
0 votes
2 answers
98 views

I am trying to load Microsoft forms data into my organization's SQL Server. Currently, the form is saving its data into an Excel online file that I can access via Sharepoint online. How do I actually ...
Rebel7284's user avatar
  • 13
1 vote
1 answer
73 views

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. ...
dipr's user avatar
  • 39
0 votes
0 answers
60 views

I have downloaded the Simba ODBC connector from the BigQuery page (https://cloud.google.com/bigquery/providers/simba-drivers/). The Simba version is 2.5 and the server side is 2.04 When I create a ...
retry_mk_mail's user avatar
  • 1
2 votes
2 answers
77 views

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 ...
Noodle_Soup's user avatar
  • 123
0 votes
0 answers
24 views

While loading any table into tableau desktop, it shows some extra empty rows other than actual rows. I am using custom ODBC connector. Live mode is working fine, I am facing this issue in Extract mode ...
Atul's user avatar
  • 1
1 vote
0 answers
112 views

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://...
MPadilla's user avatar
  • 78
1 vote
0 answers
59 views

Scenario: I am trying to create a simple Python script that utilizes pyodbc and works with various datasources say sqlserver, azuresql, snowflake etc. Basically any source that supports ODBC ...
rainingdistros's user avatar
  • 669
0 votes
1 answer
102 views

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 ...
Roberto92's user avatar
  • 29
0 votes
2 answers
109 views

I am using the ODBC diver via .NET 4.8 to connect to Dremio but getting this error: System.Data.Odbc.OdbcException HResult=0x80131937 Message=ERROR [HYC00] [Apache Arrow][Flight SQL] (100) ...
chrisb's user avatar
  • 1,425
0 votes
1 answer
236 views

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 ...
bosskay972's user avatar
  • 1,005
0 votes
1 answer
57 views

Sybase SQL syntax for accessing tables is <user>.<table>. I am using the ASE ODBC driver to connect Excel to an old on-premise installation of Sybase, which requires a logon username to ...
Enrico's user avatar
  • 335
0 votes
0 answers
77 views

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 ...
cibb's user avatar
  • 1
0 votes
0 answers
21 views

We have application based on Python 3.12 in which we connect to Netezza and SQL Server using pyodbc package with Kerberos authentication from RHEL8 Python 3.12 container. Connection was working as ...
user30013773's user avatar
  • 1

1
2 3 4 5
…
193