InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 23:08:35 GMT20http://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxvstitte,You're probably right, but I figured they will use SSIS for data-exchange anyway. If that is the case then my post is relevant, otherwise my post was for PR purposes only. :-P- Steve.Thu, 28 Jan 2010 11:24:39 GMT"Walkair" Steve Rezhenerhttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxI thought the question was how to connect to SQL Server From Oracle.Thu, 28 Jan 2010 05:19:53 GMTvstittehttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxRam,You should install Oracle Client on your development machine (similar to SQL Native Client installation). One thing to remember is that Oracle Client installation creates system variables and sometimes skips an important BIN folder. Without BIN folder SSIS/SQL Server can't find essential Oracle drivers/DLLs.Good luck,Steve.Wed, 27 Jan 2010 12:23:41 GMT"Walkair" Steve Rezhenerhttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxTry these links[url=http://www.dba-oracle.com/t_database_link_sql_server_oracle.htm]Connect to SQL Server from Oracle[/url][url=http://www.databasejournal.com/features/oracle/article.php/3442661/Making-a-Connection-from-Oracle-to-SQL-Server.htm]Connect to SQL Server from Oracle with screenshots[/url]I am not an Oracle guy but I read this article few months back.Mon, 25 Jan 2010 23:37:53 GMTvstittehttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxThanks for the reply,Where i need to install oracle client software ??in SQL server or Oracle ServerWe have both servers & databases...I need to access the tables of sql server database from oracle......Thanks,Mon, 25 Jan 2010 23:22:22 GMTram_reddyprasadhttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspx[quote][b]Peter Veilleux-436764 (1/25/2010)[/b][hr]I did this at my last job. Since I'm no longer there, I don't have complete details, but here are some general steps. And I'm a SQL Server guy, so my Oracle is not exactly the best.1. download and install the Oracle 9i client. I think it's free from Oracle.2. configure client using Net Manager. We used the tnsnames.ora file, but there is another way to talk to Oracle.3. verify your connectivity to Oracle using Net Manager4. create a linked server in SQL Server (Server Objects - Linked Servers). Not sure what the Provider name will be, since I don't have Oracle drivers installed here.From there, it's pretty much the same as configuring any other linked server.Good luck....Peter[/quote]Provider should be Microsoft OLE DB Provider for Oracle.Mon, 25 Jan 2010 08:28:26 GMTrlondonhttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxI did this at my last job. Since I'm no longer there, I don't have complete details, but here are some general steps. And I'm a SQL Server guy, so my Oracle is not exactly the best.1. download and install the Oracle 9i client. I think it's free from Oracle.2. configure client using Net Manager. We used the tnsnames.ora file, but there is another way to talk to Oracle.3. verify your connectivity to Oracle using Net Manager4. create a linked server in SQL Server (Server Objects - Linked Servers). Not sure what the Provider name will be, since I don't have Oracle drivers installed here.From there, it's pretty much the same as configuring any other linked server.Good luck....PeterMon, 25 Jan 2010 07:25:11 GMTpveilleuxhttp://www.sqlservercentral.com/Forums/Topic852699-1042-1.aspxHello Everyone,Here i have Oracle Database 9i and SQL Server 2005 databases.I have some tables in sql server db and i want to access from Oracle.How to create a link between these two serversplease do needful.........Kindly waiting for the replay...Thanks,Sun, 24 Jan 2010 02:23:08 GMTram_reddyprasad