Hello all. I am running a web app using sql server as my background database. The project has grown and I need employee information from an Oracle database. I am fairly fluent with sql statements on both the oracle and sql server environments. I experience with with database linking in Oracle, but none for sql server. Could someone please tell me how I can link sql server to oracle.
I would like to build it such that I have a stored procedure in sql server that performs a direct select statement against a table in an oracle database. I have an ODBC connection on my sql server computer that can access the oracle database. In fact I have used the import/export data wizard to copy over database tables from oracle.
Any help would be much appreciated.
I would like to build it such that I have a stored procedure in sql server that performs a direct select statement against a table in an oracle database. I have an ODBC connection on my sql server computer that can access the oracle database. In fact I have used the import/export data wizard to copy over database tables from oracle.
Any help would be much appreciated.