Hi
I wrote a small script which reads data from a website and stores them in an oracle database. When I start this script from djuggler all is fine and it works.
When I compile it and want to start the exe file I get the following error:

Error in script line 1:
Could not connect to SQL Server.

Error: Unable to load dbxora.dll (ErrorCode 126). It may be missing from system path.

Stop execution?

As the script runs from Djuggler I would say that it cant be a problem with the system path.

is this a bug in Djuggler?

In the Djuggler program folder file, there are a few database dll's. For oracle you need the dbxora.dll.

When creating a compiled script with database connections, you need to copy the database dll next to your compiled Djuggler script.

DS

Thanks it works

Hi

with the new version Djuggler changed a bid how it handles these dll files.
To avoid having this dll next to each djuggler executable i used the regsvr32 command to register the dll in the registry.

With the new version this doenst work anymore and I have to copy the dll to each folder where I use Djuggler exe.

Is this a side effect of something or a "feature"?

The new version has new dll's. I think you have unregister the old version and then register the new dll when using your construction. We always advise to keep the dll next to the compiled script.

The good news: we are working on version 4 of Djuggler that won't have database dll's anymore.
DS

Yes,

I recognized already that the new ones work with a new dll file. luckily old scripts also work with the new dll file.

I also copyed the dll to only one folder and put this to the PATH. This way I dont have problems with the dll registry and all scripts can find the dll without copying it to each folder.

thanks for your fast response