-
Hi Adam, is your site in the IE Local Intranet zone?
-
Hi again Adam,
Strange: it seems like the installer had permissions to set up the SQL portion of DBXL, but now, when you run it, it lacks the permissions. That's just a guess; perhaps there is more info in the Event Viewer?
Since this is XP, you should also check that ASPNET has permissions on the SQL database. If it doesn't, add the ...
-
On the machine where DBXL is being installed, there's an Administrator group. That's the BUILTIN\Administrators that gets used by DBXL. So if you're an administrator on the machine, then you'll be a DBXL administrator by default.
Because the databases are getting created, it seems the SQL part of the installation completes ...
-
Does the form have code?
Can you compare the InfoPath versions in the machines?
-
I would be interested to read about any solution you reach. I believe SharePoint and InfoPath simply store dates in different formats. Perhaps you could make some of these date/time fields text strings?
-
Hi Adam,
The installer needs permissions to create two SQL databases. You can use SQL Server Management Studio to see whether the installer was succesful in creating these. Can you check? Perhaps there is a permissions issue.
Also, during the installation, does the TEST CONNECTION button indicate Success?
-
Once you submit, the data is stored in a SharePoint form library. Then you click on the link, it opens the form again (with the data) and you can edit it. Is that the scenario you envision?
-
Did you admin-deploy the form?
I'm curious to know what steps you took to deploy the form to SharePoint, since code requires an extra bit of effort. Can you tell us?
-
I've done this using DBXL, but the technique will be similar without DBXL.
http://www.infopathdev.com/blogs/ernesto/archive/2008/08/20/how-to-add-documents-to-another-document-type-inline.aspx
-
In your win32 machine, what version of Office do you have? We've seen this error with SP1. Please upgrade to SP2.
PS: The SaveToSharepoint command won't usually work in preview. The form needs to be opened from SharePoint in order to have permissions to write (the attachment) back into SharePoint. Previewing from your local machine ...