Recent content by Veng-Ly Tong

I have a SQL Server 2K database that needs to link to Syteline data running on Progress 9.1C. So far, I've been unsuccessful and I get an error message like: "Error 7399: OLE DB provider 'MSDASQL' reported an error. Could not find data source and no default driver specified." I'm new...

Thanks for your reply, Mike. The TOP-N function is also found in MS Access, Oracle, and mySQL so it's a somewhat common functionality across a number of databases, although it may be called different function names. I'll look into your link. Whatever the case, if you wanted to only retrieve...

Does anyone know of the Progress SQL equivalent of the TOP keyword in SQL Server? Specifically, I'm trying to make a similar query to just get the first N records: select top 10 <fieldname> from <tablename> Thanks.