Oracle DBlink mysql sqlserver

Oracle DBlink mysql sqlserver problem oracle connected to sqlserver using unixodbc + freetds + DBlink problem freetds no libtdsodbc after installation. so reason: SQL. h cannot be found because when unixODBC is installed, its three packages (lib, bin, include) will be put into the three packages corresponding to/usr/local by default. UnixODBC that does not need to be installed is stored in your own directory. Although you specified -- with-unixodbc in./confiugre, it still cannot be found. Www.2cto.com: Therefore, you must test the three packages under unixODBC in the three packages corresponding to/usr/local. In this way, you can find libtdsodbc during installation. so [unixODBC] [FreeTDS] [SQL Server] Adaptive Server connection failed solution: isql-v mysqlserver test needs to specify the user name, password problem [unixODBC] [FreeTDS] [SQL Server] Some character (s) cocould not be converted into client's character set Unconverted bytes were changed to question marks ('? ') 42000 solution: In freetds. configure client charset = UTF-8 www.2cto.com problem ORA-00942 in conf: The Table or view does not exist [MySQL] [ODBC 5.1 Driver] [mysqld-5.1.61] Table 'test' doesn' t exist {42S02, nativeErr = 1146} ORA-02063: followed by 2 lines (from mydbc3) 00942. 00000-"table or view does not exist" * Cause: * Action: solution: Your odbc. the database specified in ini is inconsistent with the database where the table you want to query is located. It is also possible that the table does not exist. Problem: [unixODBC] [FreeTDS] [SQL Server] Unable to connect to data source cause: odbc. ini cannot be found. Although you are correct in connecting to isql, an error is still returned. Solution: whether to specify the odbc. ini path in init + DNSnme. And it is best to use the odbc. ini provided by the system by default.