Qdabra Database Accelerator

Re: Question about using DBXL QueryDB from SharePoint page

Catharine — Fri, 12 Nov 2010 17:00:53 GMT

I have been doing some investigation and think I have got to the bottom of it....

It is not the data connection which is causing the problem.

Some time ago I got a file InfoPathOpen.js from you. To be able to click on a hyperlink for an infopath file without getting prompted to open the file. Put that on the server as suggested and put a <script type="text/javascript" src=".... reference in the form.

I obviously put it in the wrong place... I could access it but not all of the users. I have now moved it and got rid of the 3 prompts. Phew ! Thank you for your help.

Catharine.

Re: Question about using DBXL QueryDB from SharePoint page

Jimmy — Fri, 12 Nov 2010 15:17:37 GMT

DBXL doesn't allow anonymous access, and from what I can find, the "Don't attempt to authenticate" option is designed to prompt for a password when anonymous access doesn't work. Have you tried the Windows authentication option?

Re: Question about using DBXL QueryDB from SharePoint page

Catharine — Fri, 12 Nov 2010 13:27:04 GMT

Hi,

The problem is nothing to do with InfoPath.

The problem occurs when opening a SharePoint screen which has a data connection to a DB via DBXL Query DB. - It is not opening any Infopath form.

The problem still exists.

Catharine

Re: Question about using DBXL QueryDB from SharePoint page

Patrick Halstead — Fri, 12 Nov 2010 12:51:48 GMT

Hi Catharine,

Trusted doesn't work for .NET and that applies to InfoPath forms with code. Your form has a lot of code so please remove from Trusted and add to Local Intranet and let us know if that fixes your issue.

I'm going offline now but Ernesto and the rest of the support team will be around to respond.

Question about using DBXL QueryDB from SharePoint page

Catharine — Fri, 12 Nov 2010 10:22:13 GMT

I have DBXL 2.3.

I have a SharePoint page in which I have a data table. The data table is populated by a call to qdabrawebservice/querydb.asmx. using the GetCloumnsXMLStrQuery. (Login is set to Don't attempt to authenticate.)

This works very well for me. However when I release it to other users they are being prompted for their username and password three times before the screen opens and displays the data. The same is true if they refresh the screen.

The users are in the correct permissions groups for the site/page, other pages without data connections on the same site are fine. So I can only conclude that it is the data connection that is causing this.

Users may have either IE8 or IE6. We have tried putting the SharePoint site into the Trusted list in IE. and this does not solve the issue.

Does anyone have any ideas about what the issue could be - or where I can start looking ?

The permissions area of my Web.config for DBXL looks like - is there something missing ?

Thank you.

Catharine