My linked servers are not SQL Servers, but a Progress database. In my DTS programs, the first step is to issue a basic statement

select * from openquery(linkedserver, 'select count(*)...

Well my dts jobs all of the sudden are running fine since the source server (a Progress database server) was rebooted a couple of days ago. It hadn't been rebooted...

Do you do this on the linked server or the sql server from which you are running the query?

Unfortunately, I think the only solution is to restart the SQL Service. I'm struggling with this problem as well. The following link shows a disscussion about this. Apprently, it's a...

I've had problems with that too, as well as with sql agent jobs hanging. Make sure you apply the latest hotfix (build 2187) to sp4 which appears to be the...

I have the same question. My guess is you don't have control of this and that you would have to create code that uses a windows form and a report...

Thanks! That does it.

Is the IBM iSeries Access for Windows downloadable from the Internet somewhere? thanks.

THe problem still happens even though Excel is now installed successfully. It must be security.

I can successfully manually run the DTS package while logged into the server as myself...

I was wrong. Excel was installed on the served, but with an error. If you try to start it manually, it returns an error. I will get that resolved and...

I'm having the same problem. I've tried all suggestions (cast as varchar(100)and recreating the linked server. Any further suggestions? thanks.

This example ActiveX task VBscript does a check of the database using OPENQUERY. Note that it requires an ODBC DSN defined having the same name for each Progress database. This...

Thanks much for the script, especially your version. I could easily do a TSQL WHILE loop to have it create each file. However, my main concern is to format the excel files...

We do use the Merant 3.7 driver. The "Read Uncommitted" is checked. However, it's useful to know that does indeed make a difference. I always selected it just in case.

I changed the...

Thanks for the tips. I'll try them.

One work around seems to be to not use SELECT *, but rather SELECT field1, field3, etc. For testing, I used * because the test...