InfoPath Dev

Is it possible to access the form library columns within an Infopath form VB code. In my case this library column field that is not created from the infopath form itself; it is actually populated with a spreadsheet view.

I've done more research and believe that I can get to the info I want with the GetListItems method, however, I am not having luck using the GetListItems method. When I execute the method
I get this error:
Exception of type:
Microsoft.Sharepoint.SoapServer.SoapServerException
Detail: SQL Server Error
The SQL Server might not be started
0x81020024
The Sharepoint site is up and I have been successful in running other methods but this one fails.

Any suggestions?

Well forget about the web services, I found a rather simple way to do this. In Infopath simply create data connection back to the Main document on the Forms menu. The new connection will point to the Main connection as a secondary connection and make all the Form Library Columns available to Infopath. Now I can access it as necessary.

Hi Andy,
Sorry about the delay in answering your post. There are numerous ways to get the list of items. The easiest is to use the SharePoint list adapter which is a type of a data connection. SharePoint also exposes a bunch of protocols for accessing data. We use WebDAV for a lot of our solutions. Chapter 9 of my book discusses this and how to do other stuff. The SharePoint SDK will show you how to use other protocols (like HTTP) to get information. If you haven't read the SharePoint SDK documents, I highly recommend it.
Good luck

Patrick Halstead [InfoPath MVP]
InfoPathDev