We are facing some issues with build-in data direct drivers for Microsoft SQl server in our Linux server. Due to this we have installed 'Microsoft ODBC Driver 11 for SQL Server on Linux' in our linux servers. I have added this driver file in odbc.ini file in $DSENV, but when I am trying to test connection it is failing with error message as 'Unicode converter buffer overflow'.
Can we use external drivers(other than Data Direct) in Datastage? Do we have to restart DSEngine if we have modified(added linux driver path) LDS_LIBRARY_PATH ?
Below is the sample odbc file :
Code: Select all
[DBNAME_UNixDriver]
Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
Description=Microsoft ODBC Driver 11 for SQL Server
Database=DBNAME
LogonID=uid
Password=pwd
Address=ServerName
QuotedId=No
AnsiNPW=No
---Tried with default sample of microsofrt drivers
[DSNname]
Driver=SQL Server Native Client 11.0
Description=My Sample ODBC Database Connection
Trace=Yes
Server=[server address]
Port=1433
Database=NSCDB_3
http://msdn.microsoft.com/en-us/library ... .110).aspx
Thanks in Advance!!