Wow! talking about doing unnecessary extra work! We have to build a software with an sql Database that will have to check for Orders in our ERP DB (Oracle) So, what was my boss idea? He made us create a trigger that each time an order was created or modified a record with it's primary key was added in a table, Then we had an oracle process that run each 10' that looked at that table, recollected all the order information and saved it to another table in oracle, hen he made us install Oracle Gateway so we can access the sql server from oracle, So when there was New orders in the processed table oracle would connect to Sql Server and add a record to a Sql Tabla that said there was new data,Then we had another process in sql server that checked this table every 1' if the table said there was new data then another process was run that read the now processed tables with the order informations in oracle and extracted the data, once it extracted the data the process checked for modification o inserts against the Final Sql Server Orders Table! So after all that we Could access the sql server table from the Software and just list the content of the table.. When i told my boss why don't we just Access the orders table in Oracle from the software he told me: Noooo, if they change their TnsNames.ora file it would stop working!!! :wtf: