-
Jerry - thanks so much for this link - this is great info, thank you!
-
To do date math in InfoPath, use the addDays() function. More here.
-
Thank you for explaining this to me. I am learning a million different things on this project.
It turns out that after I removed the DBXL app pool user from datareader and datawriter as owners of the schema (by going to Schemas under Security), then adding app pool to Role Members instead, it all started working! WOO HOO
-
In theory, you can have DBXL installed on SQL_SERVER_1 and have QueryDB retrieve data from SQL_SERVER_2 and map data to SQL_SERVER_3, as long as all permissions are set correctly. It's just a little more difficult to manage with all the different connections.
In the case where DBXL is being accessed by a remote server, then you'll need to ...
-
OK I went looking at QdabraDBXL database and it's installed on that first server, DB2 (my developement SQL server), not the one I am using now, DB1 (my production SQL server), Is that the problem?
Also the permissions are the correct app pool used to install DBXL however I checked datareader and datawriter in ...
-
In this scenario, it's not DAT that goes offline but rather InfoPath itself. I would close all the instances of InfoPath Filler, then reopen Filler and look under File to see if the option to go Online shows up.
For troubleshooting the connectivity issues, what I typically do is look for the QdabraDBXL database that is currently in use by ...
-
No.I didn't reinstall DBXL. I'm just pointing DBXL to a different SQL server to retrieve data than the first time I used it. Different form, different server, different database.
I am now having trouble connecting to SQL through DAT. I am using the correct app pool to access the database, DB1 in my ...
-
Hi Doreen,
When Query Builder connects to the database, it is doing so as you (the user).
However, when the web service connects, it does so as the service account.
Please check the application pool for DBXL ; this will tell us what the service account is. Then add SQL permissions for that account.
This should resolve the issue, but let us ...
-
On the database I am trying to connect to, I added the DBXL service account that I used to set up DBXL, to logins on SSMS (overall) Security. Then I added that same user account to the database I wanted to access and granted db_datareader adn db_datawriter. I am able to access the database using Query ...
-
Hi,
I'm sorry that the user guide still mentions the install.js.
Can you try to follow the steps in the document called "qRules Full Trust Form Installation Guide"? This should be available in
C:\Program Files (x86)\Qdabra Software\Qdabra Rules Library\Forms
Thanks.