I have ORacle 10.2.0.5 on SLES10 64Bit. And I want to connect mssql server on internet using oracle dblink. To do this, I installed freetds (intalled path is /usr/local/freetds/) and I configure setting like below. I tried to connect using isql (isq ZAFER 'userName' 'password') and I can select count from table. But When I want to select from mssql table with oracle dblink on oracle, I have this error :
+/usr/local/freetds/lib/libtdsodbc.so: wrong ELF class: ELFCLASS64+ Could not find symbol 'SQLAllocConnect' in dynamic library" Failed to load dynamic library '/usr/local/freetds/lib/libtdsodbc.so'
my /etc/unixODBC/odbc.ini file
+[ZAFER]+ Driver = TDS Description = Microsoft SQL Server Server = 10.0.34.47 Database = SQLDBNAME Port = 1433 TDS_Version = 8.0