date:20110510


I have been looking for a an outside gateway that I can use 
and  thought I found the perfect one.. the amazon simple email 
service... I wasted a lot of time getting it set up then found it 
limits you to about 500 emails a day for a while until you prove you 
are a good person and not a spammer.. I have about 12,000 emails 
backed up already.

At 10:58 PM 5/9/2011, you wrote:

On 10/05/2011 12:51, Ben Conner wrote:
 
 
  And you can't use a gateway server as that will be delivered on 
 port 25 as well.

How about port 587, the alternate port for authenticated mails, that
should still be open. If not maybe a completely different port to a
gateway where that is configurable?


--
Yours,

Kym Kovan
mbcomms.net.au





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344393
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ISP blocking port 25


I am pretty sure that can't work - anyone else know that it can?

At 01:44 AM 5/10/2011, you wrote:

in the meantime, try port 26 - it usually works fine (unless it is blocked).

Azadi

On 10/05/2011 08:36 , Al Musella, DPM wrote:
  So - anyone have any ideas on what I can do from now until it is fixed?
  I changed the retries on my mail server to 6,12,18,24 hours so
  hopefully the mail in the queue will go out when it is fixed and I
  won't lose anything... but of course this is for a brain cancer
  charity and we are in the middle of the national walk to end brain
  tumors for brain tumor awareness month and were getting a lot of
  action on the server.
 
 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344394
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ISP blocking port 25


Many ISP's block port 25 to stop spam.
port 587 is actually the official SMTP submission port nowadays, and any
half decent ISP should have this enabled, so I suggest giving this a try.
Port 2525 is also another common alternative that some ISP's have enabled.

However you have implied that it is your own mail server, in which case you
can set it to use whatever ports you like, including the above, which are
the default alternative port sin SmarterMail anyway, so you just need to
enable them.



--

Russ Michaels

www.bluethunderinternet.com  : Business hosting services  solutions
www.cfmldeveloper.com: ColdFusion developer community
www.michaels.me.uk   : my blog
www.cfsearch.com : ColdFusion search engine
**
*skype me* : russmichaels


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344395
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release


Judah,

Yes it is nice to have power, but it is rather like buying a Porshe to drive
around town at 30MPH, sure you can brag about it and tell everyone how you
could drive at 200mph if you wanted to, but really you are never going to do
it, and a more practical car is really going to do a better job for you in
that scenario.

My comments are based on my own *REAL WORLD* experience hosting hundreds of
databases over many years, rather than as a developer building a single
database/website. but in those years I have experienced the following, which
is why I will always prefer/recommend MSSQL.

MySQL databases corrupt quite easily and need to be repaired (even on
dedicated machines)
Never had a MSSQL corruption problem since MSSQL 2000
MySQL  will easily get overloaded by a single database and consume 100% CPU
requiring a restart, only experienced this on v4 so far though.
Never had that problem on MSSQL
MySQL is a PITA to backup and restore, time consuming and quirky and dumps
not always reliable.
MSSQL is simple and quick to backup/restore/migrate.
Our MSSQL servers are able to host far more databases than the MySQL
servers.

Now granted the limits on Express edition would mean you could not host HUGE
memory/CPU hogging databases, but as I said, this scenario is quite rare,
most people's databases do not come anywhere near this and the Express
edition will handle them just fine, so it certainly is not just good for
development. We ran SQL 2005 express for years in a shared hosting
environment with no problems at all, the limits did not cause any problems
for a long time. We managed to get a lot of databases on the server until it
started to run out of power, and now we use SQL Server 2008 web edition,
which is actually very cheap to run.
Again I would point out that if you are in the need of great power and
reliability, then you should be running your own server and probably not
running the free editions anyway.

The problem with databases and database servers is that most developers
really don;t know much about them, and will just throw together a basic
database and rely on the servers out of the box config. In this area MSSQL
shines, as you can install it out of the box with no tweaking and it will
run like a dream.

With MySQL on the other hand you really need a deeper understanding of how
it works to be able to fine tune its performance and you also need to
understand the different database engines it utilises and when to use them,
again something most people do not do, which adds to the
reliability/performance issues with databases.

To be honest this is somewhat of a rarity as M$ products are usually not
known for being the best, often it is the 3rd party products which are
superior, but you also have to remember that M$ did not originally create
SQL Server, it was originally Sybase. So if you are in the anti-Microsoft
camp you may find this history of SQL server interesting.

http://insidesqlserver.com/companion/History%20of%20SQL%20Server.pdf

At the end of the day this is just my opinion/experience, you do not have to
agree with it.


On Tue, May 10, 2011 at 4:18 AM, Judah McAuley ju...@wiredotter.com wrote:


 MySql is free though licensing is a bit complicated because of a
 dual-license model. The community edition includes many enterprise
 sorts of features like replication and partitioning. If I recall,
 there are additional backup tools and monitoring in the paid
 enterprise edition. If you want to go completely free from the weird
 Oracle ownership stuff (which I think is wise, personally), there is
 the MariaDB fork which is entirely FOSS as far as I know. What
 enterprise features are you thinking aren't in the community
 edition?

 MySql community edition has none of the limitations present in MS SQL
 Express edition. Honestly, not taking advantage of more than a gig of
 RAM or 1 cpu core is just stupid. Why would you even have a database
 server? I suppose if you are housing the db on the same machine as
 your app server then...well, you have plenty of other problems at that
 point.

 Sql Express is great for development (though I prefer developer
 edition myself). It is not meant for production websites, period.
 That's why Microsoft has a Web edition. I like SQL Server and use it
 but it is wrong to try and compare Sql Express and MySql community
 edition, they are completely different classes of software.

 That being said, I still think people should check out PostGres. A
 feature set comparable to Oracle/MS SQL/Sybase and genuinely FOSS,
 unlike MySql. Tasty DB goodness.

 Cheers,
 Judah

 On Mon, May 9, 2011 at 4:57 PM, Russ Michaels r...@michaels.me.uk wrote:
 
  Many people often wrongly assume that MySQL is simply FREE, which is not
  correct. Many people are also completely unaware that there is a FREE
 MSSQL
  Express edition.
  The FREE version is the community edition, which also has limitations,
 look
  them up, If you want enterprise features then you have to pay i'm

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?


