Nothing is impossible, sometimes highly unlikely, other times very convoluted, but never impossible.

We also have Progress on Unix and SQL Server on Windows. We have an ODBC connection to the...

You could start by setting up a few traces. Take a look at "Monitoring with SQL Profiler" in Books Online.

Also, if you setup the the trace to run on...

Just to add steven_white40's reply, if you setup a scheduled task, make sure you disable, or remove, the schedule.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface...

We probably could but the Progress Server doesn't use security, and we don't have control over it either.

We have to manage a read-only connection from our end.

Hope this helps

Phill Carter

--------------------

Colt...

To have Progress access SQL Server databases, I believe you need to run the MS SQL Server Dataserver on the Progress Server.

If you have a stable ODBC connection to the...

Ok, I did misunderstand

Based on what you have now, I'd add another global variable (maybe glbv_Counter) to act as a counter for your position in the...

Take a look at the following,

http://www.sqlservercentral.com/columnists/bknight/xpfileexist.asp

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Maybe I'm a bit confused, but does the second ActiveX script run before the Datapump task? If so, then you probably just need a third ActiveX script after the Datapump...

Nice little script.

We have something similiar, only the date & time are appended to the filename so the logs don't get overwritten. They also get an extension of .txt which...

You could also do

quote:

---

SELECT sObj.name

FROM dbo.sysobjects sObj

INNER JOIN dbo.syscomments sComm

ON sObj.id = sComm.id

WHERE sComm.text LIKE '%tblServerlist%'

AND sObj.type = 'P'

---

August 31, 2003 at 5:47 pm