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/[email protected]/
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