choose the standard server config, but install it using the built in web
server and do not configure IIS.
then update to 9.0.1
then use the web config tool to enable CF on IIS7
you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS
website if you wish to run it from there.


On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com wrote:


 Dave pardon the lame question, but which install option do I pick if not
 server configuration?  And then how do I hook up to IIS after the fact?

 RR

 On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote:

 
   Just a quick question.  Will Coldfusion 9 run fine on Windows 2008 R2
  Server
   Web Server Edition?  Or do I need to buy Standard edition licenses?
 
  Yes, you can install CF on any version of Windows Server 2008.
 
   Also, so I still need to install the II6 compatibility extensions? Or
 has
   that all be sorted out now.
 
  You will have to update CF to 9.0.1 before hooking it to IIS, if you
  want to avoid installing the IIS 6 compatibility layer.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
  http://training.figleaf.com/
 
  Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
  GSA Schedule, and provides the highest caliber vendor-authorized
  instruction at our training centers, online, or onsit
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344397
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Migrating a DB from MS SQL 2000 into MySQL latest release


I've been using MySQL for over 10 years and never had any problems with it.
Get PremiumSoft's Navicat for your GUI and management is a breeze.  Never
had anything corrupted and MySQL only overloads the CPU when code is not
working correctly.

Backups can easily be automated with Navicat, as well.

I've had good experience with it and highly recommend it.

Rick

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, May 10, 2011 7:14 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release


Judah,

Yes it is nice to have power, but it is rather like buying a Porshe to drive
around town at 30MPH, sure you can brag about it and tell everyone how you
could drive at 200mph if you wanted to, but really you are never going to do
it, and a more practical car is really going to do a better job for you in
that scenario.

My comments are based on my own *REAL WORLD* experience hosting hundreds of
databases over many years, rather than as a developer building a single
database/website. but in those years I have experienced the following, which
is why I will always prefer/recommend MSSQL.

MySQL databases corrupt quite easily and need to be repaired (even on
dedicated machines)
Never had a MSSQL corruption problem since MSSQL 2000
MySQL  will easily get overloaded by a single database and consume 100% CPU
requiring a restart, only experienced this on v4 so far though.
Never had that problem on MSSQL
MySQL is a PITA to backup and restore, time consuming and quirky and dumps
not always reliable.
MSSQL is simple and quick to backup/restore/migrate.
Our MSSQL servers are able to host far more databases than the MySQL
servers.

Now granted the limits on Express edition would mean you could not host HUGE
memory/CPU hogging databases, but as I said, this scenario is quite rare,
most people's databases do not come anywhere near this and the Express
edition will handle them just fine, so it certainly is not just good for
development. We ran SQL 2005 express for years in a shared hosting
environment with no problems at all, the limits did not cause any problems
for a long time. We managed to get a lot of databases on the server until it
started to run out of power, and now we use SQL Server 2008 web edition,
which is actually very cheap to run.
Again I would point out that if you are in the need of great power and
reliability, then you should be running your own server and probably not
running the free editions anyway.

The problem with databases and database servers is that most developers
really don;t know much about them, and will just throw together a basic
database and rely on the servers out of the box config. In this area MSSQL
shines, as you can install it out of the box with no tweaking and it will
run like a dream.

With MySQL on the other hand you really need a deeper understanding of how
it works to be able to fine tune its performance and you also need to
understand the different database engines it utilises and when to use them,
again something most people do not do, which adds to the
reliability/performance issues with databases.

To be honest this is somewhat of a rarity as M$ products are usually not
known for being the best, often it is the 3rd party products which are
superior, but you also have to remember that M$ did not originally create
SQL Server, it was originally Sybase. So if you are in the anti-Microsoft
camp you may find this history of SQL server interesting.

http://insidesqlserver.com/companion/History%20of%20SQL%20Server.pdf

At the end of the day this is just my opinion/experience, you do not have to
agree with it.


On Tue, May 10, 2011 at 4:18 AM, Judah McAuley ju...@wiredotter.com wrote:


 MySql is free though licensing is a bit complicated because of a
 dual-license model. The community edition includes many enterprise
 sorts of features like replication and partitioning. If I recall,
 there are additional backup tools and monitoring in the paid
 enterprise edition. If you want to go completely free from the weird
 Oracle ownership stuff (which I think is wise, personally), there is
 the MariaDB fork which is entirely FOSS as far as I know. What
 enterprise features are you thinking aren't in the community
 edition?

 MySql community edition has none of the limitations present in MS SQL
 Express edition. Honestly, not taking advantage of more than a gig of
 RAM or 1 cpu core is just stupid. Why would you even have a database
 server? I suppose if you are housing the db on the same machine as
 your app server then...well, you have plenty of other problems at that
 point.

 Sql Express is great for development (though I prefer developer
 edition myself). It is not meant for production websites, period.
 That's why Microsoft has a Web edition. I like SQL Server and use it
 but it is wrong to try and compare Sql Express and MySql community
 edition, they are completely different classes of software.

 That being said, I still

