CRS DB Write SQL Error log

[tgledbetter]

Does anyone know where I can find the detail logs behind a SQL Error? Using CRS 4.0.5.

Thanks in advance.

[amaia.lesta]

Yes, I assume that maybe a complex query can get an error.

But why a successful successful query gets an error when changing a fix value for a variable?

Best regards,

Amaia

[amaia.lesta]

Hi,

Ir was a matter of query sintaxis. Now it works as this:

SELECT * FROM OPENQUERY( LaguntelDEV, 'select distinct hzp.attribute2 from AR.hz_contact_points tel, AR.hz_parties hzp where tel.phone_number = ''@ANI'' ')

Now the problem is in the GET step. I don't know how to create a System DSN resource that points to the linked server in order to define it as a Dtabase in the CRS adminsitration webpage. Any idea?

Thanks

Amaia