Thanks Tom. When I did this I got an ODBC error back that said connection
failed due to port shutdown due to too many failed connection attempts (or
something to that effect, I'm kicking myself since I didn't write it down)
and it even said to run mysqladmin -p flush-hosts to flush the connections.
When I did this everything started to work. The datasource verified and the
sample query runs fine.
Now my question is this, does this occur often? Have others seen this error
reported and is it something that needs to be constantly monitored?
Thanks again everyone for all your help during this install process the last
couple of weeks.
-Peter Amiri
-----Original Message-----
From: Tom Jordahl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 03, 2000 12:23 PM
To: CF-Linux
Subject: Re: Problems creating a mySQL datasource
Peter Amiri wrote:
> One is that similar to the NT environment that the user ID the service is
> running under must at times have network privileges in order to use
network
> resources, the user CF is running under on linux must have some special
> privileges before the CF engine can talk to the mySQL engine using the
> Merant mySQL Driver. Can anyone support or deny this theory?
This is not the case.
Write a template which has a simple CFQUERY tag using the mySQL data
source. You will get a better error diagnostic that should lead you
toward a solution.
Example template:
<cfquery Name="q" DataSource="d1844_net">
select * from table
</cfquery>
--
Tom Jordahl [EMAIL PROTECTED]
Allaire Development http://www.allaire.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
