Jump to content

kbelmont

Members
  • Posts

    1
  • Joined

  • Last visited

Posts posted by kbelmont

  1. After poking around on this forum, I'm still not sure I have the answer to this question. I'm hoping a user out there has some experience with this.

     

    Does the user authentication from database feature work in the trial version? I'm looking this applicaiton over as a possible replacement to our in house software, and I'd like to use our existing SQL database for user management rather that configuring individual Dial Dictate installations. I did what I could to configure it, and the Test button from the Advanced Options page works. However, actually calling in does not. I'm beginning to suspect the feature is disabled in the trial version because I cannot get any user other than the default to work.

     

    It's very strange though, because if I profile the SQL server Dial Dictate runs the following code against it:

     

    declare @p1 int
    set @p1=180150003
    declare @p3 int
    set @p3=8
    declare @p4 int
    set @p4=1
    declare @p5 int
    set @p5=1
    exec sp_cursoropen @p1 output,N'select DialDictateID from DialDictateUsers where Password=''1''',@p3 output,@p4 output,@p5 output
    select @p1, @p3, @p4, @p5

     

    The first stored proc here returns nothing. However, if you extract the select statement out of it (and take out the extra text qualifiers), it returns the proper value.

     

    select DialDictateID from DialDictateUsers where Password='1'

     

     

    Maybe I'm just doing something wrong? Any users out there set this up before? I'd like to get this up and working before I start asking management to buy this product.

×
×
  • Create New...