Hi Andre,

have you setup a DSN with ODBC Manager?

Is the path $ORALCE_HOEM\BIN in your path variable?

Try to install MDAC 2.8

HTH

Volker

Hi community,

after 2 days of analyzing my server, I found out, that the harddisks are the bottleneck. Normal harddisk tests with dr. hardware or Sandra show a really good performance,...

Hi Rahul,

1. You can use Query Analyser to get the excecution plan of your whole proc.

2. Take SQL-Statements out of the proc and get execution plan in Query Analyser for...

OK, thanks for your help, if i have a solution I will inform you.

Maybe someone else has a solution.

Volker

Hi Andy,

thanks for fast reply, but isn't there a'n easier way to do this in DTS?

Volker

Hi Neil,

first thanks for prompt reply. On Monday I'm on customer site where the problems are. I will check MDAC and reinstall 2.6 RTM. But the parallism thing is not...

Hi Neil,

first I've installed MDAC 2.61..., does'nt work, then I've installed MDAC 2.7, same result.

Can you send me the link to MS DATA site, for downloading Component Checker?

Thanks

Volker