Access. um, access on a Linux box
Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access. um, access on a Linux box Redux
Oops. I forgot to add: The two datasources we'd be connecting to are an Access DB and an Oracle DB. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Jamie Keane [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 02, 2001 4:56 PM Subject: Access. um, access on a Linux box Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) Thanks, Jamie -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access. um, access on a Linux box
At 17:05 1/2/01 -0500, you wrote: Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) You can run MySQL on a Winbox, but their license was worded such that it was not free if you were running on Windows. I don't know if its still that way. You can connect to MSSQL on a winbox from Linux/CF. I have no idea why anyone would *want* their data running on a winbox if they were running everything else on a linux box. MySQL is quick and easy to setup on linux, they could just put their data there. RPS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access. um, access on a Linux box
The thing is these are existing datasources, and the admin who's going to be in charge of maintaining the servers has minimal NT experience. He wants to migrate over to Linux where the client was once using NT/Apache. -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.849.7771 x 228 Voice 704.849.9291 Fax -Original Message- From: Ryan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Date: Tuesday, January 02, 2001 5:05 PM Subject: Re: Access. um, access on a Linux box At 17:05 1/2/01 -0500, you wrote: Hi everyone, I have been asked to determine if there is a way for a client to run a CF/Linux/Apache box and maintain all DBs on a separate NT machine. Is there a good ODBC bridge that will fix this (preferably free/OSS)? I'm looking at a few potential possibilities, but I wanted to see if any of you have already solved my problem. :) You can run MySQL on a Winbox, but their license was worded such that it was not free if you were running on Windows. I don't know if its still that way. You can connect to MSSQL on a winbox from Linux/CF. I have no idea why anyone would *want* their data running on a winbox if they were running everything else on a linux box. MySQL is quick and easy to setup on linux, they could just put their data there. RPS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Access. um, access on a Linux box Redux
At 17:10 1/2/01 -0500, you wrote: Oops. I forgot to add: The two datasources we'd be connecting to are an Access DB and an Oracle DB. you should have no problem connecting to an Oracle database (running on any platform) from Linux. MS Access is harder. I know it can be done with perl, you can install Perl on the Winbox and then connect to that winbox using Perl on the linux box. But I don't know if you can just connect to the winbox with anything, I think you have to use the Perl interface, but with some research you should be able to figure out if its possible. RPS ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
