Re: Create MYSQL Datasource

The two latest entries on my blog tell you how to do it. The first post deals specifically with SQL Server, whilst the second one outlines the mods you have to make for MySQL. http://www.creative-restraint.co.uk is where you'll find them. Andy Quoting Pete Freitag [EMAIL PROTECTED]: cfhelp

Re: Create MYSQL Datasource

Worked perfectly for MySQL (from your instructions). I'm going to customize it slightly so that I don't have to post the admin. pw to the object rather have it set like cfset isLoggedIn=cfAdmin.login('#adminpw#') something like that. Anyways works great .. I was going to write a 2-3 step CFHTTP to

Re: Create MYSQL Datasource

Rick - I have a similar issue. Are you on NT or Linux? I have a cfx tag that will create the dsn on NT, but I have not tested it on CFMX, only CF4.5 ... and to further OUR problems I lost the syntax .. I'm going to look through my emails to see if I have it or ask another guy that has direct

Re: Create MYSQL Datasource

You should be able to do this using the service factory, though it's unsupported.Basically just reimplementing the CF administrator's functionality. cheers, barneyb On Thu, 19 Aug 2004 11:11:56 -0500, cfhelp [EMAIL PROTECTED] wrote: I have built the script to create the database and the user on

RE: Create MYSQL Datasource

://www.arcriver.com/ http://www.arcriver.com/ Kansas City Musicians http://www.kcjukebox.com/ -Original Message- From: joe velez [mailto:[EMAIL PROTECTED] Sent: Thursday, August 19, 2004 11:41 AM To: CF-Talk Subject: Re: Create MYSQL Datasource Rick - I have a similar issue. Are you

Re: Create MYSQL Datasource

cfhelp wrote: I need to create the Data source (DSN) for CFMX on the webserver Without using the CF Administrator. I was just playing with the datasource service factory, here's what I have, it doesn't seam to be saving the datasource to the neo-query.xml file when I create one.