Thanks Sergey for the response. Now the Report Manager I am using (from Sourceforge.net) required a Named DSN in the report, is it possible I can give any name when I create the report and when I run your code I give it the name that is stored in the report. Also without a connection established I may or maynot be able to put in fields, haven't done it yet, try it out tonight.
>>Sorry didn't read you're reply properly. What is DSN-Less connection and how can I proceed with it? Any pros and cons?
>>
>You create connection string in your program, for example
lcConnStr = "DRIVER=Microsoft Visual FoxPro Driver;" + ;
> "SourceType=DBC;" + ;
> "SourceDB=C:\Program Files\Microsoft Visual FoxPro 7\Samples\Data\testdata.dbc"
>lnConn = SQLSTRINGCONNECT(lcConnStr )
Pros: You don't have to create DSN's on user PC's.
>Cons: The connection parameters are stored in your application. So it's better to store themv in some kind of configuration file.