InfoPath Dev

I was hoping that I could access SQL Server data to populate dropdown boxes and text boxes using the native .net provider, as opposed to using a DSN or Web Service, but it doesnt appear that I can use traditional web/winform binding methods to Infopath controls.

Does this limit my binding options to just DSN, XML files, or Web Services?

What do you mean by "traditional web/winform binding methods to InfoPath controls"? You can call SQL via code (.NET) and populate dropdown boxes directly. You will need to load the resulting dataset into an XML DOM. That's not terribly difficult but it requires some time.

Patrick:

Thanks for your reply.

By traditional, I mean using the DataBind method on a control that exposes a bindable interface... I've extended the MS Data Access blocks, and most of the methods return a DataSet or a DataReader. Using something like: somecontrol.DataBind() throws errors.

I've gone the WebService route, though, so this should be a suitable workaround...

Good idea! We use Web services a lot for this kind of thing.