Calvin,

You can create File DSN (using ODBC Manager), open it in any text editor and copy connection string into your program.

>I need to be able to convert some data that is using the Advantage Database propriety file structure. I have the Advantage ODBC driver but cannot seem to configure the sqlstringconnect command to open the files. The Advantage database is using free tables and is local. If anyone can point out to me how to do this I will be muchly appreciative. Thanks! By the way, I am able to open the data using remote view.