try using the same username and password that you do when you log in to
mysql?
if you don't use a password in mysql, just use the username that has access
to the db.
I've found the book "MySQL" by New Riders publishing (DuBois) to be a very
good resource.
here is a link to amazon for the book.
http://www.amazon.com/exec/obidos/ASIN/0735709211/fatwalletcom
Tim
----- Original Message -----
From: "Phil Labonte" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Monday, October 30, 2000 1:05 PM
Subject: RE: ODBC to MySQL help
> Can you elaborate a little? How do I do that?
>
> Sorry I am new at this, I am a newbie. I appreciate the help!!!!
>
> -----Original Message-----
> From: Tim Storm [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 1:58 PM
> To: CF-Linux
> Subject: Re: ODBC to MySQL help
>
> probably need to assign a username and password to the database in order
for
> it to work.
>
> Tim
> ----- Original Message -----
> From: "Phil Labonte" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Monday, October 30, 2000 12:56 PM
> Subject: RE: ODBC to MySQL help
>
>
> > The database and CF server are on the same box.
> >
> > Did you have to specify a username and password to connect? Do I need
to
> > tell MySql who is allowed to have access?
> >
> > I am new at this sorry?
> >
> > This is what I did. 1- Created a database on MySQL called testcf
> > 2- I created a table call testable
> > 3- Added some data to the table
> > 4- Selected MySQL ODBC
> > 5- Created a datasource called testodbc and databasename is testcf
> > 6- Verified my datasource failed.
> >
> >
> >
> >
> > -----Original Message-----
> > From: Tim Storm [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, October 30, 2000 1:50 PM
> > To: CF-Linux
> > Subject: Re: ODBC to MySQL help
> >
> > I've got RH 6.2, and didn't have any problems.
> >
> > make sure the database exists on mysql and you've given permissions for
> the
> > machine CF is hosted on to access the mysql database and associated
> tables.
> >
> > Tim
> > ----- Original Message -----
> > From: "Phil Labonte" <[EMAIL PROTECTED]>
> > To: "CF-Linux" <[EMAIL PROTECTED]>
> > Sent: Monday, October 30, 2000 12:37 PM
> > Subject: ODBC to MySQL help
> >
> >
> > > I have Red Hat 7.0 and CF server 4.5.1 running as well as MySql 3.22.
> > >
> > > Can someone tell me if there is a problem creating an ODBC connection
to
> > > MySQL from ColdFusion?
> > >
> > > I have tried to create a connection and I always get a failed test
when
> I
> > > verify my ODBC connection.
> > >
> > > Is there a trick to creating the ODBC? Do I need to download anything
> in
> > > order to create this? I have seen a document from Allaire on the
> subject
> > > but nothing that would help me create the connection...
> > >
> > > Thanks for you help
> > >
> > >
> > >
> > >
> > >
> >
>
> --------------------------------------------------------------------------
> > ----
> > > 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.
> >
>
> --------------------------------------------------------------------------
> ----
> > 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.
>
> --------------------------------------------------------------------------
----
> 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.
