Hi Alex,

Great to meet you at WhilFest.

Looks like Sergey has been looking after you.

Can you tell me what versions of MSDE and SQLDMO.DLL you're running?

My files are
SQLDMO.dll 2000.80.382.0
SQLDMO.rll 2000.80.194.0

I'm not running MSDE (it's the SQL2K Developer edition), but SELECT @@VERSION returns

Microsoft SQL Server 2000 - 8.00.384 (Intel X86) May 23 2001 00:02:52 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

Cheers,

Andrew

>>Strange. It works for me on two different PC's. I'm running SQL 2000. 1429 is VFP error. What's OLE error code and message?
>
>By stopping as soon as error occurs and using AERROR() I get the following values in the array elements:
>1) 1429
>2) 80029c4a: error loading type library/DLL && I think this is the root of the problem
>3) [SQL-DMO]Code executionexception: EXECPTION_ACCESS_VIOLATION
>4) Microsoft.SQL-DMO
>5) SQLDMO.hlp
>6) 0
>7) 5
>
>Is this what you meant? Unfortunately I have to leave now. Thanks for your help.
>
>Alex
>
>>
>>>>Both of them work for me and I'm using VFP7SP1. oServers is collection so I don't know why FOR EACH gives an error. What's the value of oServers.Count on your PC?
>>>
>>>It has a value of 3. I was using VFP8 but tried it with VFP7 with the same problem. The error is 1429.
>>>
>>>>>It works in your machine? Interesting. In mine, FOR EACH fails, but if I replace it with FOR i=1 TO oServers.Count it works. From that it would seem that oServers is not a collection, which is needed for the FOR EACH, no?
>>>>>
>>>>>For the moment I am off the hook, but am curious why it worked in your machine.