Announcement

Collapse
No announcement yet.

need some sql help

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    need some sql help

    Ok so I had sql 2000 sp3 installed and working.. i decided to install sql 2005 and sql 2008 to play around... well long story short is I uninstalled ALL versions and got sql 2000 sp3 re-installed.

    Now for some reason my sql is not right..
    example is with ultralog... connection string can be

    Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=HomeSeerDB;Trusted_Connection=yes

    or

    Provider=SQLOLEDB;Data Source=servername;Initial Catalog=HomeSeerDB;Trusted_Connection=yes

    the first one works but if I use the second one (yes put my server name in there instead of just servername) it fails.

    now I do not know why that would be but due to that...
    I got ultralog working again since you create the db manually with the code proveded..... so that is why this isnt posted under ultralog as it is working fine..

    now if I try and install any app that wants to use sql as the database, I get a failure and sql will not create a database.. not sure why....

    anyone know where logs or anything is where I can check to try to fix this?

    also any pointers based on what I said above?
    Thanks
    Jeff
    HW - i5 4570T @2.9ghz runs @11w | 8gb ram | 128gb ssd OS - Win10 x64

    HS - HS3 Pro Edition 3.0.0.435

    Plugins - BLRF 2.0.94.0 | Concord 4 3.1.13.10 | HSBuddy 3.9.605.5 | HSTouch Server 3.0.0.68 | RFXCOM 30.0.0.36 | X10 3.0.0.36 | Z-Wave 3.0.1.190

    Hardware - EdgePort/4 DB9 Serial | RFXCOM 433MHz USB Transceiver | Superbus 2000 for Concord 4 | TI103 X-10 Interface | WGL Designs W800 RF | Z-Net Z-Wave Interface

    #2
    this may also help..
    if I got to odbc under admin tools... system dsn I get this when I try and connect to the sql server...
    Attached Files
    HW - i5 4570T @2.9ghz runs @11w | 8gb ram | 128gb ssd OS - Win10 x64

    HS - HS3 Pro Edition 3.0.0.435

    Plugins - BLRF 2.0.94.0 | Concord 4 3.1.13.10 | HSBuddy 3.9.605.5 | HSTouch Server 3.0.0.68 | RFXCOM 30.0.0.36 | X10 3.0.0.36 | Z-Wave 3.0.1.190

    Hardware - EdgePort/4 DB9 Serial | RFXCOM 433MHz USB Transceiver | Superbus 2000 for Concord 4 | TI103 X-10 Interface | WGL Designs W800 RF | Z-Net Z-Wave Interface

    Comment


      #3
      try using the IP address instead of the server name - that would rule out some DNS issue.
      HS4Pro on a Raspberry Pi4
      54 Z-Wave Nodes / 21 Zigbee Devices / 108 Events / 767 Devices
      Plugins: Z-Wave / Zigbee Plus / EasyTrigger / AK Weather / OMNI

      HSTouch Clients: 1 Android

      Comment


        #4
        Sounds like the name isn't being resolved.

        If you reference the name in lots of places you could try adding the following to your hosts file.

        First find the hosts file in Windows\System32\Drivers\etc\

        Open it with notepad and add

        127.0.0.1 severname

        It should work like that on the local machine on other machines you would replace 127.0.0.1 with the IP of the server.

        Comment

        Working...
        X