>>>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.
>>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!
>
>It's the same API call - you just call SQLConfigDataSource() a second time when you're done, using the constant ODBC_REMOVE_DSN instead of ODBC_ADD_DSN
>
>It's not a kludge at all; it's the same function used by the ODBC Administrator applet to do the same things. You can create and destroy System DSNs with the same API call, just change the ODBC_ADD_DSN to ODBC_ADD_SYS_DSN and ODBC_REMOVE_DSN to ODBC_REMOVE_SYS_DSN

Thanks, Ed ... it's always nice to have you weigh in on the API issues, if only to show that we're going in the right direction! By the way, is there a .H file which resolves these types of constants? If not, what (free) reference should I use to find them?

When I said it was a kludge, I wasn't referring to the API call. I meant that it sure seems like you ought to be able to SQLCONNECT() directly against the File DSN rather than resorting to API calls.
zahid