RE: ISP blocking port 25


Have you checked to see if you've been blacklisted?
I used to have this problem with Comcast.  If an outside
blacklisting company put me on their list, then I ended
up blacklisted at Comcast and at GoDaddy, too.

Rick

-Original Message-
From: Al Musella, DPM [mailto:muse...@virtualtrials.com] 
Sent: Tuesday, May 10, 2011 5:53 AM
To: cf-talk
Subject: Re: ISP blocking port 25


I am pretty sure that can't work - anyone else know that it can?

At 01:44 AM 5/10/2011, you wrote:

in the meantime, try port 26 - it usually works fine (unless it is
blocked).

Azadi

On 10/05/2011 08:36 , Al Musella, DPM wrote:
  So - anyone have any ideas on what I can do from now until it is fixed?
  I changed the retries on my mail server to 6,12,18,24 hours so
  hopefully the mail in the queue will go out when it is fixed and I
  won't lose anything... but of course this is for a brain cancer
  charity and we are in the middle of the national walk to end brain
  tumors for brain tumor awareness month and were getting a lot of
  action on the server.
 
 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344399
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CF form puzzler

2011-05-10 Thread Stephens, Larry V

Nope - just checked it again. 

-Original Message-
From: =?ISO-8859-1?Q?Claude_Schn=E9egans 
[mailto:schneegans@interneti=71?=.=?ISO-8859-1?Q?ue.com=3E?=] 
Sent: Monday, May 09, 2011 8:32 AM
To: cf-talk
Subject: Re: CF form puzzler

 I keep seeing html charcters in the field and the latest entry has 300-400 
 lines of MS Word html code and, at the very end, the true entry  Pierce 
 amp; Madison Co.s

Is it possible that you are having two fields using the same name in the form ?

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344400
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cfcontent to serve PDF files hanging

2011-05-10 Thread Stephen Hardesty


Jason,
I am experiencing a similar problem. Did you ever find out exactly what was 
causing yours?

thanks,
Stephen 

 Thank you for the ideas.  We are going to change the mime/type and 
 also add some I/O logging to see if we can find a correlation there.  
 Should we find the issue I will certainly post back.
 
 Thanks for the time!
 
 Jason
 
 ON the other hand... I would expect a mime/type problem to result in 
 an
 error on the browser - not a hanging request, unless of the course 
 the
 hanging is the browsers cycling through choices to figure out how 
 to
 display the file.
 
 How may files are in the directory in question? Do you perhaps have 
 an I/O
 problem?
 
 Mark A. Kruger, MCSE, CFG
 (402) 408-3733 ext 105
 Skype: markakruger
 www.cfwebtools.com
 www.coldfusionmuse.com
 www.necfug.com
 
 
 
 Good call I think Jake...
 
 
 
 
 The only think I could think of is use application/pdf for the 
 Content-Type
 (that is technically the correct mime type).
 
 -Jake
 
 On Tue, Aug 31, 2010 at 10:33 AM, Jas 


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344401
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Solr Errors

2011-05-10 Thread Mary Jo Sminkey


Just checking in Mary. Were you able to get past this? Have you
considering contacting Adobe for official support?

No, we had to drop the use of Solr at this time, it wasn't critical enough for 
this application to pay for a support ticket (and that involves a heck of red 
tape here and takes forever...this was a case of get it working asap). We're 
still using Solr for a lot of our data (documents, PDFs, etc.), but only the 
stuff that gets updated every night, and not the data that users are adding 
frequently. Unfortunately there just did not seem to be a way to index those at 
runtime as soon as they are added without having issues, and the users were not 
willing to wait for them to be indexed at specific time intervals (say run the 
indexing every x minutes) which would have been the best workaround. 


--- Mary Jo





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344402
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

I'm glad your experiences have been good Rich. Perhaps you can quantify the
scale, i.e how many databases over how long, i'm sure it will be more
helpful to present a bigger picture.

But do remember just as a car owner can say my car has been great, this
cannot be applied to every single owner of that same car. You have to
consider others experiences as well.
Of course not everyone has the same problems, but if hundreds of others have
had the same problems, then you cannot really ignore it.
As I said, my experience is with hundreds of customers/databases over many
years, so it is not really just my own opinion/experience, but all the
experience of all those other customers as well, I am more of a messenger
really.

The common problems and issues can be googled, like this for example.
http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq=trls=org.mozilla:en-GB:officialclient=firefox-a

You are correct that backups can be automated, they can even be automated
with the FREE MySQLAdministrator that used to come free with mysql, but for
some bizarre reason Oracle removed this feature from the new workbench.
However the problem is in the way that backups work, it is not really a
backup, it is a DUMP from the database as one huge SQL script to drop
tables, re-create tables and re-insert data.
This causes some of the following issues on shared hosting particularly

1. many people only have access to PHPMyadmin, and the DUMP can often be
very large even for a moderate sized databases, doing large dumps simply
wont work most of the time with PHPMyadmin, whether your backing up or
restoring, it just times out or cannot cope. Often the only solution is
command line directly on the server.
2. if moving between versions importing the dump wont work sometimes and it
can be a PITA to figure out why, especially if it is a BIG database and you
have to keep re-exporting it.

The CPU overload can of course be blamed on poor code, more usually bad SQL,
but this problem exists on every platform in every language, but MSSQL does
seem to cope with bad queries much better.

