How do I get InfoPath working with SQL Server (Acces works nice)

[JimJ]

I can get InfoPath working excellently with the example/guide titled
"How-to guide: Connecting an InfoPath form to an Access database"
at this website link:
http://office.microsoft.com/en-us/infopath/HA011199501033.aspx?pid=CH011097411033

But I can't get the same thing working with SQL Server even when I make the
tables with identity prpperties, keys, and unique indexes.

 

[Sundar Narasiman]

Pls check the following article
http://aspalliance.com/1106_Saving_InfoPath_Forms_to_SQL_Server_2005_as_XML.4