logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
ODBC as data source
Options
Go to last post Go to first unread
Previous Topic Next Topic
Speegs  
#1 Posted : Wednesday, November 30, 2016 10:02:09 AM(UTC)
Speegs

Rank: Advanced Member

Groups: Registered
Joined: 8/3/2013(UTC)
Posts: 405
Location: Gold Coast, Australia

Thanks: 27 times
Was thanked: 76 time(s) in 58 post(s)
Hello,

Thanks for the fine work on data sources, I noticed one thing missing.

I Suggest adding ODBC as an option. That will open up more sources of data.

Things like:

MS SQL Servers
MS Access Files
My SQL Servers/MariaDB
Oracle
PostgreSQL
MongoDB

Many other strange and wonderful formats that are not that common as well.

Thanks,

Speegs
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
chrisdurkee  
#2 Posted : Tuesday, January 30, 2018 11:46:18 PM(UTC)
chrisdurkee

Rank: Newbie

Groups: Registered
Joined: 4/25/2017(UTC)
Posts: 4
Man
Location: California

Thanks: 1 times
Has this been looked into?
Back to top
mcollege  
#3 Posted : Monday, December 7, 2020 2:10:17 PM(UTC)
mcollege

Rank: Member

Groups: Registered
Joined: 8/17/2018(UTC)
Posts: 12
Apologies for the necropost but I was thinking about this just now.

We have started to stream almost all of our school events online including Award ceremonies and it would be great to tap directly into our databases to pull out staff, student and photo details for titles.

Short of that it would be developing some bespoke web app to tap into these data sources and publish JSON or something out.
Back to top
DWAM  
#4 Posted : Monday, December 7, 2020 6:08:59 PM(UTC)
DWAM

Rank: Advanced Member

Groups: Registered
Joined: 3/20/2014(UTC)
Posts: 2,721
Man
France
Location: Bordeaux, France

Thanks: 243 times
Was thanked: 794 time(s) in 589 post(s)
While I +1 this FR, I want to mention that it's already possible to use all those databases (SQL, MySQL, Access, Oracle, ...) without an ODBC driver implemented in vMix. I have been doing it for years already.

The solution is to write and query a script (ASPX, PHP, Ruby or anything you like) from vMix that does the SQL request against your database and formats the results so that vMix can use it, for example in CSV, XML or JSON.
Back to top
WWW
doggy  
#5 Posted : Monday, December 7, 2020 7:06:44 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,222
Belgium
Location: Belgium

Thanks: 293 times
Was thanked: 955 time(s) in 790 post(s)
plus on answer from DWAM

Also did it as such.
Besides if it woud be available directly in vMix i bet there would lots of support questions regarding acces granted to the databases issues LOL
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.124 seconds.