Skip to main content

Questions tagged [odbc]

ODBC is an acronym for the Open Database Connectivity standard. It is often used to refer to the actual ODBC driver, which allows for Database Management Service independence by acting as a tranlation layer between an application and the DBMS.

Filter by
Sorted by
Tagged with
2 votes
1 answer
252 views

Efficient Connection Pooling in ODBC-MSSQL with Rust (odbc-api)?

I want to connect to MSSQL using ODBC (odbc-api) at the beginning of my server application created with hyper.rs. I want to have a connection pool and obtain a connection within each request, which ...
dertin's user avatar
  • 21
1 vote
2 answers
1k views

Python function to connect to MS SQL using connection parameters from environment variables

I have the following file that is included in others. I realise I need to put in try/except but for the purposes of this question, the below should suffice We're ...
pee2pee's user avatar
  • 380
2 votes
0 answers
55 views

SQL (ODBC) bind to C++ classes row-wise (follow-up)

This is follow-up on SQL (ODBC) bind to C++ classes row-wise The main idea behind this code is to minimize the number of ODBC API calls, because profiling shows significant amount of time is spent in ...
OwnageIsMagic's user avatar
0 votes
1 answer
49 views

Code scrapes, queries against a database and intersects

The code base is split between three different files odbc.py, scrape.py, and dataprocessor.py. For ODBC, the job of this file is to take scraped data and determine whether or not those results are in ...
ParanoidPenguin's user avatar
5 votes
2 answers
553 views

SQL (ODBC) bind to C++ classes row-wise

I created it to map buffers returned by ODBC driver to my objects directly without creating DataSet like storage. It works quite nice, but I have some questions. UPD: I resoled those questions, just ...
OwnageIsMagic's user avatar
0 votes
1 answer
4k views

Python script to query REST API and write to database

I wrote the following sample script for learning purposes: ...
Adam's user avatar
  • 143
2 votes
3 answers
139 views

Pulling N rows from list of tables

I wrote a simple C# application that connects to ODBC DB and pull the first N Rows from each table in a List. Then saves the query output to a separate text file, also in the case where there is an ...
WT86's user avatar
  • 181
2 votes
2 answers
631 views

SQL Query over ODBC is slow with DISTINCT

Is there any way to simplify this query? It's being run against a Progress Database via an ODBC connection. The CustomerSalesperson table has a ...
WhiteHotLoveTiger's user avatar
5 votes
1 answer
135 views

Updating an item's status in MS SQL Server using ODBC

Is the following query is vulnerable in terms of $itemstatus? I want to be sure about it. $yesorno is a user input which is ...
Monk25's user avatar
  • 51
5 votes
2 answers
4k views

Synchronization of an ODBC connection

Since I'm venturing more and more into the multithreading, I now need to think about how to protect my precious OdbcConnection from breaking at random times. The ...
Bobby's user avatar
  • 7,722