Announcement

Collapse
No announcement yet.

MS SQL Integration for UE4

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

    #16
    Hi, I find that if the server I'm trying to connect to does not exist or is not reachable, Unreal crashes.
    Is there perhaps a way to make the plugin fail in a safe way?
    Perhaps add a "Connection Success" Boolean as an output node? A fail dialogue node can also be very useful...i.e. help to determine if it war the server credentials or user credentials which caused the connection failure.

    Comment


      #17
      Originally posted by Andypants View Post
      Hi, I find that if the server I'm trying to connect to does not exist or is not reachable, Unreal crashes.
      Is there perhaps a way to make the plugin fail in a safe way?
      Perhaps add a "Connection Success" Boolean as an output node? A fail dialogue node can also be very useful...i.e. help to determine if it war the server credentials or user credentials which caused the connection failure.
      Hey. The Set Connection Properties does check the connection failure state as well. We check its status in tick event as it performs the operation async, and only proceed to reading or writing the data to the server, when a connection is successful. The function Check Connection State is there for this purpose.
      DayNight Cycle - https://www.unrealengine.com/marketplace/daynight-cycle
      Jigsaw Puzzle Template - https://www.unrealengine.com/marketp...uzzle-template
      Post Process Blendables Volume 1 - https://www.unrealengine.com/marketp...ndables-volume
      MSSQL Integration for UE4 - https://www.unrealengine.com/marketp...ql-integration
      Radar System with Minimap - https://www.unrealengine.com/marketp...m-with-minimap

      Comment


        #18
        Feeling a little stumped as to what I'm doing wrong... connection to SQL gets established when the login level loads up, widget gets created and any errors do get reported back properly through printstring from the query nodes. I've checked the data table in MSSM and it only has null entries since nothing has been added yet, the code is returning an = to any account name entered and flagging "AccountNameIsInUse?" as true.

        ???
        Click image for larger version

Name:	loginqueryissue.jpg
Views:	54
Size:	225.6 KB
ID:	1727819

        Comment


          #19
          Originally posted by WGS_Stillwater View Post
          Feeling a little stumped as to what I'm doing wrong... connection to SQL gets established when the login level loads up, widget gets created and any errors do get reported back properly through printstring from the query nodes. I've checked the data table in MSSM and it only has null entries since nothing has been added yet, the code is returning an = to any account name entered and flagging "AccountNameIsInUse?" as true.

          ???
          Click image for larger version

Name:	loginqueryissue.jpg
Views:	54
Size:	225.6 KB
ID:	1727819
          Hey,

          The Query looks fine, so in this case I would suggest try the UpdateQueryAsync method first. Also you can check out with example WIdgets present in the Plugin Content Directory.
          DayNight Cycle - https://www.unrealengine.com/marketplace/daynight-cycle
          Jigsaw Puzzle Template - https://www.unrealengine.com/marketp...uzzle-template
          Post Process Blendables Volume 1 - https://www.unrealengine.com/marketp...ndables-volume
          MSSQL Integration for UE4 - https://www.unrealengine.com/marketp...ql-integration
          Radar System with Minimap - https://www.unrealengine.com/marketp...m-with-minimap

          Comment


            #20
            Originally posted by sameek4 View Post

            Hey,

            The Query looks fine, so in this case I would suggest try the UpdateQueryAsync method first. Also you can check out with example WIdgets present in the Plugin Content Directory.
            To follow up, the way I got the code to work was to change the "get" node to a "contains" and then store the array index as a variable and use that variable for the get node when checking the password against the account name. Everything works after doing that! *shrug*

            Comment


              #21
              Originally posted by WGS_Stillwater View Post

              To follow up, the way I got the code to work was to change the "get" node to a "contains" and then store the array index as a variable and use that variable for the get node when checking the password against the account name. Everything works after doing that! *shrug*
              Oh nice . Glad to know you figured it out.
              DayNight Cycle - https://www.unrealengine.com/marketplace/daynight-cycle
              Jigsaw Puzzle Template - https://www.unrealengine.com/marketp...uzzle-template
              Post Process Blendables Volume 1 - https://www.unrealengine.com/marketp...ndables-volume
              MSSQL Integration for UE4 - https://www.unrealengine.com/marketp...ql-integration
              Radar System with Minimap - https://www.unrealengine.com/marketp...m-with-minimap

              Comment

              Working...
              X