Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Connect to SQL Server without DSN

c_isco-ps
Level 2
Level 2

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

4 Replies
Not applicable

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
Level 2
Level 2

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?

Not applicable

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
Level 2
Level 2

Ok thanks, I'll check into those options.