Some references (including one on deleting the created DSN):
MSKB #
Q142216MSKB #
195262zahid
>Mark -
>
>Not having used a file DSN, I don't know the "right" way to do this ... however, if you can't determine the "right" way, you can read the file using your favorite text-parsing tool (such as ALINES) and then use the API call SQLConfigDataSource (documented in the UT API section) to create a User DSN which is a clone of the File DSN.
>
>The main drawback of this approach (besides that it's a kludge!) is that I can't tell you how to delete the User DSN you created. However, I imagine there is an API call for that too.
>
>If you find a better way, let me know; if not, let me know how this worked for you!
>zahid
>
>>How do you connect to a file data source using SPT?
>>
>>SQLConnect('xyz') works fine with User and/or System DSN but not File DSN.