Permission error in DBEngine.CreateWorkspace

[YYKK]

I got a strange problem when compiled an existing VB6 project. I can compile it without any error before but now I got "Compiler error : Permission denied." in "DBEngine.CreateWorkspace".

I used MDAC Checker and found a lot of Dll "file not found". I search the WINNT folder and they're all in "c:\WINNT\ServiceParckFiles\i386".

Who can help me on this issue? I need to re-install some customers' PC today and it's quite urgent.

Thanks a lot in advance,
YYKK

 

[CCLINT]

Are you using an english OS version? If not, then you will get this with the component checker.

You are using DAO. Do you need to explicitly create the Workspace, instead of using the default for some reason?

 

[YYKK]

This isn't my program and I'm supporting it now. It uses following:

Set ws = DBEngine.CreateWorkspace("EPR", _
Chr(34) & Trim$(UCase(sUserLogName)) & Chr(34), _
Chr(34) & Trim$(sPassword) & Chr(34), dbUseODBC)
Set db = ws.OpenDatabase("EPR_ADO&quot

sUserLogName - Oracle schema
sPassword - Oracle password
EPR_ADO - ODBC name in system tab

Please let me know if you need more information.

Thanks a lot for your reply,
YYKK

 

[YYKK]

CCLINT,

Forgot to tell you that I'm in English OS version. I thought MDAC Checker can check if there is a problem in MDAC part.

Thanks,
YYKK