Registered: 1158198299 Posts: 5,507
Reply with quote
When setting the connection details for the e-work Engine using the e-work System Administrator, the OLEDB details entered into the registry are not correct. The Engine will not start, and no entry is etnered into the log.
The correct string, entered by the install, was:
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=ework;Password=****;Data Source=EWFPD;FetchSize=100;CacheType=Memory;PLSQLRSet=1
The invalid string entered by the Administrator was:
Provider=OraOLEDB.Oracle.1;Data Source=ewotr;User Id=ework;Password=****;FetchSize=100;CacheType=Memory;PLSQLRSet=1
The above strings obviously point to different databases, but when the first string is copied to the registry for the second server, and salient details are updated, the engine starts. __________________ Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.