Hi Tom,
Check out my blog tutorial on setting up a remoting
application on
mac osx, I explain how to set up a datasource in detail
there mate 
Cheers,
Simon
On 8 Jun 2007, at 11:55, Doug Hyde wrote:
> Tom,
>
> It looks to me like the database you are trying to use
is an access
> database, not a mysql database. If you are connected
either through
> ODBC or
> JDBC, you should be able to specify the name of the
database as set
> out in
> mysql. MySql listens on port 3306. The name you enter
for a
> database should
> be a single name like "cartweaver" not a path
like " Macintosh
> HD/Applications/ColdFusionMX7/wwwroot/CWTest/database/
> mydatabase.mdb". This
> path would be incorrect anyways as the mac is unix
based - you
> would enter
>
"/Applications/ColdFusionMX7/wwwroot/CWTest/database/
> mydatabase.mdb" as the
> absolute path.
>
> Unless the data is in mysql already, the steps would be
import the
> access
> database into mysql (easier on a pc - if you want it to
be easy,
> use navicat
> mysql gui), where you establish the name of the
datasource. This is
> the name
> you enter.
>
> Hope that helps.
>
> Doug
>
>> From: Tom Budd <tom.budd2005 gmail.com>
>> Reply-To: <cf-machouseoffusion.com>
>> Date: Fri, 08 Jun 2007 03:00:57 -0400
>> To: CF-Mac <cf-machouseoffusion.com>
>> Subject: Setting up DSN with MySQL driver on mac
>>
>> Hi all
>>
>> I'm just trying to get a local testing environment
set up so that
>> I can begin
>> using some recently purchased shopping cart
software- Cartweaver.
>> I'm stuck at
>> the part where I'm trying to submit a DSN in the CF
Administrator.
>> Problem
>> with the tutorial I'm following is that it shows
you how to set up
>> a dev
>> environment for PC using MS Access and therefore
doesn't cover MySQL.
>>
>> To give you an understanding of what I'm doing....
I'm working on
>> a mac using
>> Dreamweaver 8. I've bought Cartweaver 3 and have
the latest
>> version of MySQL
>> server running on my machine. I also have
CocoaMySQL
>> (I was advised to download this by Cartweaver)
which seems to be
>> communicating
>> with MySQL. Cartweaver is also installed into the
site.
>>
>> I go into CF Administrator (which I access at
>> h
ttp://127.0.0.1:8500/CFIDE/administrator/index.cfm) and
add a DSN
>> called
>> testdsn (as per Cartweaver setup tutorial) choosing
MySQL (3.x) as
>> driver type
>> (as opposed to MS Access in the tutorial). Another
set of options
>> pop up for
>> which I give the following info:
>>
>> CF Data Source Name - testdsn
>> Database - Macintosh
>>
HD/Applications/ColdFusionMX7/wwwroot/CWTest/database/mydata
base.mdb
>> (which is the path to the file I created in
Dreamweaver)
>> Server - http://localhost:127.0.0.1
(local) Port - 3306
>>
>> The error message I get back says:
>>
>> Cannot connect to MySQL server on http:3306. Is
there a MySQL
>> server running
>> on the machine/port you are trying to connect to?
>> (java.net.UnknownHostException)
>>
>> I've tried putting 8500 as the port but get the
same thing. So I'm
>> really not
>> sure what I'm doing wrong and dont seem to be able
to find the
>> answer on the
>> net as yet. I dont hve a MySQL dayabase set up but
I thought this
>> part came
>> further down the line.
>>
>> Any advice greatly appreciated
>>
>> Tom
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more
productivity.
ht
tp://www.adobe.com/products/coldfusion?sdid=RVJW
Archive: http://www.houseoffusion.com/groups/CF-Mac/
message.cfm/messageid:4208
Subscription: http://www.houseoffusion.com/groups/CF-Mac/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/u
nsubscribe.cfm?user=22184.15789.48
|
