Linked server(Attunity)

[Optimdev]

Deleted for other purposes

[DrorHarari]

For Optim related issues you should consult with the Optim support.

Note that when running under a SQL Server linked server, the default SQL Server configuration prevents the code from accessing local resources - for example files. This may have something to do with your problem. Still, you should contact Optim support for an authorative answer.

/d

[Optimdev]

Deleted for other purposes

[DrorHarari]

(should really be in a new topic...)

>> ...except is returning some rows as difference but when we do a manual
>> comparision i found that reality that there is no diiference in the data...

What do you mean 'manual comparison'? Are you looking at a printout? Do you print each column with its length and trimmed length? Detail please.

>> ...I believe attunity is adding some special characters (such as space etc )
>> and this is causing the except query to return these differences...

Attunity Connect does not add special characters. Different in spaces can be seen with checking the length of the columns. Try to reduce the number of columns you compare to be different to the minimum and then filter the rows to a single line that shows a difference, then study the values of the remaining columns, including their length and trimmed length. Note that different binding using different APIs may yield different handling of trailing spaces. Try to use the same API in both cases (e.g., try to get to Oracle also via ODBC).

[Optimdev]

Deleted for other purposes

[Optimdev]

Deleted for other purposes

[DrorHarari]

I have noticed the Attunity OLEDB Provider and query processor for heterogeneous databases.Can i use this instead of ODBC for accessing the attunity data?

Yes, you can use the Attunity OLEDB provider for a SQL Serveer linked server.

[Optimdev]

If posibnle please let me know the config steps for creating one...i was not able to figure out.
Thanks.

[Optimdev]

Deleted for other purposes

[DrorHarari]

For linked server using the AttunityConnect OLEDB provider, you need to specify a valid connection string according to the Attunity Connect manual. The Attunity OLEDB provider has nothing to do with ODBC DSNs.