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,486 04-20-2015, 11:08 AM
Last Post: bbrendon
  Problem setting up UPB driver bbrendon 1 747 01-11-2013, 11:28 PM
Last Post: bbrendon
  ODBC on 64-bit systems pseigler 15 3,063 12-19-2010, 11:42 AM
Last Post: Dean Roddey
  setting password for users beside Admin datadawg 2 1,117 09-10-2009, 11:02 AM
Last Post: datadawg
  setting the day on a weather page potts.mike 2 1,070 10-22-2008, 08:18 AM
Last Post: potts.mike
  Setting Password anogee 6 1,041 10-16-2008, 10:39 AM
Last Post: Dean Roddey
  Setting up CQC & ELK M1 Questions kayemsi 2 863 12-19-2007, 08:23 PM
Last Post: Dean Roddey
  Noobie question: setting up variables driver kayemsi 1 689 09-04-2007, 07:45 PM
Last Post: Dean Roddey
  Newb question : Setting up Insteon Scenes w/CQC Sendero 2 902 07-22-2007, 04:41 PM
Last Post: Sendero
  setting up audio repository and converting from itunes help? pjwinstalls 3 969 05-29-2007, 10:37 AM
Last Post: NishanF

Forum Jump:


Users browsing this thread: 1 Guest(s)