glad to hear it!

how are you trying to do the import and what error messages are coming up?

Its all in the interface with these things, and as far as I know, you have to use MS Host integration server to talk to as/400 boxes. Mind you, someone...

Hummm.

First port of call is your procedure syntax (not part of the problem) - I assume you've run this proc and it works via Query Analyser? Just don't see where...

off the top of my head, you might get some issues with authentication - w2k uses 'windows authentication' and NTLM.

You really need to check out the MS Knowledge base on...

If I read this right, you're planning to upgrade your OS from NT4 to W2k but leave SQL 6.5 on?

http://www.microsoft.com/technet/prodtechnol/sql/70/evaluate/sql7faq.mspx

is a good start. Have to admit sticking with SQL...

partly fixed - missing 'out' in statement!

however, keep getting '0x80042725' error from this sp...

EXEC @fsof = sp_OAmethod @fso, 'openTextFile'/*, @fso_return out*/,  @strfilepathname,2

which I...

well, yes, but it doesn't actually get me to the root of the problem - why would I get a NULL return from a request to create a fso and...

well, yes, but it doesn't actually get me to the root of the problem - why would I get a NULL return from a request to create a fso and...

wow! shows how easy it really is, given a little time to do it.

I've checked out the acrobat specs doc, and from that there's plenty of potential for a lot...

that was about the second thing I did, but it flatly refused to go anywhere.

I've since managed to access the db via sql 2000 ent man and all is...

ah - solved it.

to connect, I've used (servername)\(instancename) rather than just the server, as you'd normally do.

Still only wants to accept the sa login, but I can live with that...

would do if I could find the SNU....

I've assumed its somewhere in the sp3a stuff for 2000, so I'll run the upgrade first.

managed that, and can now login to osql via -U -P

BUT entman still getting access denied 

Thanks for this, Phill. Reinstalling sp4 seems to have done the trick