I need to move the databases for our DBXL install to another server - originally it was installed on a development/test server and is working (great) with our production SharePoint server and InfoPath. But, the DBXL db's should be migrated to the production SharePoint SQL server as intended so that...

One way to integrate DBXL forms with SharePoint is by creating a Data View using SharePoint Designer. In minutes, you can have a custom view of all your forms and the links needed to work with them. To successfully complete this tutorial, you MUST have the following: A DBXL Document Type with SQL Mapping...

Hello! I have a SQL database/table. In the table there are many coloums, one of them called „TD_ID”. In the infopath form, there is a ”Field1” field (xpath code: my:Fields/my:Field1). In the form, I only need thoose records, where TD_ID=Field1. I can write the value of td_id manually in the code, but...

Is it possible to connect an InfoPath form to an access database to bring data into a form? I know this is possible with SQL but the data resides in MS Access currently.
Are there any alternatives to SQL like SQL Lite?
My purpose is to integrate Access data into and email template that which can...

Hi, I'm attempting to use the ExecuteSqlQuery command to fire a stored procedure against a SQL table. I have a column in the table called Entry_Deleted, which is a true/false column as opposed to just deleting the entry. When the procedure is executed, it changes the value to 1 for true according...

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

Hi! I have the following business requirement: We have an InfoPath form published to a SharePoint library, and when this form is submitted to the library (after going through an approval workflow), it needs to create a new record in a table in a backend database. the table at the backdend database has...

Here is my scenario: I have created a Timesheet form in Infopath 2010 that has a receive data connection to a SQL database, which I set up through DBXL. The SQL table my form is connected to contains a hierarchy for my company. In the form, I have a dropdown box that lists all of the Employee ID Numbers...

Alright, here is the skinny. I have two sql tables that I am pulling in for a read only data connection. I have setup a udc connection for both of these and they are working fine. What I am trying to do is write a value to a field from one dataconnection based on a condition from the second data connection...

Hi ! Im quite new to this thing and now i have some troubles. I hope someone here can help me or atleast point me in the right direction. I have a InfoPath 2010 document that i includes an area with static fields and one are that is a repeating area with 3 fields. This 3 fields i try to so save in arrays...