Hi to all,
we have some problem with the ODBC Data Direct (i suppose).
Our Job Server is on Unix and our Target DB is Microsoft SQL Server 2008 on a Windows machine.
We have installed ODBC Data Direct 5.3 to talk with the SQL Server 2008 and we have the necessity to take data from a SQL Server 2000.
The collation of SQL Server 2000 is Latin1_General_CI_AS, we have configure the SQL Server 2008 with SQL_Latin1_General_CP850_CI_AI.
When we start a simple job to transfer some data to SQL Server 2008 we have a syntax error, there is a special character in one record ( i think it’s a carriage return) and the job fail with an error.
Why?
The collations of the two database it’s the same, i think that the problem is in the ODBC Data Direct that can not translate that special character…
There is any option to configure the collation for ODBC?
P.S.
All the Datastore are configured with ODBC type
Thank you for your answers
GioBOBJ (BOB member since 2011-07-01)