HTH

On Tue, May 10, 2011 at 1:42 PM, Rick Faircloth r...@whitestonemedia.comwrote:

I've been using MySQL for over 10 years and never had any problems with it.
Get PremiumSoft's Navicat for your GUI and management is a breeze. Never
had anything corrupted and MySQL only overloads the CPU when code is not
working correctly.

Backups can easily be automated with Navicat, as well.

I've had good experience with it and highly recommend it.

Rick

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 7:14 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release

Judah,

Yes it is nice to have power, but it is rather like buying a Porshe to
drive
around town at 30MPH, sure you can brag about it and tell everyone how you
could drive at 200mph if you wanted to, but really you are never going to
do
it, and a more practical car is really going to do a better job for you in
that scenario.

My comments are based on my own *REAL WORLD* experience hosting hundreds of
databases over many years, rather than as a developer building a single
database/website. but in those years I have experienced the following,
which
is why I will always prefer/recommend MSSQL.

MySQL databases corrupt quite easily and need to be repaired (even on
dedicated machines)
Never had a MSSQL corruption problem since MSSQL 2000
MySQL will easily get overloaded by a single database and consume 100% CPU
requiring a restart, only experienced this on v4 so far though.
Never had that problem on MSSQL
MySQL is a PITA to backup and restore, time consuming and quirky and dumps
not always reliable.
MSSQL is simple and quick to backup/restore/migrate.
Our MSSQL servers are able to host far more databases than the MySQL
servers.

Now granted the limits on Express edition would mean you could not host
HUGE
memory/CPU hogging databases, but as I said, this scenario is quite rare,
most people's databases do not come anywhere near this and the Express
edition will handle them just fine, so it certainly is not just good for
development. We ran SQL 2005 express for years in a shared hosting
environment with no problems at all, the limits did not cause any problems
for a long time. We managed to get a lot of databases on the server until
it
started to run out of power, and now we use SQL Server 2008 web edition,
which is actually very cheap to run.
Again I would point out that if you are in the need of great power and
reliability, then you should be running your own server and probably not
running the free editions anyway.

The problem with databases and database servers is that most developers
really don;t know much about them, and will just throw together a basic
database and rely on the servers out of the box config. In this area MSSQL
shines, as you can

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-10 Thread James Holmes


Or like this:

http://www.google.com.au/search?sourceid=chromeie=UTF-8q=ms+sql+express+corrupt+tables

--
WSS4CF - WS-Security framework for CF
http://wss4cf.riaforge.org/



On 10 May 2011 22:31, Russ Michaels r...@michaels.me.uk wrote:

 The common problems and issues can be googled, like this for example.
 http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq=trls=org.mozilla:en-GB:officialclient=firefox-a

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344404
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: ISP blocking port 25


That is what I thought at first - since I noticed that when I sent 
out my newsletter, I didn't get a copy on my aol account but did get 
it on my real email account (which was on the local mail server).
I called aol and they said they didn't block it... then I checked my 
gmail account and I didn't get it there either, then checked the mail 
logs and boy were there a lot of errors!

I talked to verizon at 6:00 this morning.. they said a lot of people 
are complaining about it now. I was the first to notice. They say 
they hope to get it fixed sometime today



At 08:44 AM 5/10/2011, you wrote:

Have you checked to see if you've been blacklisted?
I used to have this problem with Comcast.  If an outside
blacklisting company put me on their list, then I ended
up blacklisted at Comcast and at GoDaddy, too.

Rick


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344405
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release


Yes James, well done :-)

On Tue, May 10, 2011 at 3:37 PM, James Holmes james.hol...@gmail.comwrote:


 Or like this:


 http://www.google.com.au/search?sourceid=chromeie=UTF-8q=ms+sql+express+corrupt+tables

 --
 WSS4CF - WS-Security framework for CF
 http://wss4cf.riaforge.org/



 On 10 May 2011 22:31, Russ Michaels r...@michaels.me.uk wrote:
 
  The common problems and issues can be googled, like this for example.
 
 http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq=trls=org.mozilla:en-GB:officialclient=firefox-a

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344406
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Migrating a DB from MS SQL 2000 into MySQL latest release


My experience has mostly been with relatively small databases running
anywhere from 2 months to 8 years.  The most trafficked site I host
serves about 50,000 pages views per month with almost all pages serving
some database-driven dynamic content.

I usually have about 25 databases running simultaneously on the same
server with my sites.

I don't have a lot of complex code (at least not to me) running on these
servers accessing the database, so that cuts down on coding problems that
might cause MySQL to spike the CPU.  I did have more issues with that a
few years ago, and even once recently on the server, but the CPU spiking
has always been related to coding or another piece of software trying to
run cfexecute operations, etc.  I've never tracked an issue back to a
problem with MySQL.

And, I realize that every user's experience is going to be different, just
as every car driver's accident experience is different with the same make
and model, due mostly to the driver's use and driving capability.  Some
folks just have a propensity for crashing. :o)

I have no complaints with MySQL for my requirements.  It's been good to me.
I've always been a Windows Server user, fyi...

Rick

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, May 10, 2011 10:31 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release


I'm glad your experiences have been good Rich. Perhaps you can quantify the
scale, i.e how many databases over how long, i'm sure it will be more
helpful to present a bigger picture.

