Thanks Sergey. I guess I'll ask Toni if his work will accept a Nameless connection. Have you tried this Report Manager, now it's into production rel. 1.1 downloading the latest at the moment. It has sub-reports.
>No, it wouldn't work because you cannot assign name to the DSN-less connection.
>
>>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.