InfoPath Dev

 How can I add a space between text in a footer section?  It seems that typing spaces is ignored and all text collapses together.

I am trying to add QueryDB connection to my form and having trouble.  In data connection wizard, my parameter is "ns3:queryXml" -- what does that mean?  When I did the tutorial Copy sql values to infopath repeating section fields using querydb, this parameter was "tns:queryxml"  Does that matter?

Urgh.  I must have misunderstood the tutorial by Jo-Anne Alfafara that I watched on youtube this week. I thought she said to use the machine name where Query Builder is installed (I installed it on my local machine), in the web service URL -- the video was blurry, and the sound was bad... http://SHAREPOINTSERVER, worked! Thank you ...

My DAT connection between server and form works which I understand uses app pool account.  Security on database matches the way database QdabraDBXL is set, and like I said, it connects in DAT successfully Query Builder I understand,  uses my user account so there should be no problem.  My account has sysadmin priviledges on SQL ...

I'm confused. I'm using several tutorials to piece together how to do my project.  I thought I was supposed to use Query Builder first,  to create the queryxml? 

I am currently following Hillary's tutorial "Use DBXL submit with existing SQL data" with my own database, which is similar to the one in the tutorial.  Form is setup in DAT successfully.   Query Builder is throwing errors on connection - I was able to create the connection in Query Builder one time ...

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

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 ...

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 ...

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 ...