But do remember just as a car owner can say my car has been great, this
cannot be applied to every single owner of that same car. You have to
consider others experiences as well.
Of course not everyone has the same problems, but if hundreds of others have
had the same problems, then you cannot really ignore it.
As I said, my experience is with hundreds of customers/databases over many
years, so it is not really just my own opinion/experience, but all the
experience of all those other customers as well, I am more of a messenger
really.

The common problems and issues can be googled, like this for example.
http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq
=trls=org.mozilla:en-GB:officialclient=firefox-a

You are correct that backups can be automated, they can even be automated
with the FREE MySQLAdministrator that used to come free with mysql, but for
some bizarre reason Oracle removed this feature from the new workbench.
However the problem is in the way that backups work, it is not really a
backup, it is a DUMP from the database as one huge SQL script to drop
tables, re-create tables and re-insert data.
This causes some of the following issues on shared hosting particularly

1. many people only have access to PHPMyadmin, and the DUMP can often be
very large even for a moderate sized databases, doing large dumps simply
wont work most of the time with PHPMyadmin, whether your backing up or
restoring, it just times out or cannot cope. Often the only solution is
command line directly on the server.
2. if moving between versions importing the dump wont work sometimes and it
can be a PITA to figure out why, especially if it is a BIG database and you
have to keep re-exporting it.

The CPU overload can of course be blamed on poor code, more usually bad SQL,
but this problem exists on every platform in every language, but MSSQL does
seem to cope with bad queries much better.

HTH

On Tue, May 10, 2011 at 1:42 PM, Rick Faircloth
r...@whitestonemedia.comwrote:


 I've been using MySQL for over 10 years and never had any problems with
it.
 Get PremiumSoft's Navicat for your GUI and management is a breeze.  Never
 had anything corrupted and MySQL only overloads the CPU when code is not
 working correctly.

 Backups can easily be automated with Navicat, as well.

 I've had good experience with it and highly recommend it.

 Rick

 -Original Message-
 From: Russ Michaels [mailto:r...@michaels.me.uk]
 Sent: Tuesday, May 10, 2011 7:14 AM
 To: cf-talk
 Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release


 Judah,

 Yes it is nice to have power, but it is rather like buying a Porshe to
 drive
 around town at 30MPH, sure you can brag about it and tell everyone how you
 could drive at 200mph if you wanted to, but really you are never going to
 do
 it, and a more practical car is really going to do a better job for you in
 that scenario.

 My comments are based on my own *REAL WORLD* experience hosting hundreds
of
 databases over many years, rather than as a developer building a single
 database/website. but in those years I have experienced the following,
 which
 is why I will always prefer/recommend MSSQL.

 MySQL databases corrupt quite easily and need to be repaired (even on
 dedicated machines)
 Never had a MSSQL corruption problem since MSSQL 2000
 MySQL  will easily get overloaded by a single database and consume 100%
CPU

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-10 Thread Robert Rhodes


Sorry.  Where is the the web config tool?  ANd is it welf-explanatory, or is
there documentation somewhere?

On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk wrote:


 choose the standard server config, but install it using the built in web
 server and do not configure IIS.
 then update to 9.0.1
 then use the web config tool to enable CF on IIS7
 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS
 website if you wish to run it from there.


 On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com
 wrote:

 
  Dave pardon the lame question, but which install option do I pick if not
  server configuration?  And then how do I hook up to IIS after the fact?
 
  RR
 
  On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote:
 
  
Just a quick question.  Will Coldfusion 9 run fine on Windows 2008 R2
   Server
Web Server Edition?  Or do I need to buy Standard edition licenses?
  
   Yes, you can install CF on any version of Windows Server 2008.
  
Also, so I still need to install the II6 compatibility extensions? Or
  has
that all be sorted out now.
  
   You will have to update CF to 9.0.1 before hooking it to IIS, if you
   want to avoid installing the IIS 6 compatibility layer.
  
   Dave Watts, CTO, Fig Leaf Software
   http://www.figleaf.com/
   http://training.figleaf.com/
  
   Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
   GSA Schedule, and provides the highest caliber vendor-authorized
   instruction at our training centers, online, or onsit
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344408
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-10 Thread Robert Rhodes


Sorry about the typos:

On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com wrote:

 Sorry.  Where is the the web config tool?  And is it self-explanatory, or
 is there documentation somewhere?


 On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.ukwrote:


 choose the standard server config, but install it using the built in web
 server and do not configure IIS.
 then update to 9.0.1
 then use the web config tool to enable CF on IIS7
 you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your IIS
 website if you wish to run it from there.


 On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com
 wrote:

 
  Dave pardon the lame question, but which install option do I pick if not
  server configuration?  And then how do I hook up to IIS after the fact?
 
  RR
 
  On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote:
 
  
Just a quick question.  Will Coldfusion 9 run fine on Windows 2008
 R2
   Server
Web Server Edition?  Or do I need to buy Standard edition licenses?
  
   Yes, you can install CF on any version of Windows Server 2008.
  
Also, so I still need to install the II6 compatibility extensions?
 Or
  has
that all be sorted out now.
  
   You will have to update CF to 9.0.1 before hooking it to IIS, if you
   want to avoid installing the IIS 6 compatibility layer.
  
   Dave Watts, CTO, Fig Leaf Software
   http://www.figleaf.com/
   http://training.figleaf.com/
  
   Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
   GSA Schedule, and provides the highest caliber vendor-authorized
   instruction at our training centers, online, or onsit
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?


Start - program files - adobe - coldfusion 9

it is self explanitory

