Access Informix Database:
Server and client configuration See: http://blog.9cbs.net/xieye/archive/2005/02/24/299536.aspx Add System DSN: DSN_TEST, Configuration and Informix Client SetNet32 Similar EXEC SP_ADDLINKEDSERVER @server = ' inf ', @ srvproduct =' ', @ provider =' msdasql ', @ datasrc =' dsn_test'EXEC sp_addlinkedsrvlogin 'inf', falseselect * from openquery (inf, 'select * from table_name') exec sp_dropserver 'inf', 'droplogins '
Visit the Oracle Database:
exec sp_addlinkedserver @server = 'ora', @ srvproduct = 'oracle', @ provider = 'msdaora', @ datasrc = 'local net service name oracle client settings' EXEC sp_addlinkedsrvlogin' ora ', false,' sa ',' Oracle_username ',' Oracle_password'select * from OpenQuery (ORA, 'SELECT * FROM table ") EXEC SP_DROPSERVER' ORA ',' DROPLOGINS '
