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.