getting ds_loadlibrary: Win32 error in LoadLibrary of sybase

kirankota79 · Post by **kirankota79** » Wed Aug 18, 2010 3:20 pm

Can someone please let me know the reason i am getting this error? I am very new sybase. I have sybase clinet on the server and able to connect the sybase database using SYBASE CENTRAL. I checked the paths and seems to be OK.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 18, 2010 6:06 pm

Did you check the paths for the user whose ID is used to run the jobs?

kirankota79 · Post by **kirankota79** » Wed Aug 18, 2010 6:35 pm

ray.wurlod wrote:Did you check the paths for the user whose ID is used to run the jobs? ...

Ray, I checked the path, lib and all SYBASE variables, it seems everything fine and i dont know where is the problem is. Can you please be more specific which path you are saying?

chulett · Post by **chulett** » Wed Aug 18, 2010 7:01 pm

Could you post the actual full unedited error from your log, please?

kirankota79 · Post by **kirankota79** » Wed Aug 18, 2010 7:28 pm

[quote="chulett"]Could you post the actual full unedited error from your log, please? ...[/
ds_loadlibrary: Win32 error in LoadLibrary of sybaseoc.dll - The specified module could not be found.
***************************************************************

chulett · Post by **chulett** » Wed Aug 18, 2010 8:36 pm

Just asked for the actual error, not the whole dang log.

ds_loadlibrary: Win32 error in LoadLibrary of sybaseoc.dll - The specified module could not be found.

So, where exactly does this dll live on your server?

kirankota79 · Post by **kirankota79** » Wed Aug 18, 2010 9:40 pm

chulett wrote: ds_loadlibrary: Win32 error in LoadLibrary of sybaseoc.dll - The specified module could not be found.

So, where exactly does this dll live on your server?

Craig, sybaseoc.dll is in the folder D:\Ascential\DataStage\Engine\bin. But i also copied it to other sybase dll folders referred in the environment variables like D:\sybase\DataAccess\OLEDB\dll, D:\sybase\DataAccess\ODBC\dll to see if that helps, but still i was getting the same error.

chulett · Post by **chulett** » Wed Aug 18, 2010 10:56 pm

I don't believe you can simply move dll files around on Windows, as far as I know they need to be 'registered' in a specific location to work properly. I don't know what environment variable on a Windows server would control access to that plus it seems odd to me that you found it in the Engine's bin directory rather than any of the Sybase ones.

Hopefully someone who has dealt with this before on Windows will come along and help, my small amount of Sybase experience was years ago and on UNIX, I'm afraid.

arunpramanik · Post by **arunpramanik** » Thu Aug 19, 2010 2:01 am

Very recently we installed DS on Windows, (although we have sybase client installed in DS server), and I am quite sure that we did not have to register specific dll, as what is being mentioned.

Is the installation is made recently? Was the server restarted after installation?

chulett · Post by **chulett** » Thu Aug 19, 2010 5:21 am

Never said you had to register anything manually, that's all automatic - I specifically said that (AFAIK) you cannot simply move Dynamic Link Library (ddl) files around wherever you like due to the fact that they are registered in a specific location.

kirankota79 · Post by **kirankota79** » Thu Aug 19, 2010 5:51 am

arunpramanik wrote:Very recently we installed DS on Windows, (although we have sybase client installed in DS server), and I am quite sure that we did not have to register specific dll, as what is being mentioned.

Is the installation is made recently? Was the server restarted after installation?

The installation was made some months back. But ihave restarted the server yesterday, but no use. Can you please suggest ?

kirankota79 · Post by **kirankota79** » Thu Aug 19, 2010 6:55 am

chulett wrote:I don't believe you can simply move dll files around on Windows, as far as I know they need to be 'registered' in a specific location to work properly. I don't know what environment variable on a Wind ...

Craig, but the main location is not changed which is D:\Ascential\DataStage\Engine\bin and also in the path. This should be the registered one rite, for any datastage installation?

chulett · Post by **chulett** » Thu Aug 19, 2010 7:38 am

No clue, not having worked with DataStage on Windows. What does your official support provider have to say on the subject?

kirankota79 · Post by **kirankota79** » Thu Aug 19, 2010 7:51 am

Any Windows users who faced this situation before?

arunpramanik · Post by **arunpramanik** » Thu Aug 19, 2010 8:26 am

Please check with support if Sybase client installtion is needed.
My suggestion is to install Sybase Client in DS server.