I currently have my aspx files stored on a web server with 2008 ms sql. I have no problem connecting to the ms sql on the web server using a connectstring in my web.config. My company also has a local network 2008 ms sql where I need to retrieve some data. Is it possible to create a connection string in my web.config file on the web server to connect me to my company's local network server? I understand that remote users will not have access to this data. Any help or insight would be appreciated!
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.