Thankyou Thankyou (as I smile until my cheeks hurt)
I forwarded your suggestion through to my ISP - he followed your
instructions and it works like a charm.
Did I say Thankyou? - Thankyou
Cheers
Kylie
----- Original Message -----
From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 4:42 PM
Subject: RE: SQL error (minus the mess)
> ok, second round.
>
> when setting up the datasource, did you restrict access to the SQL command
> set? in the CFAdministrator, under "ODBC Datasources", select the DSN in
> question. choose "Advanced>>", and make sure that "SELECT" is checked.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -----Original Message-----
> From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 2:46 AM
> To: CF-Talk
> Subject: Re: SQL error (minus the mess)
>
>
> Thanks for taking the time Christopher. I removed the username and
password
> from my CFQUERY - but still receiving the same error of SQL operation
> unauthorized.
>
> Cheers
> Kylie
> ----- Original Message -----
> From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 13, 2000 3:29 PM
> Subject: RE: SQL error (minus the mess)
>
>
> > at just a quick glance, is the username/password combination valid for
> that
> > database? did you give access to the user "username"? access by
default
> > does not have security. try removing the username and password
attributes
> > from your CFQUERY.
> >
> > chris olive, cio
> > cresco technologies
> > [EMAIL PROTECTED]
> > http://www.crescotech.com
> >
> >
> >
>
>
> --------------------------------------------------------------------------
--
> --------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
