Connect to SQL Server without DSN

[c_isco-ps]

I apologize ahead of time if this is posted in the wrong area. If so, please let me know where the right place is. I am new to Live Cycle ES2 and am currently using version 9. I'm attempting to create a form that allows users to enter data directly into the form and submit it back to SQL Server 2008. Is using ODBC and a DSN the only way to handle this?

Thanks ahead of time

[Former Community Member]

You can also submit to an ASP.net script, and save the results to file, e-mail or database.

Or populate a form with data from a SQL database and send the merged PDF to browser window.

For more information:

http://www.nk-inc.com/

http://www.fdftoolkit.net/

http://www.pdfemail.net

[c_isco-ps]

Thanks so much for the suggestion as I may go that route. However I'm still curious to find out if using ODBC and setting up a DSN is an absoulute must? Of course I've hooked the form up via a DSN and it worked just fine. Any thoughts on the ODBC/DSN situation?

[Former Community Member]

Not sure if DSN-less ADBC connections are possible...

I couldn't find much on Google..

Here's a link to planetPDF, where someone has failed to attempt to create a DSN-less ADBC connection:

http://www.planetpdf.com/forumarchive/102611.asp

http://www.planetpdf.com/forumarchive/102903.asp

Here's a link to a coldfusion DSN-less connection if this helps:

http://jarrettbroder.blogspot.com/2009/07/dsn-less-database-connection-to-mysql.html

[c_isco-ps]

Ok thanks, I'll check into those options.