DSXchange

Hi,

Does DS 7.5X2 support SQL server 2005 64 bit?

Thanks,
Venkat

could you please give the SQL statement used in that stage?

Hi, We have DS application running fine in the 32-Bit Datastage and 32-bit Database servers. Now we want to change 32-bit DB server to 64-bit server. But Datastage server remains the same. Application uses MS OLEDB stage to connect to SQL server. Now my question is: Will MS OLEDB stage support 64-bi...

chulett wrote:First thing to try - edit the .dsx file and change everywhere it says Readonly "1" to Readonly "0" and reimport it. ...

Thanks Chulett. Now I am able to modify the code.

Thanks once again.

Venkat

Hi,

The .dsx code that is taken from protected environment has been installed in the development system, but now the code does not allow to modify as it is read only.

Is there any possible to make the code in a such way i can modify for development?

Regards,
Venkat

Hi,

Thanks Guys for your support.

This problem got resolved after applied microsoft patch mentioned in this URL - http://support.microsoft.com/kb/942861

Thanks,
Venkat

Hi all, thanks for your valuable response and support. this problem got resolved. Due to some incorrect settings in the DB config, this issue happened. After corrected the config file, this problem is gone. In the DB config, the "set working set size" was set to 1. This should be set to 1,...

They do have a per-cpu with no concurrent limit licensing option, but in this case they probably do not have that license. [url=http://www.microsoft.com/sqlserver/2005/en/us/licensing.aspx]SQL Serv ... Hi ArndW, We have a license on SQL server 2000 Developer edition. There seems no limit on concurr...

Is there a limit on the number of simultaneous connections to the database server? For example Oracle is limited by the number of listeners that have been configured. ... Hi Ray, Thanks for your response. But there is no limitation on simultaneous connections on SQL server. Is there any limitations...

Thanks Craig.
Each time it fails at different links and looks like consistent, only 10% is finishing successfully. But anyway i will check with DBA to find out any resource issue happens.

Regards,

chulett wrote:If which ones fail change run over run, then I'd say you have a resource issue and the instance/server/whatever can't support that many simultaneous connections. ...

Hi Craig,

I could not get your point. could you please expand it?

Regards

Hi, I post this after seached the word "Failed to establish datasource connection" in this forum. In all the forums, it has been mentioned that "Failed to establish datasource connection" might be happened due to connection string or userid or password or DB or server name wrong....

chulett wrote: Please don't start multiple posts on the same subject. Why not stick with your original post on the problem?

viewtopic.php?p=335270

Sorry Chulet. I thought the previous one does not give clear idea on problem.

Hi, I have one lookup having one OLEDB stage and one Hash file stage. the function of this job is just extract the data from SQL database and create the hash file with the data. The job is connecting and reading the data. After few minutes, the job aborts by itself, throwing the below error at any o...

dsjob -run -wait myproj myjob
Waiting for job...
Finished waiting for job
Status code = 0
> echo $?
0

This says waiting finished successfully. that is why status code shows 0.
Is it necessary to give wait here.

Venkat