Oct 5, 2005 #1 esengul Instructor Dec 9, 2004 59 US Hi, i have a db on sql server, i have to have a dsn connection for Oracle Db. Could you tell me how i can do this? Thanks
Hi, i have a db on sql server, i have to have a dsn connection for Oracle Db. Could you tell me how i can do this? Thanks
Oct 5, 2005 #2 travisbrown Technical User Dec 31, 2001 1,016 Is this for a stored procedure, or for a data import/export? For working with Oracle data, you need to set up a linked server. http://www.dbazine.com/sql/sql-articles/sharma2 If you are creating a DTS package, you can set up a system dsn using the ODBC connection wizard. Upvote 0 Downvote
Is this for a stored procedure, or for a data import/export? For working with Oracle data, you need to set up a linked server. http://www.dbazine.com/sql/sql-articles/sharma2 If you are creating a DTS package, you can set up a system dsn using the ODBC connection wizard.