I deleted the DB and created a new one; mapped the DSN to it, and (so far)
all seems fine.
Thanks to all those who replied, on and off list.
Will
--
Will
new media discussion for Berkshire -=- http://bnm.lukrative.com
local classifieds -=- http://www.localbounty.com
e: [EMAIL PROTECTED] icq: 31099745
----- Original Message -----
From: "Evan Lavidor" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Tuesday, July 03, 2001 2:57 PM
Subject: RE: Can't perform queries in Unix
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
