Teddy made that sound harder than it is! Drop the mysql connector jar
in the proper cfmx lib directory and then specify your db like below.
CF Data Source Name (whatever you want)
JDBC URL jdbc:mysql://127.0.0.1:3306/<dbname>
Driver Class com.mysql.jdbc.Driver
Driver Name (whatever you want)
On 11/22/06, Dusty Hale <[EMAIL PROTECTED]> wrote:
Being that this application is extreamly basic, I think I will just try the
one in CF admin and if I can't get it to work for some reason try the other.
Basically all this thing needs to do is insert one record into a single
table and then upload an image that associated with the data. I'm assuming I
need to handle the image upload with <cfftp> rather than <cffile>.
Thanks again for the replies.
Dusty
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy Payne
Sent: Wednesday, November 22, 2006 7:53 PM
To: discussion@acfug.org
Subject: Re: RE: RE: [ACFUG Discuss] Blue Dragon
I would probably recommend using the drivers from mysql.org even for earlier
versions. The JDBC drivers provided with CF work fine, but I noticed that
in my previous adventures in querying MySQL databases, that the JConnector
did offer better error messages and more compatibility. The down side is
that you have to configure the application a little bit more with a
connection string. The process is pretty well documented though.
Teddy
On 11/22/06, Steven Ross <[EMAIL PROTECTED]> wrote:
As for the version you need to check what is running if it is v5 you
have to download the driver and call it through jdbc.
On 11/22/06, Dusty Hale <[EMAIL PROTECTED]> wrote:
> Ahhh .... in this case the MySQL box is several states away :) ....
probably
> be slow like this but it will only be used to do 1 insert query a day for
> just one record so I don't think the sluggishness will be too much of a
> problem. Thanks again for all the replies.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Justin
Haygood
> Sent: Wednesday, November 22, 2006 5:09 PM
> To: discussion@acfug.org
> Subject: RE: RE: [ACFUG Discuss] Blue Dragon
>
> I do this exact thing all the time, except the mysql server is on the
> same LAN as the cf application server :)
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Ross
> Sent: Wednesday, November 22, 2006 4:31 PM
> To: discussion@acfug.org
> Subject: Re: RE: [ACFUG Discuss] Blue Dragon
>
> You can certainly do that. You just need a user on the mysql box that
> will let you connect and the firewall has to be setup to let traffic
> in on 3306 (or whatever port your running mysql on).
>
> -Steven
>
> On 11/22/06, Dusty Hale < [EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> >
> > Teddy one thought though is maybe I run just this application on a
> shared
> > server. Do you know if there is a way to access a remote "MySQL"
> database
> > (one running on the linux server) with CF? Could an DSN be made on the
> > shared server that could update the MySQL database which resides on a
> remote
> > server on a different network?
> >
> >
> >
> > I have not worked with MySQL before but something tells me that I
> think I
> > remember researching this once and determining it couldn't be done.
> >
> >
> >
> > Thanks for your previous reply and any suggestions you may have.
> >
> >
> >
> > Dusty
> >
> >
> > ________________________________
> >
> >
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy
> Payne
> > Sent: Wednesday, November 22, 2006 2:35 PM
> > To: discussion@acfug.org
> > Subject: Re: [ACFUG Discuss] Blue Dragon
> >
> >
> >
> > What about hosting the site on an application service provider? You
> don't
> > have to budget for the CF license then. Is the client firm on the
> fact that
> > the Linux server must house the site?
> >
> > Teddy
> >
> >
> > On 11/22/06, Dusty Hale <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> > I have a new client I need to design a very simple app for and I would
> > prefer to do it in cold fusion because I could do it fast and not have
> to
> > charge much. The problem is that the dedicated server he has is a
> Linux
> > server and does not have CF on it.
> >
> >
> >
> > Of course I know CF will run fine on a linux server but since there is
> no
> > budget to purchase a license for it, I assumed I would need to rethink
> it
> > and do this with PHP. However, then I though Blue Dragon maybe? Could
> anyone
> > tell me if my thoughts are worth researching more? Will Blue Dragon
> allow me
> > to develop my app with my local cf server then move to his server
> where I
> > install Blue Dragon on it? Do you think I will run into headaches and
> issues
> > with this approach.
> >
> >
> >
> > Thanks ahead of time for any advice I get.
> >
> >
> >
> > Dusty
> >
> >
> >
> >
> >
> >
> >
> >
> >
-------------------------------------------------------------
> > To unsubscribe from this list, manage your profile @
> > http://www.acfug.org?fa=login.edituserform
> >
> > For more info, see http://www.acfug.org/mailinglists
> > Archive @
> > http://www.mail-archive.com/discussion%40acfug.org/
> > List hosted by FusionLink
> >
-------------------------------------------------------------
> >
> >
> >
> >
> > --
> > <cf_payne />
> > Adobe Certified ColdFusion MX 7 Developer
> > Atlanta CFUG (ACFUG): http://www.acfug.org
> >
-------------------------------------------------------------
> > To unsubscribe from this list, manage your profile @
> > http://www.acfug.org?fa=login.edituserform
> >
> > For more info, see http://www.acfug.org/mailinglists
> > Archive @
> > http://www.mail-archive.com/discussion%40acfug.org/
> > List hosted by FusionLink
> >
-------------------------------------------------------------
> >
> >
-------------------------------------------------------------
> > To unsubscribe from this list, manage your profile @
> > http://www.acfug.org?fa=login.edituserform
> >
> > For more info, see http://www.acfug.org/mailinglists
> > Archive @
> > http://www.mail-archive.com/discussion%40acfug.org/
> > List hosted by FusionLink
> >
-------------------------------------------------------------
>
>
> --
> Steven Ross
> web application & interface developer
> http://www.zerium.com
> [mobile] 404-488-4364
> [fax] 928-484-4364
>
>
>
-------------------------------------------------------------
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
>
-------------------------------------------------------------
>
>
>
>
>
>
>
-------------------------------------------------------------
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=gin.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
>
-------------------------------------------------------------
>
>
>
>
>
>
>
-------------------------------------------------------------
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform
>
> For more info, see http://www.acfug.org/mailinglists
> Archive @
http://www.mail-archive.com/discussion%40acfug.org/
> List hosted by http://www.fusionlink.com
>
-------------------------------------------------------------
>
>
>
>
--
Steven Ross
web application & interface developer
http://www.zerium.com
[mobile] 404-488-4364
[fax] 928-484-4364
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
--
<cf_payne />
Adobe Certified ColdFusion MX 7 Developer
Atlanta CFUG (ACFUG): http://www.acfug.org
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @
http://www.mail-archive.com/discussion%40acfug.org/
List hosted by FusionLink
-------------------------------------------------------------
--
Steven Ross
web application & interface developer
http://www.zerium.com
[mobile] 404-488-4364
[fax] 928-484-4364
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform
For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------
