The Model Context Protocol acts as a universal translator between LLMs and data sources, eliminating complex platform-specific requirements. Our new open source MCP server for ODBC (mcp-odbc-server) enables seamless integration of any ODBC-accessible data into RAG pipelines.
Read more in my latest newsletter!
https://www.linkedin.com/pulse/whats-model-context-protocol-why-important-kingsley-uyi-idehen-zy8ue
Mind９β Tcl拡張単語とC言語DLL拡張単語でPostgreSQLにODBCトランザクション
https://qiita.com/mylifewithviolin/items/d5d4c58f9d6c82d522a4?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
Mind7/8からMind９βへの移行 C言語DLL拡張単語は動作するか（odbcライブラリ）
https://qiita.com/mylifewithviolin/items/21fa8a6e7531c7d67196?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
Spent 2 days fighting with ODBC in C++ trying to get column-wise binding to work with variable length std::strings. So we can insert multiple rows in a single parameterised SQL statement. Have got it working with less exotic types like ints and even datetimes, but strings are proving to be a pita. Battle recommences tomorrow. #cpp #odbc
Posit Professional Drivers - ODBC data connectors for connecting to some of the most popular databases - now natively support Apple silicon!
Now, it’s even easier to connect and use your databases from RStudio.
Learn more: https://posit.co/blog/pro-drivers-2024-03-0/
#Microsoft hat eine temporäre Lösung für ein Verbindungs-Problem veröffentlicht, das Windows-Anwendungen betrifft, die #ODBC-Datenbanken nutzen. https://winfuture.de/news,133922.html?utm_source=Mastodon&utm_medium=ManualStatus&utm_campaign=SocialMedia
@kidehen @ascherbaum @Mastodon,
Binding happens via #ActiveRecord which already has #ODBC binding 
#libreoffice #qa #testing can be both extremely tiresome and immensely rewarding. Today's #FOSS reward comes with the pre-release of #libreoffice 7.5 on #macos #ventura. Making a #database connection over #ODBC now works again with the appropriate #drivers, and the #Xerial #JDBC driver 3.40.0.0 also enables read/write functionality to #sqlite3 #databases. Finally! All that remains is for these recently fixed features to be included in the #Appstore release! Fingers crossed!
Quest:
Existence of an #ODBC binding for Mastodon that decouples it from #PostgresSQL.
#MySQL only comes into play due to our mysql2odbc library for decoupling MySQL apps.
Based on our expertise and 30+ years of experience re #DataAcces, #DataConnectivity (ODBC and #JDBC), and DBMS tech (see our #VirtuosoRDBMS), I know we can build such a binding if need be.
Initially though, I am curious about what may already exist rather than what’s possible 
@ascherbaum ,
I know what the #ODBC, #API, Database Management Systems (#DBMS), and #Databases are about.
FWIW — lookup #VirtuosoRDBMS a product I brought to life 32 years ago.
I’ve worked on #DataAccess, #DataConnectivty, and Data Management technology since the late 80’s.
If an ODBC binding for Mastodon doesn’t exist, I’ll simply get it built if need be.
My post was all about seeking what exists, rather than what’s possible (which I actually understand).
In my experience, #ODBC has never meant lowest common featurest. In fact, it's quite the opposite.
Methinks:
Since ODBC is some 30 yrs of age, there are generations of developers that are unaware of both its capabilities and fundamental virtues.
A Mastodon binding to ODBC would test our contrasting theories too
@el_pink,
In my experience, it’s suboptimal to write #DBMS specific apps and services.
I want to bind Mastodon to a #dbms that I already know is much faster and scalable that either #postgresql or #mysql amongst other goodies. It will also brings features like native full-text indexing, caching, and so much more.
I only need #odbc binding to unveil an additional option that ups the ante re performance and scalability per buck.
@Mastodon
#introduction
I am an open data access (#ODBC, #JDBC, and #HTTP), integration (#DataVirtualization), and data management (#DBMS and/or #KnowledgeGraph) technologist, enthusiast, and entrepreneur.
I am passionate about open standards for #GenAI, #AI, #Identity #Authenticity, #SocialMedia (#ActivityPub & #ActivityStreams), and data de-silo-fication initiatives (e.g. #SemanticWeb, #LODCloud, #LinkedData, #RWW, and #SmallData).
I don't like any kind of silo!
Exotic problem: Old #Access database, old software, must run on new industrial PC with #Windows10. Database accesses via #ODBC driver are crazy slow - but there is a workaround.
Exotisches Problem: Alte #Access-Datenbank, alte Software, muss auf neuem Industrie PC mit #Windows10 laufen. Datenbankzugriffe per #ODBC-Treiber sind irre langsam - aber es gibt einen Workaround.
Qiita - 人気の記事 
