DSXchange

reinstalling the sybase open client worked. Thanks all for your tips.

What precisely do you mean by this? "but after moving to the new server we are getting this" First mention of a new server / server move, so now I'm curious exactly how all this was "moved". ... Craig, New server means, everything is installed new on the NEW server, but only the...

arunpramanik wrote:Check with DSEDIT utility, if you can access the sybase servers.
DSEDIT utility is available at Programs>Sybase

I opened dsedit.exe and i click on the server name in the left pane. It is showing details of it in the right pane. Ho can i test the access? I am using this first time.

arunpramanik wrote: My suggestion is to install Sybase Client in DS server.

We have installed sybase clinet on DS server. It worked before, but after moving to the new server , we are getting this ds_loadlibrary error.

Any Windows users who faced this situation before?

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 als...

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 m...

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 environ...

[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.
***************************************************************

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?

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.

Take the substring created from your first index and do an index on this to look for the double quote Can you please be more clear on this? i have first position using index(DSLink12.NAME,"EMP_FI",1), then the whole name is like "EMP_FIRSTNAME=LATHEEF SYED" . I didn't get, what ...

Hello Sai.....I already used the index for finding the start position for three names index(DSLink12.NAME,"EMP_FI",1), index(DSLink12.NAME,"EMP_LA",1), index(DSLink12.NAME,"EMP_FU",1). But the problem is with the end position. How can i get the index for the end positi...

Since the comma in the full name is inside the quotes and would be part of that string, would it still be considered the same as a non-quoted comma, i.e. field delimiter? :? "EMP_FULLNAME=HUSSAINY, LATHEEF SYED" I already tried to use double code as field delimiter, but Datastage is not a...

Hello Sai.....I already used the index for finding the start position for three names index(DSLink12.NAME,"EMP_FI",1), index(DSLink12.NAME,"EMP_LA",1), index(DSLink12.NAME,"EMP_FU",1). But the problem is with the end position. How can i get the index for the end positio...