On Tue, May 10, 2011 at 5:07 PM, Robert Rhodes rrhode...@gmail.com wrote:


 Sorry about the typos:

 On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com
 wrote:

  Sorry.  Where is the the web config tool?  And is it self-explanatory, or
  is there documentation somewhere?
 
 
  On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk
 wrote:
 
 
  choose the standard server config, but install it using the built in web
  server and do not configure IIS.
  then update to 9.0.1
  then use the web config tool to enable CF on IIS7
  you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your
 IIS
  website if you wish to run it from there.
 
 
  On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com
  wrote:
 
  
   Dave pardon the lame question, but which install option do I pick if
 not
   server configuration?  And then how do I hook up to IIS after the
 fact?
  
   RR
  
   On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com
 wrote:
  
   
 Just a quick question.  Will Coldfusion 9 run fine on Windows 2008
  R2
Server
 Web Server Edition?  Or do I need to buy Standard edition
 licenses?
   
Yes, you can install CF on any version of Windows Server 2008.
   
 Also, so I still need to install the II6 compatibility extensions?
  Or
   has
 that all be sorted out now.
   
You will have to update CF to 9.0.1 before hooking it to IIS, if you
want to avoid installing the IIS 6 compatibility layer.
   
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
   
Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsit
   
   
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344410
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

Presumably all those databases were designed by you and all the code written
by you, so the lack of issues hopefully means all your code was good :-)

On Tue, May 10, 2011 at 4:45 PM, Rick Faircloth r...@whitestonemedia.comwrote:

My experience has mostly been with relatively small databases running
anywhere from 2 months to 8 years. The most trafficked site I host
serves about 50,000 pages views per month with almost all pages serving
some database-driven dynamic content.

I usually have about 25 databases running simultaneously on the same
server with my sites.

I don't have a lot of complex code (at least not to me) running on these
servers accessing the database, so that cuts down on coding problems that
might cause MySQL to spike the CPU. I did have more issues with that a
few years ago, and even once recently on the server, but the CPU spiking
has always been related to coding or another piece of software trying to
run cfexecute operations, etc. I've never tracked an issue back to a
problem with MySQL.

And, I realize that every user's experience is going to be different, just
as every car driver's accident experience is different with the same make
and model, due mostly to the driver's use and driving capability. Some
folks just have a propensity for crashing. :o)

I have no complaints with MySQL for my requirements. It's been good to me.
I've always been a Windows Server user, fyi...

Rick

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 10:31 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release

I'm glad your experiences have been good Rich. Perhaps you can quantify the
scale, i.e how many databases over how long, i'm sure it will be more
helpful to present a bigger picture.

But do remember just as a car owner can say my car has been great, this
cannot be applied to every single owner of that same car. You have to
consider others experiences as well.
Of course not everyone has the same problems, but if hundreds of others
have
had the same problems, then you cannot really ignore it.
As I said, my experience is with hundreds of customers/databases over many
years, so it is not really just my own opinion/experience, but all the
experience of all those other customers as well, I am more of a messenger
really.

The common problems and issues can be googled, like this for example.

http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq
=trls=org.mozilla:en-GB:officialclient=firefox-ahttp://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq%0A=trls=org.mozilla:en-GB:officialclient=firefox-a

The CPU overload can of course be blamed on poor code, more usually bad
SQL,
but this problem exists on every platform in every language, but MSSQL does
seem to cope with bad queries much better.

HTH

On Tue, May 10, 2011 at 1:42 PM, Rick Faircloth
r...@whitestonemedia.comwrote:

I've been using MySQL for over 10 years and never had any problems with
it.
Get PremiumSoft's Navicat for your GUI and management is a breeze. Never
had anything corrupted and MySQL only overloads the CPU when code is not
working correctly.

Backups can easily be automated with Navicat, as well.

I've had good experience with it and highly recommend it.

Rick

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk]
Sent: Tuesday, May 10, 2011 7:14 AM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release

Judah,

Yes it is nice to have power, but it is rather like buying a Porshe to
drive
around town at 30MPH, sure you can brag about it and tell everyone how
you
could drive at 200mph if you wanted to, but really you are never going to
do
it, and a more practical car is really going to do a better job for you
in
that scenario.

My comments are based on my own *REAL WORLD*

RE: Migrating a DB from MS SQL 2000 into MySQL latest release

All true...  now as far as all your code was good... I don't know
about that, but it gets the job done. :o)

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Tuesday, May 10, 2011 12:26 PM
To: cf-talk
Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release

Presumably all those databases were designed by you and all the code written
by you, so the lack of issues hopefully means all your code was good :-)

On Tue, May 10, 2011 at 4:45 PM, Rick Faircloth
r...@whitestonemedia.comwrote:

 My experience has mostly been with relatively small databases running
 anywhere from 2 months to 8 years.  The most trafficked site I host
 serves about 50,000 pages views per month with almost all pages serving
 some database-driven dynamic content.

 I usually have about 25 databases running simultaneously on the same
 server with my sites.

 I don't have a lot of complex code (at least not to me) running on these
 servers accessing the database, so that cuts down on coding problems that
 might cause MySQL to spike the CPU.  I did have more issues with that a
 few years ago, and even once recently on the server, but the CPU spiking
 has always been related to coding or another piece of software trying to
 run cfexecute operations, etc.  I've never tracked an issue back to a
 problem with MySQL.

 And, I realize that every user's experience is going to be different, just
 as every car driver's accident experience is different with the same make
 and model, due mostly to the driver's use and driving capability.  Some
 folks just have a propensity for crashing. :o)

 I have no complaints with MySQL for my requirements.  It's been good to
