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

Boom!

The OpenLink Software #AI Layer (#OPAL) now supports AnthropicAI's #Claude language models.

See comments for a #DataTwingler AI Agent demo executing #SPARQL and #SQL queries via a live #VirtuosoRDBMS instance.

Remember, query scope is SPARQL, #ODBC, or #JDBC accessible data sources.

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

To extend your Auth DB options in VerneMQ: Here's an initial prototype script to connect via ODBC: https://github.com/vernemq/vernemq/pull/2298 #MQTT #ODBC #VerneMQ

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/

The OpenLink Personal Assistant (#OPAL) is a #ChatGPT-based #SmartAgent for invoking Actions via Functions that operate on data accessible via #HTTP, #ODBC, or #JDBC.

You can query a #DBMS, #KnowledgeGraph, #LODCloud, or #Web at large.

All thanks to our #VirtuosoRDBMS.

We are pleased to announce immediate availability of the 7.2.11 stable-edition of the Open Source Edition of our #VirtuosoRDBMS.

https://community.openlinksw.com/t/virtuoso-open-source-7-2-11-release-notes/

#Microsoft == unnötig Nerven aufreibend

Hab heute Stunden damit zugebracht von einem in #Rust Code geschriebenen Programm auf einen #MSSQLServer per #ODBC zuzugreifen. Hab es zwischendurch auch in #Python mit #sqlalchemy versucht. Mit #DBeaver ging's, mit #beekeeper ging's, per Ping ging's.
Bis ich mir endlich einen passenden #ADO String gebaut hatte der dem Server genehm war.
Sowas passiert mir bei #PostgreSQL nie und auch sonst kenne ich keine solche Diva DB.

#PowerShell with #ODBC to interact with #PostgreSQL (#Linux and #Windows) - MigOps https://www.migops.com/blog/powershell-with-odbc-to-interact-with-postgresql-linux-and-windows/

Maybe I'm just dumb, but I really don't understand #odbc

"ODBC is a universal interface to databases... all you have to do is install this platform-specific driver for each database you need to connect to!"

So... not universal then?

I asked #gptChat about Ruby On Rails and its ActiveRecord ORM layer, using a collection of keywords (in Google Search form).

Here's a link to what it returned.

https://carbon.now.sh/?bg=rgba%28171%2C+184%2C+195%2C+1%29&t=seti&wt=none&l=htmlmixed&width=680&ds=true&dsyoff=20px&dsblur=68px&wc=true&wa=true&pv=56px&ph=56px&ln=false&fl=1&fm=Hack&fs=14px&lh=133%25&si=false&es=2x&wm=false&code=Ruby%2520on%2520Rails%2520is%2520a%2520web%2520application%2520framework%2520written%2520in%2520the%2520Ruby%2520programming%2520language.%2520It%2520is%2520designed%2520to%2520make%2520programming%2520web%2520applications%2520easier%2520by%2520making%2520assumptions%2520about%2520what%2520developers%2520need%2520and%2520providing%2520them%2520with%2520a%2520structure%2520to%2520build%2520their%2520applications.%250A%250AActive%2520Record%2520is%2520a%2520Ruby%2520gem%2520that%2520is%2520part%2520of%2520the%2520Ruby%2520on%2520Rails%2520framework.%2520It%2520is%2520an%2520object-relational%2520mapping%2520%28ORM%29%2520library%2520that%2520provides%2520an%2520interface%2520between%2520a%2520database%2520and%2520a%2520Ruby%2520program.%2520Active%2520Record%2520allows%2520you%2520to%2520interact%2520with%2520a%2520database%2520using%2520Ruby%2520objects%252C%2520rather%2520than%2520writing%2520raw%2520SQL%2520statements.%250A%250AODBC%2520%28Open%2520Database%2520Connectivity%29%2520is%2520a%2520standard%2520interface%2520for%2520accessing%2520database%2520management%2520systems.%2520It%2520provides%2520a%2520way%2520for%2520applications%2520to%2520communicate%2520with%2520different%2520databases%252C%2520regardless%2520of%2520the%2520database%2520system%2520being%2520used%2520or%2520the%2520structure%2520of%2520the%2520data%2520being%2520stored.%250A%250ATo%2520use%2520ODBC%2520with%2520Active%2520Record%2520in%2520a%2520Ruby%2520on%2520Rails%2520application%252C%2520you%2520will%2520need%2520to%2520install%2520the%2520ruby-odbc%2520gem.%2520This%2520gem%2520provides%2520a%2520database%2520adapter%2520for%2520Active%2520Record%2520that%2520allows%2520you%2520to%2520connect%2520to%2520an%2520ODBC-compliant%2520database%2520using%2520the%2520Active%2520Record%2520API.%2520You%2520will%2520also%2520need%2520to%2520have%2520an%2520ODBC%2520driver%2520installed%2520for%2520the%2520database%2520system%2520you%2520are%2520trying%2520to%2520connect%2520to.%2520Once%2520you%2520have%2520the%2520gem%2520and%2520driver%2520installed%252C%2520you%2520can%2520configure%2520your%2520Ruby%2520on%2520Rails%2520application%2520to%2520use%2520ODBC%2520as%2520the%2520database%2520adapter%2520by%2520specifying%2520the%2520odbc%2520adapter%2520in%2520your%2520database%2520configuration%2520file.%250A%250AHere%2520is%2520an%2520example%2520of%2520how%2520you%2520might%2520configure%2520Active%2520Record%2520to%2520use%2520ODBC%2520in%2520a%2520Ruby%2520on%2520Rails%2520application%253A%250A%250A%2523%2520config%252Fdatabase.yml%250A%250Adevelopment%253A%250A%2520%2520adapter%253A%2520odbc%250A%2520%2520database%253A%2520my_database%250A%2520%2520username%253A%2520my_username%250A%2520%2520password%253A%2520my_password%250AYou%2520will%2520need%2520to%2520replace%2520my_database%252C%2520my_username%252C%2520and%2520my_password%2520with%2520the%2520appropriate%2520values%2520for%2520your%2520database.%2520Once%2520you%2520have%2520configured%2520the%2520database%2520connection%252C%2520you%2520can%2520use%2520Active%2520Record%27s%2520API%2520to%2520query%2520and%2520manipulate%2520the%2520data%2520in%2520your%2520ODBC-compliant%2520database.

This all started as part of our research to loosely-couple @Mastodon with backend storage beyond #PostgreSQL.

Windows Updates: Datenbankverbindungen mit ODBC können fehlschlagen

Microsoft meldet ein Problem mit den November-Patches für Windows, durch das ODBC-Verbindungen auf SQL-Server fehlschlagen können.

https://www.heise.de/news/Windows-Updates-Datenbankverbindungen-mit-ODBC-koennen-fehlschlagen-7369610.html?wt_mc=sm.red.ho.mastodon.mastodon.-.-