Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Setting up ODBC for CQC
#1
Having issues setting up the DataLogDB driver. Was working fine, realized I never re-installed SQL*Server and then the driver when I switched master servers a while back.  I have SQL*Server setup just fine, did all 3 types of ODBC (Native, etc) under a System DSN account using Windows NT login. But CQC doesn't see the ODBC when I try and add a DataLogDB driver. It just shows a blank screen. (well technically it shows ElkRP as an ODBC source but obviously that's wrong)

It's been forever since I first set this up, wondering if I missed a step.
------------------------------------
Devices I'm phasing out: ISY, NuVo
My vlogs: https://www.youtube.com/c/IVBsHomeAutomation
Reply
#2
Create a regular administrative account and set up the CQC app shell service on that machine to log in under that. In these days of paranoia, the default service account probably doesn't have such rights.
Dean Roddey
Software Geek Extraordinaire
Reply
#3
I'm putting all this on my MS. Do you mean a regular admin account on the actual MS? I think i'm doing what you're saying, but to be clear:

I have a Windows admin user called BigVivek. CQC logs in as that user under logon.

That same user (BigVivek) is what I used to install SQL*Server.

Or did I misunderstand what you meant by "default service account"?

Ugh. This is identical to what I did beforehand, but this is Windows10 which is all hinky.
------------------------------------
Devices I'm phasing out: ISY, NuVo
My vlogs: https://www.youtube.com/c/IVBsHomeAutomation
Reply
#4
NVM. Got it working by specifying a User DSN. (Hail Mary on it since everything else was tagged to that user)
------------------------------------
Devices I'm phasing out: ISY, NuVo
My vlogs: https://www.youtube.com/c/IVBsHomeAutomation
Reply
#5
When CQC is installed the background services run under a default account that is used for services. But over time it has gotten more and more restricted. In some cases you have to set up the app shell to log in under a regular admin type account that you create for it. That will get rid of those restrictions.
Dean Roddey
Software Geek Extraordinaire
Reply
#6
Not sure what you're using the DB for but influx DB and Grafana have proved a powerful combination for me.
|Z-Wave|Sonos|Tivo|Hue|Plex|Roku|MyMovies|Echo|
Nest|Harmony|Neeo|LG TV|Smarthings|
Reply
#7
Are you using them with the data log db driver?
------------------------------------
Devices I'm phasing out: ISY, NuVo
My vlogs: https://www.youtube.com/c/IVBsHomeAutomation
Reply
#8
I am not. I believe there’s a CQC macro for logging to influx dB. I’m using it with a smarthings app to log stuff. Also use grafana a lot professionally. I can post a screenshot tomorrow, remind me if I forget.
|Z-Wave|Sonos|Tivo|Hue|Plex|Roku|MyMovies|Echo|
Nest|Harmony|Neeo|LG TV|Smarthings|
Reply
#9
I should also point out that you can use sql as a data source for grafana.
|Z-Wave|Sonos|Tivo|Hue|Plex|Roku|MyMovies|Echo|
Nest|Harmony|Neeo|LG TV|Smarthings|
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Help setting up GeoFancy & HTTP Trigger driver Sendero 10 2,345 04-20-2015, 11:08 AM
Last Post: bbrendon
  Problem setting up UPB driver bbrendon 1 682 01-11-2013, 11:28 PM
Last Post: bbrendon
  ODBC on 64-bit systems pseigler 15 2,881 12-19-2010, 11:42 AM
Last Post: Dean Roddey
  setting password for users beside Admin datadawg 2 1,023 09-10-2009, 11:02 AM
Last Post: datadawg
  setting the day on a weather page potts.mike 2 1,012 10-22-2008, 08:18 AM
Last Post: potts.mike
  Setting Password anogee 6 962 10-16-2008, 10:39 AM
Last Post: Dean Roddey
  Setting up CQC & ELK M1 Questions kayemsi 2 801 12-19-2007, 08:23 PM
Last Post: Dean Roddey
  Noobie question: setting up variables driver kayemsi 1 652 09-04-2007, 07:45 PM
Last Post: Dean Roddey
  Newb question : Setting up Insteon Scenes w/CQC Sendero 2 860 07-22-2007, 04:41 PM
Last Post: Sendero
  setting up audio repository and converting from itunes help? pjwinstalls 3 908 05-29-2007, 10:37 AM
Last Post: NishanF

Forum Jump:


Users browsing this thread: 1 Guest(s)