Re: from 6 to 7
I just downloaded the package to see the license since I couldn't find it on any of the pages...and it does specifically state that you may not: "use the software for commercial software hosting services" So, it looks like hosts offering it free is out. On 1/24/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > hmmm...got me thinking...what is the actual licensing for sql > > express? > > It's free, and you only need to worry about licensing if you plan to > redistribute it with your applications. > > SQL Server 2005 Express: > http://msdn.microsoft.com/sql/express/ > > Comparing SQL Server 2005 Express and MSDE: > http://msdn2.microsoft.com/en-us/library/ms165672.aspx > > Register for SQL Server Express Edition Redistribution Rights: > http://www.microsoft.com/sql/editions/express/redistregister.mspx > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230380 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
> hmmm...got me thinking...what is the actual licensing for sql > express? It's free, and you only need to worry about licensing if you plan to redistribute it with your applications. SQL Server 2005 Express: http://msdn.microsoft.com/sql/express/ Comparing SQL Server 2005 Express and MSDE: http://msdn2.microsoft.com/en-us/library/ms165672.aspx Register for SQL Server Express Edition Redistribution Rights: http://www.microsoft.com/sql/editions/express/redistregister.mspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
hmmm...got me thinking...what is the actual licensing for sql express? so far my googling has failed...previous versions of MSDE weren't good for anything more than a small app due to the throttling, but this version doesn't have that anymore...the limits of 1GB of RAM, 1 processor and 4GB database size put a lot off web apps within reach on that platform. Does anyone know of a link to the actual license agreement for SQL Express? I'd like to see what the fine print says. On 1/24/06, Russ <[EMAIL PROTECTED]> wrote: > Most ISP's should offer at least SQL EXPRESS 2005 for free... > > > -Original Message- > > From: Burns, John D [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 24, 2006 9:49 AM > > To: CF-Talk > > Subject: RE: from 6 to 7 > > > > Even mySQL would be an upgrade if you can't afford the SQL upgrade. At > > least it's reliable. > > > > > > John Burns > > Certified Advanced ColdFusion MX Developer > > Wyle Laboratories, Inc. | Web Developer > > > > > > -Original Message----- > > From: Ray Champagne [mailto:[EMAIL PROTECTED] > > Sent: Monday, January 23, 2006 5:17 PM > > To: CF-Talk > > Subject: Re: from 6 to 7 > > > > Aha! > > > > After they finally escalated the issue to the higher-ups, I found the > > issue. > > > > There are two DB apps running in background. They have the server set > > up so that only one connection can be open at a time when connecting to > > Access DB's. So, the scripts are timing out when concurrent requests > > are being made to two different Access DB's. They claim that they > > worked with Macromedia and this was the solution to a "stability issue > > with Win2003". > > > > Whatever - I guess it's time to upgrade to a SQL Server DB. > > > > Thanks for the help and suggestions, guys. > > > > Russ wrote: > > > Well we all know how bad access can get under load... is it possible > > > that they mapped it using the wrong db type? I believe CF7 introduced > > > > > MS Access vs MS Access Unicode. Also are persistent connections to > > the db enabled? > > > How big is the access file? > > > > > > If it's a big file, and persistent connections are not enabled, I can > > > see it timing out form time to time. > > > > > > Russ > > > > > > > > >>-Original Message- > > >>From: Ray Champagne [mailto:[EMAIL PROTECTED] > > >>Sent: Monday, January 23, 2006 4:55 PM > > >>To: CF-Talk > > >>Subject: Re: from 6 to 7 > > >> > > >>Sorry, was out shoveling snow. :( > > >> > > >>Nope, this is an Access DB. I know that's not the best situation, but > > > > >>like I said, it was my first project, and it worked fine on the other > > >>server. > > >> > > >>And, just so it's known, I'm on a shared host, so there is no access > > >>to anything outside my web root, including the administrator. > > >> > > >>Ray > > >> > > >>Jim Wright wrote: > > >> > > >>>That was where I was going...I just wanted to eliminate a local db > > >>>like Access. I don't think this is a shot in the dark...a lot of > > >>>hosts out there these days are just renting equipment in others co-lo > > > > >>>facilities...and often in more than one co-lo facility. You want to > > >>>make sure they are not pulling your data from one datacenter to > > >>>anothernot just different segments of "their" network. > > >>> > > >>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > > >>> > > >>> > > >>>>As well as the question other have asked about "which database" are > > >>>>you using, I also wonder if this server sits in a different segment > > >>>>of the network than the previous one. If the server and the database > > > > >>>>are further removed, they could have network issues that are causing > > > > >>>>longer delays in the calls to the database. You may want to ask if > > >>>>there is a database server in the same segment as your server that > > >>>>you could use instead of your old one. That's a shot in the dark, > > >>>>but you may want to research it. > > >>>> > > >>&g
RE: from 6 to 7
Most ISP's should offer at least SQL EXPRESS 2005 for free... > -Original Message- > From: Burns, John D [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 24, 2006 9:49 AM > To: CF-Talk > Subject: RE: from 6 to 7 > > Even mySQL would be an upgrade if you can't afford the SQL upgrade. At > least it's reliable. > > > John Burns > Certified Advanced ColdFusion MX Developer > Wyle Laboratories, Inc. | Web Developer > > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 5:17 PM > To: CF-Talk > Subject: Re: from 6 to 7 > > Aha! > > After they finally escalated the issue to the higher-ups, I found the > issue. > > There are two DB apps running in background. They have the server set > up so that only one connection can be open at a time when connecting to > Access DB's. So, the scripts are timing out when concurrent requests > are being made to two different Access DB's. They claim that they > worked with Macromedia and this was the solution to a "stability issue > with Win2003". > > Whatever - I guess it's time to upgrade to a SQL Server DB. > > Thanks for the help and suggestions, guys. > > Russ wrote: > > Well we all know how bad access can get under load... is it possible > > that they mapped it using the wrong db type? I believe CF7 introduced > > > MS Access vs MS Access Unicode. Also are persistent connections to > the db enabled? > > How big is the access file? > > > > If it's a big file, and persistent connections are not enabled, I can > > see it timing out form time to time. > > > > Russ > > > > > >>-Original Message- > >>From: Ray Champagne [mailto:[EMAIL PROTECTED] > >>Sent: Monday, January 23, 2006 4:55 PM > >>To: CF-Talk > >>Subject: Re: from 6 to 7 > >> > >>Sorry, was out shoveling snow. :( > >> > >>Nope, this is an Access DB. I know that's not the best situation, but > > >>like I said, it was my first project, and it worked fine on the other > >>server. > >> > >>And, just so it's known, I'm on a shared host, so there is no access > >>to anything outside my web root, including the administrator. > >> > >>Ray > >> > >>Jim Wright wrote: > >> > >>>That was where I was going...I just wanted to eliminate a local db > >>>like Access. I don't think this is a shot in the dark...a lot of > >>>hosts out there these days are just renting equipment in others co-lo > > >>>facilities...and often in more than one co-lo facility. You want to > >>>make sure they are not pulling your data from one datacenter to > >>>anothernot just different segments of "their" network. > >>> > >>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>>>As well as the question other have asked about "which database" are > >>>>you using, I also wonder if this server sits in a different segment > >>>>of the network than the previous one. If the server and the database > > >>>>are further removed, they could have network issues that are causing > > >>>>longer delays in the calls to the database. You may want to ask if > >>>>there is a database server in the same segment as your server that > >>>>you could use instead of your old one. That's a shot in the dark, > >>>>but you may want to research it. > >>>> > >>>> > >>>>John Burns > >>>>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | > > >>>>Web Developer > >>>> > >>>> > >>>>-Original Message- > >>>>From: Ray Champagne [mailto:[EMAIL PROTECTED] > >>>>Sent: Monday, January 23, 2006 3:26 PM > >>>>To: CF-Talk > >>>>Subject: from 6 to 7 > >>>> > >>>>Hey all: > >>>> > >>>>I'm having an issue with my hosting company that I wanted to run by > >>>>everyone. > >>>> > >>>>I've had a site up and running fine at this particular host for > >>>>quite a while now. While it is not the most elegantly coded site > >>>>(one of my first large projects), it works fine. To take advantage > >>>>of newer hosting option
Re: from 6 to 7
Oh, I know all about how bad Access is. The fact remains that this is an old, semi-poorly written application (from a maintenance standpoint, not a functional one), which would require LOTS of attention to upgrade to mySQL or SQL Server. With all the billable work piling up around here, I'd like to just leave this app until I can give it the proper time for the upgrade. All of my apps these days are using a "real" DB. I really am impressed with mySQL lately, though. As Ray Camden wrote in his blog a few days ago, there is a whole world of features that I didn't ever know about. Anyways, thanks for the help guys, it was appreciated. Ray Burns, John D wrote: > Even mySQL would be an upgrade if you can't afford the SQL upgrade. At > least it's reliable. > > > John Burns > Certified Advanced ColdFusion MX Developer > Wyle Laboratories, Inc. | Web Developer > > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 5:17 PM > To: CF-Talk > Subject: Re: from 6 to 7 > > Aha! > > After they finally escalated the issue to the higher-ups, I found the > issue. > > There are two DB apps running in background. They have the server set > up so that only one connection can be open at a time when connecting to > Access DB's. So, the scripts are timing out when concurrent requests > are being made to two different Access DB's. They claim that they > worked with Macromedia and this was the solution to a "stability issue > with Win2003". > > Whatever - I guess it's time to upgrade to a SQL Server DB. > > Thanks for the help and suggestions, guys. > > Russ wrote: > >>Well we all know how bad access can get under load... is it possible >>that they mapped it using the wrong db type? I believe CF7 introduced > > >>MS Access vs MS Access Unicode. Also are persistent connections to > > the db enabled? > >>How big is the access file? >> >>If it's a big file, and persistent connections are not enabled, I can >>see it timing out form time to time. >> >>Russ >> >> >> >>>-Original Message- >>>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>>Sent: Monday, January 23, 2006 4:55 PM >>>To: CF-Talk >>>Subject: Re: from 6 to 7 >>> >>>Sorry, was out shoveling snow. :( >>> >>>Nope, this is an Access DB. I know that's not the best situation, but > > >>>like I said, it was my first project, and it worked fine on the other >>>server. >>> >>>And, just so it's known, I'm on a shared host, so there is no access >>>to anything outside my web root, including the administrator. >>> >>>Ray >>> >>>Jim Wright wrote: >>> >>> >>>>That was where I was going...I just wanted to eliminate a local db >>>>like Access. I don't think this is a shot in the dark...a lot of >>>>hosts out there these days are just renting equipment in others co-lo > > >>>>facilities...and often in more than one co-lo facility. You want to >>>>make sure they are not pulling your data from one datacenter to >>>>anothernot just different segments of "their" network. >>>> >>>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: >>>> >>>> >>>> >>>>>As well as the question other have asked about "which database" are >>>>>you using, I also wonder if this server sits in a different segment >>>>>of the network than the previous one. If the server and the database > > >>>>>are further removed, they could have network issues that are causing > > >>>>>longer delays in the calls to the database. You may want to ask if >>>>>there is a database server in the same segment as your server that >>>>>you could use instead of your old one. That's a shot in the dark, >>>>>but you may want to research it. >>>>> >>>>> >>>>>John Burns >>>>>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | > > >>>>>Web Developer >>>>> >>>>> >>>>>-Original Message- >>>>>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>>>>Sent: Monday, January 23, 2006 3:26 PM >>>>>To: CF-Talk >>>>>Subject: from 6 to 7 >>>>> >>>>>Hey all
RE: from 6 to 7
Even mySQL would be an upgrade if you can't afford the SQL upgrade. At least it's reliable. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 5:17 PM To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a "stability issue with Win2003". Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: > Well we all know how bad access can get under load... is it possible > that they mapped it using the wrong db type? I believe CF7 introduced > MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? > How big is the access file? > > If it's a big file, and persistent connections are not enabled, I can > see it timing out form time to time. > > Russ > > >>-Original Message- >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 4:55 PM >>To: CF-Talk >>Subject: Re: from 6 to 7 >> >>Sorry, was out shoveling snow. :( >> >>Nope, this is an Access DB. I know that's not the best situation, but >>like I said, it was my first project, and it worked fine on the other >>server. >> >>And, just so it's known, I'm on a shared host, so there is no access >>to anything outside my web root, including the administrator. >> >>Ray >> >>Jim Wright wrote: >> >>>That was where I was going...I just wanted to eliminate a local db >>>like Access. I don't think this is a shot in the dark...a lot of >>>hosts out there these days are just renting equipment in others co-lo >>>facilities...and often in more than one co-lo facility. You want to >>>make sure they are not pulling your data from one datacenter to >>>anothernot just different segments of "their" network. >>> >>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: >>> >>> >>>>As well as the question other have asked about "which database" are >>>>you using, I also wonder if this server sits in a different segment >>>>of the network than the previous one. If the server and the database >>>>are further removed, they could have network issues that are causing >>>>longer delays in the calls to the database. You may want to ask if >>>>there is a database server in the same segment as your server that >>>>you could use instead of your old one. That's a shot in the dark, >>>>but you may want to research it. >>>> >>>> >>>>John Burns >>>>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | >>>>Web Developer >>>> >>>> >>>>-Original Message- >>>>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>>>Sent: Monday, January 23, 2006 3:26 PM >>>>To: CF-Talk >>>>Subject: from 6 to 7 >>>> >>>>Hey all: >>>> >>>>I'm having an issue with my hosting company that I wanted to run by >>>>everyone. >>>> >>>>I've had a site up and running fine at this particular host for >>>>quite a while now. While it is not the most elegantly coded site >>>>(one of my first large projects), it works fine. To take advantage >>>>of newer hosting options (more disk space), we migrated this site >>>>from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like >>>>even the most menial database queries are sometimes timing out. >>>>Mind you, this is not occurring all the time with the same query, it >>>>seems to be happening with different queries at different times. >>>> >>>>I'm now in a debate with said host - they are telling me that it's >>>>because of my coding in general, they say I need to "upgrade" my >>>>coding to adapt to CF7. I say this is pure BS, a copout answer. >>>>From what I know, the release of CF7 was more a "features" release, >>>>so this shouldn't matter, right? >>>> >>>>Ray >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
Access is never a good web DB solution. It was never designed to handle that kind of traffic. It was designed to handle a salesman's client list or a home user's address book. It is one of the most abused pieces of software in the history of software... Eric -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, 23 January 2006 16:17 To: CF-Talk Subject: Re: from 6 to 7 Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a "stability issue with Win2003". Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: > Well we all know how bad access can get under load... is it possible > that they mapped it using the wrong db type? I believe CF7 introduced > MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? > How big is the access file? > > If it's a big file, and persistent connections are not enabled, I can > see it timing out form time to time. > > Russ > > >>-Original Message- >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 4:55 PM >>To: CF-Talk >>Subject: Re: from 6 to 7 >> >>Sorry, was out shoveling snow. :( >> >>Nope, this is an Access DB. I know that's not the best situation, but >>like I said, it was my first project, and it worked fine on the other >>server. >> >>And, just so it's known, I'm on a shared host, so there is no access >>to anything outside my web root, including the administrator. >> >>Ray >> >>Jim Wright wrote: >> >>>That was where I was going...I just wanted to eliminate a local db >>>like Access. I don't think this is a shot in the dark...a lot of >>>hosts out there these days are just renting equipment in others co-lo >>>facilities...and often in more than one co-lo facility. You want to >>>make sure they are not pulling your data from one datacenter to >>>anothernot just different segments of "their" network. >>> >>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: >>> >>> >>>>As well as the question other have asked about "which database" are >>>>you using, I also wonder if this server sits in a different segment >>>>of the network than the previous one. If the server and the database >>>>are further removed, they could have network issues that are causing >>>>longer delays in the calls to the database. You may want to ask if >>>>there is a database server in the same segment as your server that >>>>you could use instead of your old one. That's a shot in the dark, >>>>but you may want to research it. >>>> >>>> >>>>John Burns >>>>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | >>>>Web Developer >>>> >>>> >>>>-Original Message- >>>>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>>>Sent: Monday, January 23, 2006 3:26 PM >>>>To: CF-Talk >>>>Subject: from 6 to 7 >>>> >>>>Hey all: >>>> >>>>I'm having an issue with my hosting company that I wanted to run by >>>>everyone. >>>> >>>>I've had a site up and running fine at this particular host for >>>>quite a while now. While it is not the most elegantly coded site >>>>(one of my first large projects), it works fine. To take advantage >>>>of newer hosting options (more disk space), we migrated this site >>>>from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like >>>>even the most menial database queries are sometimes timing out. >>>>Mind you, this is not occurring all the time with the same query, it >>>>seems to be happening with different queries at different times. >>>> >>>>I'm now in a debate with said host - they are telling me that it's >>>>because of my coding in general, they say I need to "upgrade" my >>>>coding to adapt to CF7. I say this is pure BS, a copout answer. >>>>From what I know, the release of CF7 was more a "features" release, >>>>so this shouldn't matter, right? >>>> >>>>Ray >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
Aha! After they finally escalated the issue to the higher-ups, I found the issue. There are two DB apps running in background. They have the server set up so that only one connection can be open at a time when connecting to Access DB's. So, the scripts are timing out when concurrent requests are being made to two different Access DB's. They claim that they worked with Macromedia and this was the solution to a "stability issue with Win2003". Whatever - I guess it's time to upgrade to a SQL Server DB. Thanks for the help and suggestions, guys. Russ wrote: > Well we all know how bad access can get under load... is it possible that > they mapped it using the wrong db type? I believe CF7 introduced MS Access > vs MS Access Unicode. Also are persistent connections to the db enabled? > How big is the access file? > > If it's a big file, and persistent connections are not enabled, I can see it > timing out form time to time. > > Russ > > >>-Original Message- >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 4:55 PM >>To: CF-Talk >>Subject: Re: from 6 to 7 >> >>Sorry, was out shoveling snow. :( >> >>Nope, this is an Access DB. I know that's not the best situation, but >>like I said, it was my first project, and it worked fine on the other >>server. >> >>And, just so it's known, I'm on a shared host, so there is no access to >>anything outside my web root, including the administrator. >> >>Ray >> >>Jim Wright wrote: >> >>>That was where I was going...I just wanted to eliminate a local db >>>like Access. I don't think this is a shot in the dark...a lot of >>>hosts out there these days are just renting equipment in others co-lo >>>facilities...and often in more than one co-lo facility. You want to >>>make sure they are not pulling your data from one datacenter to >>>anothernot just different segments of "their" network. >>> >>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: >>> >>> >>>>As well as the question other have asked about "which database" are you >>>>using, I also wonder if this server sits in a different segment of the >>>>network than the previous one. If the server and the database are >>>>further removed, they could have network issues that are causing longer >>>>delays in the calls to the database. You may want to ask if there is a >>>>database server in the same segment as your server that you could use >>>>instead of your old one. That's a shot in the dark, but you may want to >>>>research it. >>>> >>>> >>>>John Burns >>>>Certified Advanced ColdFusion MX Developer >>>>Wyle Laboratories, Inc. | Web Developer >>>> >>>> >>>>-Original Message- >>>>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>>>Sent: Monday, January 23, 2006 3:26 PM >>>>To: CF-Talk >>>>Subject: from 6 to 7 >>>> >>>>Hey all: >>>> >>>>I'm having an issue with my hosting company that I wanted to run by >>>>everyone. >>>> >>>>I've had a site up and running fine at this particular host for quite a >>>>while now. While it is not the most elegantly coded site (one of my >>>>first large projects), it works fine. To take advantage of newer >>>>hosting options (more disk space), we migrated this site from a >>>>CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the >>>>most menial database queries are sometimes timing out. Mind you, this >>>>is not occurring all the time with the same query, it seems to be >>>>happening with different queries at different times. >>>> >>>>I'm now in a debate with said host - they are telling me that it's >>>>because of my coding in general, they say I need to "upgrade" my coding >>>>to adapt to CF7. I say this is pure BS, a copout answer. From what I >>>>know, the release of CF7 was more a "features" release, so this >>>>shouldn't matter, right? >>>> >>>>Ray >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
When converting from 6 to 7, I as well experienced Problems with using MS Access even with basic queries. It came down to the drivers that was used. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:55 PM To: CF-Talk Subject: Re: from 6 to 7 Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: > That was where I was going...I just wanted to eliminate a local db > like Access. I don't think this is a shot in the dark...a lot of > hosts out there these days are just renting equipment in others co-lo > facilities...and often in more than one co-lo facility. You want to > make sure they are not pulling your data from one datacenter to > anothernot just different segments of "their" network. > > On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > >>As well as the question other have asked about "which database" are >>you using, I also wonder if this server sits in a different segment of >>the network than the previous one. If the server and the database are >>further removed, they could have network issues that are causing >>longer delays in the calls to the database. You may want to ask if >>there is a database server in the same segment as your server that you >>could use instead of your old one. That's a shot in the dark, but you >>may want to research it. >> >> >>John Burns >>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | >>Web Developer >> >> >>-Original Message- >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 3:26 PM >>To: CF-Talk >>Subject: from 6 to 7 >> >>Hey all: >> >>I'm having an issue with my hosting company that I wanted to run by >>everyone. >> >>I've had a site up and running fine at this particular host for quite >>a while now. While it is not the most elegantly coded site (one of my >>first large projects), it works fine. To take advantage of newer >>hosting options (more disk space), we migrated this site from a >>CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the >>most menial database queries are sometimes timing out. Mind you, this >>is not occurring all the time with the same query, it seems to be >>happening with different queries at different times. >> >>I'm now in a debate with said host - they are telling me that it's >>because of my coding in general, they say I need to "upgrade" my >>coding to adapt to CF7. I say this is pure BS, a copout answer. From >>what I know, the release of CF7 was more a "features" release, so this >>shouldn't matter, right? >> >>Ray >> >> >> >> >> > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
Well we all know how bad access can get under load... is it possible that they mapped it using the wrong db type? I believe CF7 introduced MS Access vs MS Access Unicode. Also are persistent connections to the db enabled? How big is the access file? If it's a big file, and persistent connections are not enabled, I can see it timing out form time to time. Russ > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 4:55 PM > To: CF-Talk > Subject: Re: from 6 to 7 > > Sorry, was out shoveling snow. :( > > Nope, this is an Access DB. I know that's not the best situation, but > like I said, it was my first project, and it worked fine on the other > server. > > And, just so it's known, I'm on a shared host, so there is no access to > anything outside my web root, including the administrator. > > Ray > > Jim Wright wrote: > > That was where I was going...I just wanted to eliminate a local db > > like Access. I don't think this is a shot in the dark...a lot of > > hosts out there these days are just renting equipment in others co-lo > > facilities...and often in more than one co-lo facility. You want to > > make sure they are not pulling your data from one datacenter to > > anothernot just different segments of "their" network. > > > > On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > > > >>As well as the question other have asked about "which database" are you > >>using, I also wonder if this server sits in a different segment of the > >>network than the previous one. If the server and the database are > >>further removed, they could have network issues that are causing longer > >>delays in the calls to the database. You may want to ask if there is a > >>database server in the same segment as your server that you could use > >>instead of your old one. That's a shot in the dark, but you may want to > >>research it. > >> > >> > >>John Burns > >>Certified Advanced ColdFusion MX Developer > >>Wyle Laboratories, Inc. | Web Developer > >> > >> > >>-Original Message- > >>From: Ray Champagne [mailto:[EMAIL PROTECTED] > >>Sent: Monday, January 23, 2006 3:26 PM > >>To: CF-Talk > >>Subject: from 6 to 7 > >> > >>Hey all: > >> > >>I'm having an issue with my hosting company that I wanted to run by > >>everyone. > >> > >>I've had a site up and running fine at this particular host for quite a > >>while now. While it is not the most elegantly coded site (one of my > >>first large projects), it works fine. To take advantage of newer > >>hosting options (more disk space), we migrated this site from a > >>CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the > >>most menial database queries are sometimes timing out. Mind you, this > >>is not occurring all the time with the same query, it seems to be > >>happening with different queries at different times. > >> > >>I'm now in a debate with said host - they are telling me that it's > >>because of my coding in general, they say I need to "upgrade" my coding > >>to adapt to CF7. I say this is pure BS, a copout answer. From what I > >>know, the release of CF7 was more a "features" release, so this > >>shouldn't matter, right? > >> > >>Ray > >> > >> > >> > >> > >> > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
Sorry, was out shoveling snow. :( Nope, this is an Access DB. I know that's not the best situation, but like I said, it was my first project, and it worked fine on the other server. And, just so it's known, I'm on a shared host, so there is no access to anything outside my web root, including the administrator. Ray Jim Wright wrote: > That was where I was going...I just wanted to eliminate a local db > like Access. I don't think this is a shot in the dark...a lot of > hosts out there these days are just renting equipment in others co-lo > facilities...and often in more than one co-lo facility. You want to > make sure they are not pulling your data from one datacenter to > anothernot just different segments of "their" network. > > On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > >>As well as the question other have asked about "which database" are you >>using, I also wonder if this server sits in a different segment of the >>network than the previous one. If the server and the database are >>further removed, they could have network issues that are causing longer >>delays in the calls to the database. You may want to ask if there is a >>database server in the same segment as your server that you could use >>instead of your old one. That's a shot in the dark, but you may want to >>research it. >> >> >>John Burns >>Certified Advanced ColdFusion MX Developer >>Wyle Laboratories, Inc. | Web Developer >> >> >>-Original Message- >>From: Ray Champagne [mailto:[EMAIL PROTECTED] >>Sent: Monday, January 23, 2006 3:26 PM >>To: CF-Talk >>Subject: from 6 to 7 >> >>Hey all: >> >>I'm having an issue with my hosting company that I wanted to run by >>everyone. >> >>I've had a site up and running fine at this particular host for quite a >>while now. While it is not the most elegantly coded site (one of my >>first large projects), it works fine. To take advantage of newer >>hosting options (more disk space), we migrated this site from a >>CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the >>most menial database queries are sometimes timing out. Mind you, this >>is not occurring all the time with the same query, it seems to be >>happening with different queries at different times. >> >>I'm now in a debate with said host - they are telling me that it's >>because of my coding in general, they say I need to "upgrade" my coding >>to adapt to CF7. I say this is pure BS, a copout answer. From what I >>know, the release of CF7 was more a "features" release, so this >>shouldn't matter, right? >> >>Ray >> >> >> >> >> > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
As a side question, does the site appear to perform slower on the new server? If not, it seems rather odd that the server times out periodically trying to connect to the database but that it doesn't act slower on regular page calls. As a quick fix, you could possibly increase the timeout time for the connection to the database. That doesn't solve the root problem, but may get it to at least stop timing out. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 4:05 PM To: CF-Talk Subject: Re: from 6 to 7 That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of "their" network. On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > As well as the question other have asked about "which database" are > you using, I also wonder if this server sits in a different segment of > the network than the previous one. If the server and the database are > further removed, they could have network issues that are causing > longer delays in the calls to the database. You may want to ask if > there is a database server in the same segment as your server that you > could use instead of your old one. That's a shot in the dark, but you > may want to research it. > > > John Burns > Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | > Web Developer > > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 3:26 PM > To: CF-Talk > Subject: from 6 to 7 > > Hey all: > > I'm having an issue with my hosting company that I wanted to run by > everyone. > > I've had a site up and running fine at this particular host for quite > a while now. While it is not the most elegantly coded site (one of my > first large projects), it works fine. To take advantage of newer > hosting options (more disk space), we migrated this site from a > CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the > most menial database queries are sometimes timing out. Mind you, this > is not occurring all the time with the same query, it seems to be > happening with different queries at different times. > > I'm now in a debate with said host - they are telling me that it's > because of my coding in general, they say I need to "upgrade" my > coding to adapt to CF7. I say this is pure BS, a copout answer. From > what I know, the release of CF7 was more a "features" release, so this > shouldn't matter, right? > > Ray > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
That was where I was going...I just wanted to eliminate a local db like Access. I don't think this is a shot in the dark...a lot of hosts out there these days are just renting equipment in others co-lo facilities...and often in more than one co-lo facility. You want to make sure they are not pulling your data from one datacenter to anothernot just different segments of "their" network. On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote: > As well as the question other have asked about "which database" are you > using, I also wonder if this server sits in a different segment of the > network than the previous one. If the server and the database are > further removed, they could have network issues that are causing longer > delays in the calls to the database. You may want to ask if there is a > database server in the same segment as your server that you could use > instead of your old one. That's a shot in the dark, but you may want to > research it. > > > John Burns > Certified Advanced ColdFusion MX Developer > Wyle Laboratories, Inc. | Web Developer > > > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 3:26 PM > To: CF-Talk > Subject: from 6 to 7 > > Hey all: > > I'm having an issue with my hosting company that I wanted to run by > everyone. > > I've had a site up and running fine at this particular host for quite a > while now. While it is not the most elegantly coded site (one of my > first large projects), it works fine. To take advantage of newer > hosting options (more disk space), we migrated this site from a > CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the > most menial database queries are sometimes timing out. Mind you, this > is not occurring all the time with the same query, it seems to be > happening with different queries at different times. > > I'm now in a debate with said host - they are telling me that it's > because of my coding in general, they say I need to "upgrade" my coding > to adapt to CF7. I say this is pure BS, a copout answer. From what I > know, the release of CF7 was more a "features" release, so this > shouldn't matter, right? > > Ray > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
As well as the question other have asked about "which database" are you using, I also wonder if this server sits in a different segment of the network than the previous one. If the server and the database are further removed, they could have network issues that are causing longer delays in the calls to the database. You may want to ask if there is a database server in the same segment as your server that you could use instead of your old one. That's a shot in the dark, but you may want to research it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, January 23, 2006 3:26 PM To: CF-Talk Subject: from 6 to 7 Hey all: I'm having an issue with my hosting company that I wanted to run by everyone. I've had a site up and running fine at this particular host for quite a while now. While it is not the most elegantly coded site (one of my first large projects), it works fine. To take advantage of newer hosting options (more disk space), we migrated this site from a CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the most menial database queries are sometimes timing out. Mind you, this is not occurring all the time with the same query, it seems to be happening with different queries at different times. I'm now in a debate with said host - they are telling me that it's because of my coding in general, they say I need to "upgrade" my coding to adapt to CF7. I say this is pure BS, a copout answer. From what I know, the release of CF7 was more a "features" release, so this shouldn't matter, right? Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: from 6 to 7
What database? -jim On 1/23/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > Hey all: > > I'm having an issue with my hosting company that I wanted to run by > everyone. > > I've had a site up and running fine at this particular host for quite a > while now. While it is not the most elegantly coded site (one of my > first large projects), it works fine. To take advantage of newer > hosting options (more disk space), we migrated this site from a > CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the > most menial database queries are sometimes timing out. Mind you, this > is not occurring all the time with the same query, it seems to be > happening with different queries at different times. > > I'm now in a debate with said host - they are telling me that it's > because of my coding in general, they say I need to "upgrade" my coding > to adapt to CF7. I say this is pure BS, a copout answer. From what I > know, the release of CF7 was more a > "features" release, so this shouldn't matter, right? > > Ray > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: from 6 to 7
What database are you using? Perhaps it's an issue with the database drivers that came with CF7. Also have you installed updater1? > -Original Message- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Monday, January 23, 2006 3:26 PM > To: CF-Talk > Subject: from 6 to 7 > > Hey all: > > I'm having an issue with my hosting company that I wanted to run by > everyone. > > I've had a site up and running fine at this particular host for quite a > while now. While it is not the most elegantly coded site (one of my > first large projects), it works fine. To take advantage of newer > hosting options (more disk space), we migrated this site from a > CF6Win2000 server to a CF7 Win2003 server. Now it seems like even the > most menial database queries are sometimes timing out. Mind you, this > is not occurring all the time with the same query, it seems to be > happening with different queries at different times. > > I'm now in a debate with said host - they are telling me that it's > because of my coding in general, they say I need to "upgrade" my coding > to adapt to CF7. I say this is pure BS, a copout answer. From what I > know, the release of CF7 was more a > "features" release, so this shouldn't matter, right? > > Ray > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230260 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54