RE: Connecting to SQL from CF across the 'Net?
I'm going through old emails I hadn't read, sorry it's taken so long to respond. All of my CF development has used data sources that have been on the same local network as the CF Server. In an upcoming project, I'll be connecting to a SQL server from CF by it's IP address via VPN over the Internet. I'm curious to hear from others who have done this if there have been any issues with dropped connections, poor performance or other difficulties from within CF. This can certainly cause poor performance. First, remote connections are typically much slower than connections across the LAN. Much, much slower. This might not be an issue for you, depending on the amount of traffic you have, the amount of caching you can do, etc, but I can certainly say that I've seen cases where this has been a performance killer. Second, the VPN will probably impose some overhead as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213911 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Connecting to SQL from CF across the 'Net?
I'm going through old emails I hadn't read, sorry it's taken so long to respond. On this same topic, is there any reason to use a VPN as opposed to just restricting access to a single IP? I think we plan to access our SQL server remotely by allowing external traffic only to our webserver's IP address. We're just getting this set up and I don't want to second guess our IT guy but... is it a bad idea to do it this way? There are security issues involved in allowing unencrypted traffic across public networks. If you don't have any sensitive data, this might be acceptable, but any machine on any network segment between your web server and your database server may be able to read your database traffic, including the logins themselves. There are all sorts of ways you can implement point-to-point encryption, though. If both machines are running Windows, you might set up an IPsec tunnel, which is pretty easy to do. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213912 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Connecting to SQL from CF across the 'Net?
All of my CF development has used data sources that have been on the same local network as the CF Server. In an upcoming project, I'll be connecting to a SQL server from CF by it's IP address via VPN over the Internet. I'm curious to hear from others who have done this if there have been any issues with dropped connections, poor performance or other difficulties from within CF. Any heads up tips would be a huge help. Thanks Much. -- Alex Sherwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Connecting to SQL from CF across the 'Net?
I do it all the time (remote VPN). Just enter the IP address (or server name), port, and any other connection information as you would on a local database. Pete On Mon, 21 Mar 2005 13:34:40 -0500, Alex Sherwood [EMAIL PROTECTED] wrote: All of my CF development has used data sources that have been on the same local network as the CF Server. In an upcoming project, I'll be connecting to a SQL server from CF by it's IP address via VPN over the Internet. I'm curious to hear from others who have done this if there have been any issues with dropped connections, poor performance or other difficulties from within CF. Any heads up tips would be a huge help. Thanks Much. -- Alex Sherwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Connecting to SQL from CF across the 'Net?
I do it all the time and it works great. Just have to remember to connect to the VPN before you start otherwise you have to wait for the connection to timeout and try again. -Original Message- From: Alex Sherwood [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 11:35 AM To: CF-Talk Subject: Connecting to SQL from CF across the 'Net? All of my CF development has used data sources that have been on the same local network as the CF Server. In an upcoming project, I'll be connecting to a SQL server from CF by it's IP address via VPN over the Internet. I'm curious to hear from others who have done this if there have been any issues with dropped connections, poor performance or other difficulties from within CF. Any heads up tips would be a huge help. Thanks Much. -- Alex Sherwood ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199597 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Connecting to SQL from CF across the 'Net?
On this same topic, is there any reason to use a VPN as opposed to just restricting access to a single IP? I think we plan to access our SQL server remotely by allowing external traffic only to our webserver's IP address. We're just getting this set up and I don't want to second guess our IT guy but... is it a bad idea to do it this way? -Original Message- From: Connie DeCinko [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 12:39 PM To: CF-Talk Subject: RE: Connecting to SQL from CF across the 'Net? I do it all the time and it works great. Just have to remember to connect to the VPN before you start otherwise you have to wait for the connection to timeout and try again. -Original Message- From: Alex Sherwood [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 11:35 AM To: CF-Talk Subject: Connecting to SQL from CF across the 'Net? All of my CF development has used data sources that have been on the same local network as the CF Server. In an upcoming project, I'll be connecting to a SQL server from CF by it's IP address via VPN over the Internet. I'm curious to hear from others who have done this if there have been any issues with dropped connections, poor performance or other difficulties from within CF. Any heads up tips would be a huge help. Thanks Much. -- Alex Sherwood ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Connecting to SQL from CF across the 'Net?
I would think so, since if the data isn't encrypted, though others couldn't access the server the data would be easily read on the wire...and if it is of a sensitive nature even worse. John Interested in Hiking in Washington State? Check out http://www.attrition.ws From: Paul [mailto:[EMAIL PROTECTED] Sent: Mon 3/21/2005 12:08 PM To: CF-Talk Subject: RE: Connecting to SQL from CF across the 'Net? On this same topic, is there any reason to use a VPN as opposed to just restricting access to a single IP? I think we plan to access our SQL server remotely by allowing external traffic only to our webserver's IP address. We're just getting this set up and I don't want to second guess our IT guy but... is it a bad idea to do it this way? -Original Message- From: Connie DeCinko [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 12:39 PM To: CF-Talk Subject: RE: Connecting to SQL from CF across the 'Net? I do it all the time and it works great. Just have to remember to connect to the VPN before you start otherwise you have to wait for the connection to timeout and try again. -Original Message- From: Alex Sherwood [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 11:35 AM To: CF-Talk Subject: Connecting to SQL from CF across the 'Net? All of my CF development has used data sources that have been on the same local network as the CF Server. In an upcoming project, I'll be connecting to a SQL server from CF by it's IP address via VPN over the Internet. I'm curious to hear from others who have done this if there have been any issues with dropped connections, poor performance or other difficulties from within CF. Any heads up tips would be a huge help. Thanks Much. -- Alex Sherwood ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54