me.
 I've always been a Windows Server user, fyi...

 Rick

 -Original Message-
 From: Russ Michaels [mailto:r...@michaels.me.uk]
 Sent: Tuesday, May 10, 2011 10:31 AM
 To: cf-talk
 Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release

 I'm glad your experiences have been good Rich. Perhaps you can quantify
the
 scale, i.e how many databases over how long, i'm sure it will be more
 helpful to present a bigger picture.

 But do remember just as a car owner can say my car has been great, this
 cannot be applied to every single owner of that same car. You have to
 consider others experiences as well.
 Of course not everyone has the same problems, but if hundreds of others
 have
 had the same problems, then you cannot really ignore it.
 As I said, my experience is with hundreds of customers/databases over many
 years, so it is not really just my own opinion/experience, but all the
 experience of all those other customers as well, I am more of a messenger
 really.

 The common problems and issues can be googled, like this for example.

http://www.google.co.uk/search?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq

=trls=org.mozilla:en-GB:officialclient=firefox-ahttp://www.google.co.uk/s
earch?q=mysql+corrupted+tablesie=utf-8oe=utf-8aq%0A=trls=org.mozilla:en-
GB:officialclient=firefox-a

 You are correct that backups can be automated, they can even be automated
 with the FREE MySQLAdministrator that used to come free with mysql, but
for
 some bizarre reason Oracle removed this feature from the new workbench.
 However the problem is in the way that backups work, it is not really a
 backup, it is a DUMP from the database as one huge SQL script to drop
 tables, re-create tables and re-insert data.
 This causes some of the following issues on shared hosting particularly

 1. many people only have access to PHPMyadmin, and the DUMP can often be
 very large even for a moderate sized databases, doing large dumps simply
 wont work most of the time with PHPMyadmin, whether your backing up or
 restoring, it just times out or cannot cope. Often the only solution is
 command line directly on the server.
 2. if moving between versions importing the dump wont work sometimes and
it
 can be a PITA to figure out why, especially if it is a BIG database and
you
 have to keep re-exporting it.

 The CPU overload can of course be blamed on poor code, more usually bad
 SQL,
 but this problem exists on every platform in every language, but MSSQL
does
 seem to cope with bad queries much better.

 HTH

 On Tue, May 10, 2011 at 1:42 PM, Rick Faircloth
 r...@whitestonemedia.comwrote:

  I've been using MySQL for over 10 years and never had any problems with
 it.
  Get PremiumSoft's Navicat for your GUI and management is a breeze.
Never
  had anything corrupted and MySQL only overloads the CPU when code is not
  working correctly.

  Backups can easily be automated with Navicat, as well.

  I've had good experience with it and highly recommend it.

  Rick

  -Original Message-
  From: Russ Michaels [mailto:r...@michaels.me.uk]
  Sent: Tuesday, May 10, 2011 7:14 AM
  To: cf-talk
  Subject: Re: Migrating a DB from MS SQL 2000 into MySQL latest release

  Judah,

  Yes it is nice to have power, but it is rather like buying a Porshe to

RE: ISP blocking port 25


Finally fixed!

What a pain in the neck it is to talk to the verizon people.. had to 
go through quite a few people who don't understand that port 25 is 
needed. They opened it up and everything started working.. 26 hour outage.

Of course, that was right after I set up a relay account at 
socketlabs.com.  they have the best rates that I found and easiest 
setup.. in case it happens to anyone else..



At 08:44 AM 5/10/2011, you wrote:

Have you checked to see if you've been blacklisted?
I used to have this problem with Comcast.  If an outside
blacklisting company put me on their list, then I ended
up blacklisted at Comcast and at GoDaddy, too.

Rick


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344413
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-10 Thread Scott Weikert


Re: good code:

I've done this once (and am about to do it again) so I'll share a few 
bits that I learned re: code changes:

99% of my code was fine. But I had to adjust some syntax.

MSSQL vs MySQL:

LEN needs to be LENGTH
CHARINDEX needs to be LOCATE

There probably are more differences like that but those are the two I 
bumped into.

There's also the aforemented timestamp data type. If you use a 
datetime or timestamp field with getdate() as the default, you'll 
need to switch it to a timestamp field with a current_timestamp default.

Queries are also case sensitive so make sure your column names (and, 
IIRC, table names) match up.

I also had issues with how certain joins worked - I don't recall exactly 
what these issues were so I won't speculate. I just recall having to 
rewrite some queries to get them to function properly.

--Scott



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344414
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-10 Thread Robert Rhodes


Ok, thanks.  I haven't installed cf9 before and I didn't want to find out
when I got there that I didn't know what to do.   Thanks again.

On Tue, May 10, 2011 at 12:23 PM, Russ Michaels r...@michaels.me.uk wrote:


 Start - program files - adobe - coldfusion 9

 it is self explanitory

 On Tue, May 10, 2011 at 5:07 PM, Robert Rhodes rrhode...@gmail.com
 wrote:

 
  Sorry about the typos:
 
  On Tue, May 10, 2011 at 12:06 PM, Robert Rhodes rrhode...@gmail.com
  wrote:
 
   Sorry.  Where is the the web config tool?  And is it self-explanatory,
 or
   is there documentation somewhere?
  
  
   On Tue, May 10, 2011 at 7:18 AM, Russ Michaels r...@michaels.me.uk
  wrote:
  
  
   choose the standard server config, but install it using the built in
 web
   server and do not configure IIS.
   then update to 9.0.1
   then use the web config tool to enable CF on IIS7
   you can then simply copy the CFIDE from c:\coldfusion9\wwwroot to your
  IIS
   website if you wish to run it from there.
  
  
   On Tue, May 10, 2011 at 4:21 AM, Robert Rhodes rrhode...@gmail.com
   wrote:
  
   
