RE: Connecting to MySQL through CF 5 on Windows??
Have you installed the myODBC driver? -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:13 To: CF-Talk Subject: Connecting to MySQL through CF 5 on Windows?? Is it possible to connect CF 5 (installed on a Windows 2000 Server) to a MySQL database?If so, how would I do it?MySQL doesn't show up in the drop-down list for databases you can choose from on the windows install of CF 5 like it does on the Linux install.Does that mean it's not supported? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Connecting to MySQL through CF 5 on Windows??
I haven't done anything.It's actually not my server, I'm having to get instructions and pass them along.If anyone could give me a step-by-step that'd be great! John Burns -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:12 AM To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? Have you installed the myODBC driver? -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:13 To: CF-Talk Subject: Connecting to MySQL through CF 5 on Windows?? Is it possible to connect CF 5 (installed on a Windows 2000 Server) to a MySQL database?If so, how would I do it?MySQL doesn't show up in the drop-down list for databases you can choose from on the windows install of CF 5 like it does on the Linux install.Does that mean it's not supported? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Connecting to MySQL through CF 5 on Windows??
All I've done before is download the myODBC connector (http://www.mysql.com/downloads/api-myodbc-3.51.html) install it and then access the CF admin and mySQL appears in the list of databases. Jb. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:20 To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? I haven't done anything.It's actually not my server, I'm having to get instructions and pass them along.If anyone could give me a step-by-step that'd be great! John Burns -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:12 AM To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? Have you installed the myODBC driver? -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:13 To: CF-Talk Subject: Connecting to MySQL through CF 5 on Windows?? Is it possible to connect CF 5 (installed on a Windows 2000 Server) to a MySQL database?If so, how would I do it?MySQL doesn't show up in the drop-down list for databases you can choose from on the windows install of CF 5 like it does on the Linux install.Does that mean it's not supported? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Connecting to MySQL through CF 5 on Windows??
Not quite Install the myODBC drivers, then in Windows you'll need to add the datasource name through the Windows ODBC Manager control panel, as mySQL only shows up in the database type list in CF admin on *nix boxes. Once you've added the DSN through the control panel the data source will appear in the database section of CF administrator. Stephen John Beynon wrote: All I've done before is download the myODBC connector (http://www.mysql.com/downloads/api-myodbc-3.51.html) install it and then access the CF admin and mySQL appears in the list of databases. Jb. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:20 To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? I haven't done anything.It's actually not my server, I'm having to get instructions and pass them along.If anyone could give me a step-by-step that'd be great! John Burns -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:12 AM To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? Have you installed the myODBC driver? -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:13 To: CF-Talk Subject: Connecting to MySQL through CF 5 on Windows?? Is it possible to connect CF 5 (installed on a Windows 2000 Server) to a MySQL database?If so, how would I do it?MySQL doesn't show up in the drop-down list for databases you can choose from on the windows install of CF 5 like it does on the Linux install.Does that mean it's not supported? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Connecting to MySQL through CF 5 on Windows??
Must be different on CFMX then. I've only installed the myODBC connector but yet when I go to the cfadministrator and choose driver, it's listed in there, mySQL. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:55 To: CF-Talk Subject: Re: Connecting to MySQL through CF 5 on Windows?? Not quite Install the myODBC drivers, then in Windows you'll need to add the datasource name through the Windows ODBC Manager control panel, as mySQL only shows up in the database type list in CF admin on *nix boxes. Once you've added the DSN through the control panel the data source will appear in the database section of CF administrator. Stephen John Beynon wrote: All I've done before is download the myODBC connector (http://www.mysql.com/downloads/api-myodbc-3.51.html) install it and then access the CF admin and mySQL appears in the list of databases. Jb. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:20 To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? I haven't done anything.It's actually not my server, I'm having to get instructions and pass them along.If anyone could give me a step-by-step that'd be great! John Burns -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:12 AM To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? Have you installed the myODBC driver? -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:13 To: CF-Talk Subject: Connecting to MySQL through CF 5 on Windows?? Is it possible to connect CF 5 (installed on a Windows 2000 Server) to a MySQL database?If so, how would I do it?MySQL doesn't show up in the drop-down list for databases you can choose from on the windows install of CF 5 like it does on the Linux install.Does that mean it's not supported? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Connecting to MySQL through CF 5 on Windows??
On Thursday 11 Mar 2004 15:00 pm, John Beynon wrote: Must be different on CFMX then. CFMX uses JDBC, and I suspect that a mySQL JDBC connector ships with it. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Connecting to MySQL through CF 5 on Windows??
Yeah, CFMX kindly includes the driver in the listings whatever your OS, unlike CF5 Have contemplated adjusting the cf administrator on CF5 to allow adding mySQL datasourceBut that would require naughty bits of software and messing with allaire code :D Stephen John Beynon wrote: Must be different on CFMX then. I've only installed the myODBC connector but yet when I go to the cfadministrator and choose driver, it's listed in there, mySQL. -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:55 To: CF-Talk Subject: Re: Connecting to MySQL through CF 5 on Windows?? Not quite Install the myODBC drivers, then in Windows you'll need to add the datasource name through the Windows ODBC Manager control panel, as mySQL only shows up in the database type list in CF admin on *nix boxes. Once you've added the DSN through the control panel the data source will appear in the database section of CF administrator. Stephen John Beynon wrote: All I've done before is download the myODBC connector (http://www.mysql.com/downloads/api-myodbc-3.51.html) install it and then access the CF admin and mySQL appears in the list of databases. Jb. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:20 To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? I haven't done anything.It's actually not my server, I'm having to get instructions and pass them along.If anyone could give me a step-by-step that'd be great! John Burns -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:12 AM To: CF-Talk Subject: RE: Connecting to MySQL through CF 5 on Windows?? Have you installed the myODBC driver? -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 14:13 To: CF-Talk Subject: Connecting to MySQL through CF 5 on Windows?? Is it possible to connect CF 5 (installed on a Windows 2000 Server) to a MySQL database?If so, how would I do it?MySQL doesn't show up in the drop-down list for databases you can choose from on the windows install of CF 5 like it does on the Linux install.Does that mean it's not supported? John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]