>>
>>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?
>
Whoever put up the entry in the WinAPI section here did a solid job of documenting the call, including the all-important constants. I'm not the only API resource here by any stretch of the imagination.
>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.
Actually, there's an FFC class in VFP6 to handle the ini/registry entries without forcing you to go to the API on your own...
FWIW, I'm trying to put together an evening session on API topics - mostly dealing with translating typedefs into VFP things, and memory and pointer issues for structures when VFP strings just don't cut it. It'll be from the perspective of CLSHEAP rather than Christof Lange's STRUCT class. It'll be announced once I figure out what can be covered in 45 minutes in the Chat format.