Browse by Tags - InfoPath Dev
InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects.
All Tags » data connection » SQL query from InfoPath
Office365 Alert - Sandbox has been deprecated in SharePoint Online. Read more here.
Having trouble finding a blog or post that answers your question?
Check out our Custom Search Page
Browse by Tags
data connection connection
data connection file
data connection type
Datatabase normal form sql filter
Infopath data connection
infopath data connection sharepoint lists
Secondary Data Connection
Secondary data source
submit data to access database
Concat 2 SQL Columns in InfoPath Drop Down List Box
Hi, I am trying to query a single SQL Table and obtain the values FirstName and LastName (columns in the SQL Table). How would I go about concating FirstName and LastName inside the Drop Down List Box WITHOUT USING A REPEATING TABLE OR SHAREPOINT LIST AS A 'MIDDLE MAN' I believe this is achievable...
Re: How do i query a secondary SQL data connection.
Hi Steve I'm trying to do exactly the thing as you did but cannot figure out how to query my SQL database can you please tell me how you managed to connect to query your database? Thanks, Brenda
FIXED: Infopath 2007 crashes when trying to create new data connection to SQLSERVER view
When I try to connect Infopath to a sqlserver datasource , it crashes. This happens on multiple PCs, including my brand new desktop. This crash is repeatable, and Microsoft is notified with a crash report. The datasource is a view in a SQLServer database. I can connect MS-Excel to the exact same datasource...
InfoPath 2007 with Sql Server 2008
hiiiiii I am working on InfoPath Project, and i want connected it with sql server 2008 by wizard connection on InfoPath form, I choosed DB connection and table. when I click on review button and click on retrive Run query not return any data, also in submit command. and dislpay this ' InfoPath cannot...
Created main data connection in InfoPath form using SQL database using SQL credentials. Connects like a champ when I preview via InfoPath. However, the published form in Sharepoint will not connect. Doesn't even hit the SQL server and gives me a 6932 cross-domain error. Not crossing any domains,...
How to handle exception for Data Connection ?
Hi, Every time my InfoPath form is opened, I want to populate Dropdown box with SQL Data. I have webservice which collects data from SQL Server and returns back. In Infopath, I created new Data Connection and consuming this webservice to get data. I also checked "Automatically retrieve data when...
Running sql queries from info path
Greetings to all! I'm an SQL newborn and need to be treated tenderly :0) This is what I am trying to achieve...and I bet someone will reply with "You silly sausage, you need to do this....so simple :-)" I have an infopath form (expenses, not from the template, this is a from scratch form...
Page 1 of 1 (7 items)