Dave pardon the lame question, but which install option do I pick if
  not
server configuration?  And then how do I hook up to IIS after the
  fact?
   
RR
   
On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com
  wrote:
   

  Just a quick question.  Will Coldfusion 9 run fine on Windows
 2008
   R2
 Server
  Web Server Edition?  Or do I need to buy Standard edition
  licenses?

 Yes, you can install CF on any version of Windows Server 2008.

  Also, so I still need to install the II6 compatibility
 extensions?
   Or
has
  that all be sorted out now.

 You will have to update CF to 9.0.1 before hooking it to IIS, if
 you
 want to avoid installing the IIS 6 compatibility layer.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/

 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsit


   
   
  
  
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344415
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-10 Thread Jordan Michaels

It honestly wasn't my intention to start any sort of flame war. I
truthfully did find the comment humorous.

It was like stating that this 2oz kitten is more powerful then this
T-Rex over here. I had to laugh.

Maybe the kitten has super-robot ninja powers?

Honestly, it sounds to me like you're basing your more powerful
comments off of some bad experiences you had with MySQL. I respect that,
but I wouldn't call a very clearly hobbled DB engine more powerful
then an enterprise class DB engine because of it. Maybe you were
thinking of MS SQL Server in a more general term then MS SQL Express?

-Jordan

On 05/09/2011 04:20 PM, Russ Michaels wrote:

Perhaps you tried to run MSSQL on linux Jordan, that would certainly
be humorous I imagine :-)

On Tue, May 10, 2011 at 12:12 AM, Gerald Guidogerald.gu...@gmail.comwrote:

Russ Michaels wrote:

don't forget that MSSQL express is also free and more powerful than mysql

Jordan Michaelsjor...@viviotech.net wrote:

I find the more powerful comment humorous.

This should be fun to watch :) I am making some popcorn. Anyone want some?

On Mon, May 9, 2011 at 6:52 PM, Jordan Michaelsjor...@viviotech.net
wrote:

I find the more powerful comment humorous.

SQL Express limits are here:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Migration from MS SQL to MySQL documentation is here:

http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html

I've done it several times with no issues.

-Jordan

On 05/09/2011 03:38 PM, Russ Michaels wrote:

don't forget that MSSQL express is also free and more powerful than
mysql
community edition so there is no need to migrate to MySQL unless your
also
moving to Linux.
There are however free migration tools on the mysql site that will do
it
for
you.

On Mon, May 9, 2011 at 11:29 PM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:

I'm interested in any info. Pit falls to avoid, best practises, etc.

Many thanks,

Jenny
No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date:
05/08/11
19:34:00

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344416
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

(ot) Shameful

2011-05-10 Thread Irvin Gomez


The Adobe Coldfusion 9 demos do not work and have not worked for who knows how 
long. I guess that's the best way to show Adobe's commitment to its comatose 
product.

http://www.adobe.com/products/coldfusion/demos/


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344417
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: (ot) Shameful

2011-05-10 Thread John M Bliss


They work for me.  Chrome latest version.  What browser are you using?

On Tue, May 10, 2011 at 7:03 PM, Irvin Gomez ir...@pixel69.com wrote:


 The Adobe Coldfusion 9 demos do not work and have not worked for who knows
 how long. I guess that's the best way to show Adobe's commitment to its
 comatose product.

 http://www.adobe.com/products/coldfusion/demos/


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344418
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: (ot) Shameful

2011-05-10 Thread Mike Kear


Interesting way to introduce your self in a forum where nearly
everyone is making their living from what you call a comatose product.

Still, since the demos all work for me and have done since they were
put up on the web site, i guess that tells us volumes about your
judgement.   We can apply that assessment of your judgement to your
claim that Coldfusion is 'comatose'.

Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


On Wed, May 11, 2011 at 10:03 AM, Irvin Gomez ir...@pixel69.com wrote:

 The Adobe Coldfusion 9 demos do not work and have not worked for who knows 
 how long. I guess that's the best way to show Adobe's commitment to its 
 comatose product.

 http://www.adobe.com/products/coldfusion/demos/


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344419
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: (ot) Shameful

2011-05-10 Thread Gerald Guido


Works on this end. Mac and PC. IE and FF.

 ID ten T error by chance??

Curious -G!

On Tue, May 10, 2011 at 8:03 PM, Irvin Gomez ir...@pixel69.com wrote:


 The Adobe Coldfusion 9 demos do not work and have not worked for who knows
 how long. I guess that's the best way to show Adobe's commitment to its
 comatose product.

 http://www.adobe.com/products/coldfusion/demos/


 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344420
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: (ot) Shameful


works for me also, are you sure your browser is not comatose ?


On Wed, May 11, 2011 at 1:30 AM, Gerald Guido gerald.gu...@gmail.comwrote:


 Works on this end. Mac and PC. IE and FF.

  ID ten T error by chance??

 Curious -G!

 On Tue, May 10, 2011 at 8:03 PM, Irvin Gomez ir...@pixel69.com wrote:

 
  The Adobe Coldfusion 9 demos do not work and have not worked for who
 knows
  how long. I guess that's the best way to show Adobe's commitment to its
  comatose product.
 
  http://www.adobe.com/products/coldfusion/demos/
 
 
 

 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344421
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Migrating a DB from MS SQL 2000 into MySQL latest release