dsn confusion

[TofuBug24]

I'm not sure if i should have posted this in the asp.net forum or not but it's mostly a database sort of a question. I've been tasked at work to write a library that will parse a tab delimited text file and filter the data and stuff it into a normalized sql server database. basically the text file is a straight textdump from the clients main offices product database and the sql server database the info's being entered into is for their website to pull from for their online catalog. now to make my life easier i set up a dsn using microfts text/csv ODBC driver the actualy library is done and works beautifuly. my problem (and it might not even be a problem) is that i'm confused on how to distribute the dsn that loads the textfiles. basically i need to set the dsn to point to the "dump" folder on their website's server so that when they upload a new copy of the file the library knows where to find it to pull the information from right now the dsn is just a user one pointing to a logical disk file on my home computers desktop (i do alot of my testing at home) sorry if this is a little simple of a question i deal more with sql server and straight connection strings and for some reason the dsn thing just confusses the hell out of me thanks for the help guys and gals Ryan

[tuxyboy]

http://support.microsoft.com/kb/q165866/