SQL Database Integration

Re: Working with Infopath, SQL and Outlook.

wildguixe — Thu, 21 Feb 2008 15:17:58 GMT

Now the problem is the follow, i'm traying to "open" a sql database from infopath i mean "connect", and i can't.

I have to use the adoqueryadapter??? Any example??? (y looking for internet but i can't find something understable) or with a connectionstring is enough (this option is my actual work but a permission error is appears) ???

Anyone :) Thanks so much ...

Re: Working with Infopath, SQL and Outlook.

wildguixe — Wed, 20 Feb 2008 17:52:32 GMT

Great!! Problem fixed. I uninstall the application and reinstall. Also install all the services packs. Now i can keep working with the stored procedure!!! Any suggest welcome :)

Re: Working with Infopath, SQL and Outlook.

wildguixe — Wed, 20 Feb 2008 16:56:25 GMT

Ok, i installed the VSTASDKFebruary2007.exe but the problem persists... maybe if uninstall and reinstall this problem disappear....

Re: Working with Infopath, SQL and Outlook.

Clay Fox — Wed, 20 Feb 2008 16:44:56 GMT

You need the VSTA for 2007

VSTO 2005 will not work with 2007.

Re: Working with Infopath, SQL and Outlook.

wildguixe — Wed, 20 Feb 2008 13:40:28 GMT

Ohhhhh.. this message appear each time i click to put code into the button of infopath:
I have .Net 2005 and InfoPath 2007 installed. I downloaded the VSTO 2005. Going into a form and clicking programming interface it gives me error

InfoPath cannot add the event handler .

To work with Visual Basic or C# code, Microsoft Visual Studio Tools for Applications (VSTA) is required. The Microsft .Net Framework2.0 and Microsoft Core XML 6.0 must be installedprior to installing VSTA

When I go into VB I can see and use the Office 2005 add-ins. So why does it not work from using InfoPath????

i dont want abuse of you help, but if you can help me i really appreciate that :)

Re: Working with Infopath, SQL and Outlook.

wildguixe — Tue, 19 Feb 2008 15:28:02 GMT

Thanks Clay, i think i will try with the stored procedure. Infopath works with stored procedures, this is correct???

Re: Working with Infopath, SQL and Outlook.

Clay Fox — Mon, 18 Feb 2008 19:43:09 GMT

So you want the time in your database?

You could possibly set a default in SQL that would enter a time when the row was created if that works.

In InfoPath, if you are going to set the field yourself you can use substring-after(now(), "T") this should get just the time portion for you.

Re: Working with Infopath, SQL and Outlook.

wildguixe — Mon, 18 Feb 2008 18:31:09 GMT

Finally i can insert the image on the form. I don't know why but something i was doing wrong. Now is working great. Just lacking me fix the integration with the outlook, but is ok. I think... :)

Now i have other little (or not) problem: i have a client and a server. The application run on the client, but on determinate moment the application ask for the time and insert on the database.

I made it with the now funcion, but the now function works with the date of the client computer, i want to take the server time.
Stored procedures?? Or other solution perhaps???

Thanks again. :)

Re: Working with Infopath, SQL and Outlook.

wildguixe — Tue, 12 Feb 2008 14:52:01 GMT

Thanks, i already downloading odabra.

Keep in touch about any progress :) Thanks again.

Re: Working with Infopath, SQL and Outlook.

Clay Fox — Tue, 12 Feb 2008 14:32:30 GMT

Unfortunately, the built-in database connections in InfoPath have some limitations and large file types are one of them. You have to use Web Services to submit these types of fields.

You would need SQL or SQL Express for your database. Check out the Database Accelerator package. This includes all of the webservices you need in an installable package which you can be using without code in less than an hour.

Qdabra Database Accelerator Suite Version 2.1 - Developer

Re: Working with Infopath, SQL and Outlook.

wildguixe — Tue, 12 Feb 2008 14:15:10 GMT

Thanks Clay, i think that i will fix this problem soon, now i have other problem, i can't attach files to the form because this have to be relationed with a field on my database and i don't know how do it. I created a field on my database img varbinary(200)...

i try with the rich text box, and image, but a long message said to me that the action is forbidden.

What can i do??? Thanks a lot anyway for all the fast answers. :)

Re: Working with Infopath, SQL and Outlook.

Clay Fox — Mon, 11 Feb 2008 15:44:32 GMT

One thing to is that if you have it setup as a database form then the main submit should be used in addition to an email submit so that your data is being saved back to the database.

Re: Working with Infopath, SQL and Outlook.

Clay Fox — Mon, 11 Feb 2008 15:41:57 GMT

So you went through the publishing wizard and published the form to SharePoint?

Does everyone who uses the form have access to the site?

They should be able to access the site and the document library and open a new form.

This will verify they have the access they need.

The person who recieves the email should then be able to open the attachment.

Re: Working with Infopath, SQL and Outlook.

wildguixe — Mon, 11 Feb 2008 15:19:30 GMT

Yes, is probable that my problem was the publish.

Today i'm still trying. I was created a site on sharepoint. My idea is share the template there, i bought 3 books of infopath to fix this!! I hope found the solution fast.

I put the option "submit files... " on the tool menu to can send the file for email, but on the computer that receives the mail with the attachment, the mail can't be edited. I'm in loops!!!

Let's see what happens.

Re: Working with Infopath, SQL and Outlook.

Clay Fox — Thu, 07 Feb 2008 15:13:51 GMT

No Problema.

It looks like you have not published the form template.

You need a network share or webserver where you can publish the form that everyone has acess to. Or you can publish for email which means the template is included in the email.

All InfoPath created XML retain a link to the template so that they can render the data.

I would recommend a central location that everyone can access, both to start a new form and to be able to view a saved form.

Publish is in the file menu.