SQL User Mgmt broken! 1

[Clundey]

I can no longer add, edit or delete users via Visual Menu Builder to SQL 2000. Been getting "Error during removelogin, automation error, library not registered" when deleting. "Setting Database rights failed 0" when modifying, and "Adduser-1 username: password: Add to sql failed" when adding.
I've reinstalled macola client, Renamed Vmenu32.exe, Reregistered vba6.dll and apc62.dll. Tried connecting as sa.

I'm running XP SP2, and am thinking it's the SP. BTW, This still works ok on W2K citrix client.

Thanks in advance for any ideas.

Chris

 

[abaldwin]

Have you re-installed the SQL client?

Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[dgillz]

To use any of the visual tools, the full sql client must be installed including enterprise manager and query analyzer.

Also your version of Progression would be nice to know.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[Clundey]

Re-installing the sql client tools took care of the problem.

Thanks abaldwin!