Iam sorry that I can´t answer your question about the Active-X-Stuff and I truely doubt, that you will look in this thread again. But Iam interested in your solution for automated build of an DSN. Is it within the PDF-File, so not every user wanting the the PDF to be filled have to settle up an extra connection? And does it work, if the user has no permission to make a DSN on his own?
Hope, someone can reply
From an Acrobat/Form perspective you cannot dynamically create a DSN. This would be a huge security hole. I do not know if you can automate the creation of the DSN from other Windows technologies but definately not from within the form.