OK I'm still hung up on this...

An ADO recordset is opened from VBScript with a SQL query through ODBC to a Progress database. One of the fields contains only...

Thanks Don,

So this is really a VBScript issue not SQL server?? That would explain why it works in the DTS pump environment.

Thanks again

Thanks everyone once again! I made sure the debugger was installed and made the following registry tweek:

[HKEY_CURRENT_USER\Software\Microsoft\Windows Script\Settings]

"JITDebug"=dword:00000001

To deactivate just-in-time debugging, run a *.reg file with the following

lines:

...

Thanks for your incredibly helpful reply!

One question: Can I instal the NT 4 Option pack on my 2000 Pro box?

Thanks again!

Finally had time to get back to it!

Thanks all for your help. SET ROWCOUNT is working perfectly and I now understand why TOP is different. SQL Server Central is...

Greg,

What's different about passing in @Top as opposed to the other three parameters that would require dynamic SQL?

This sp is being called from an Access event procedure where the user...

Thanks ianscarlett and simonsabin! After much frustration I am ready to fully accept Simon's position. It ain't gonna happen with a variable!

Jonathan

Thanks both Antares and dj_meier. Antares, I see your point and have incorporated it. Mr. Meier, I did try your suggestion but the results were no different than...

I spoke to microsoft. They had me download MDAC 2.5. The server had 2.1. This solved the problem!

Thanks for your input I do appreciate it!!!

Jonathan

Well I "bit the bullet" and did the install.

It did not require a reboot but it did stop SQLSever Agent and it did kick users out!@

Thanks for your reply

Allen,

Sorry about the delay. Well you are correct of course. I had not noticed that the time for this DTS package had grown to the point it was...

Now that the dust has settled and calmness prevails...

I now realize that all of my trouble stemmed from impatience (maybe justified). Once I had succsefully restored the complete backup,...

I waited a bit longer and was able to get to the restore database screen. I tried to apply the first tran. log after the backup but got message...

OK I found the problem and it was made way back at simply using ADO rstSQL.RecordCount.

I had originally rstSQL.Open cmdSQL.Execute

which makes no sense at all.

The code below is what should...

Thanks to all that responded. I have been banding my head against trying to use rstSQL.RecordCount. No matter what I do it returns -1.

So I am trying the cnnSQL.Execute,...