I was using MySQL on CF Linux and ran into a similar problem. I could do
SELECT queries but not UPDATE or INSERT queries. Turned out to be exactly
what's referenced below: permissions. Both permissions on the file itself
as well as the GRANT permissions in MySQL. The database permissions I
understood, but the file permissions I wasn't so clear on why that should be
affected. But, hey, it worked...
Evan
> -----Original Message-----
> From: W Luke [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 03, 2001 7:34 AM
> To: CF-Talk
> Subject: Re: Can't perform queries in Unix
>
>
> Possibly, although I can't see why that would affect it. Will
> give it a go.
>
> Cheers
>
> --
> Will
> new media discussion for Berkshire -=- http://bnm.lukrative.com
> local classifieds -=- http://www.localbounty.com
> e: [EMAIL PROTECTED] icq: 31099745
>
> > Just grasping here...but how about file permissions for the
> > user on the database file?
> >
> > -----Original Message-----
> > From: W Luke [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 02, 2001 11:04 AM
> > To: CF-Talk
> > Subject: Re: Can't perform queries in Unix
> >
> >
> > Yes. Other functions are working ok (eg <Cfmail>) but queries
> just don't.
> >
> > Will
> >
> >
> > ----- Original Message -----
> > From: "Bryan Lentz" <[EMAIL PROTECTED]>
> > Newsgroups: cf-talk
> > Sent: Monday, July 02, 2001 3:32 PM
> > Subject: RE: Can't perform queries in Unix
> >
> >
> > > Can you ping the unix server?
> > > (assuming it is on a separate box)
> > >
> > > -----Original Message-----
> > > From: W Luke [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, June 28, 2001 6:50 AM
> > > To: CF-Talk
> > > Subject: Can't perform queries in Unix
> > >
> > >
> > > Hi,
> > >
> > > I'm trying to run a query - as basic as they come - to insert
> form data
> > into
> > > a table. Except that the server is throwing a strange error at me:
> > >
> > > "An error occurred while attempting to establish a connection to the
> > server.
> > >
> > > The most likely cause of this problem is that the server is not
> currently
> > > running. Verify that the server is running and restart it if
> necessary.
> > >
> > > Unix error number 2 occurred: No such file or directory"
> > >
> > > The form action and method have been defined, and the page definately
> does
> > > exist. I'm using the correct Datasource, DBtype, Username &
> Password -
> > what
> > > else can I do?
> > >
> > > In desperation
> > >
> > > --
> > > Will
> > > new media discussion for Berkshire -=- http://bnm.lukrative.com
> > > local classifieds -=- http://www.localbounty.com
> > > e: [EMAIL PROTECTED] icq: 31099745
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
