CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> IDE/GUI

 is anyone else having hanging or "not Responding" with 3.2

Print topic Send  topic

Author Message
londo58

Posts: 10
Posted: 01/08/2008, 1:03 AM

I am using MySQL as my database and anytime I try to connect to the database or modify one of the database settings it is crapshoot on whether CCS will hang.

I experienced this with SQL Server 2000 (and MySQL) as well with CCS 3.1 Lite

that is why I upgraded to 3.2 Pro or enterprise

my desktop is a dual xeon with 3 gb of memory running windows server 2003 - if this helps

any ideas would be greatly appreciated
View profile  Send private message
Aaron


Posts: 145
Posted: 01/08/2008, 12:56 PM

I find I have that issue when the data set I'm querying against is large or the SQL is complicated. Other than that, it runs about the same as any other Windows-based program :*)
View profile  Send private message
londo58

Posts: 10
Posted: 01/08/2008, 4:52 PM

trust me, I have never had any windows program hang this much - my dataset is small and SQL relatively simple - it still has problems

if I had the CCS source code I would fix it myself and a few other nits - I would take time off to fix these things just so I would not be so frustrated

to be fair, I have almost asked for a refund - it is that frustrating - the only thing holding me back is - I like the concept and like the tool, just wished it worked better
View profile  Send private message
datadoit
Posted: 01/09/2008, 6:06 AM

Does it 'hang' when you set up your ODBC Datasource or test the
connection from your ODBC Datasource settings?
londo58

Posts: 10
Posted: 01/09/2008, 11:34 AM

it hangs from either one or if I try to change a property in CCS on one of the web pages

for example -
changing from visible Yes to no - hangs
changing a column name from orginal "A" to one in picklist - hangs
if I need to change table name from "A" to another one - hangs

i have experienced using My SQL and MS SQL SERVER 2000/2005
View profile  Send private message
datadoit
Posted: 01/09/2008, 12:02 PM

londo58 wrote:
> it hangs from either one or if I try to change a property in CCS on one of the
> web pages
>
> for example -
> changing from visible Yes to no - hangs
> changing a column name from orginal "A" to one in picklist - hangs
> if I need to change table name from "A" to another one - hangs
>
> i have experienced using My SQL and MS SQL SERVER 2000/2005
> ---------------------------------------

If it's hanging in your Windows ODBC Datasources, then it's not a CCS
issue, but rather something else.

Just to toss something obvious out there.... check your firewall settings.
londo58

Posts: 10
Posted: 01/09/2008, 12:35 PM

the firewall is and has been disabled

are you saying that the property changes visible yes to no is also database related???

Note: I have experienced this on another machine using an eval copy of CCS
View profile  Send private message
datadoit
Posted: 01/09/2008, 7:15 PM

Sounds like you've got quite a pickle that'll require a call to Yes
Software support or submit through the online ticket system.
csydow


Posts: 22
Posted: 01/10/2008, 2:57 AM

I have the same type of thing happen - when I click on "Data Source" in the Properties panel (which obviously I have to do a lot); well, about 66% of the time CCS (3.2) hangs and I must force quit the application.

I am using mySQL/.asp (mySQL DB is on my computer); computer XP2 SP2; 3 GB RAM

I say a little prayer right before I click, LOL...frustrating, because it takes me twice as long to do stuff.
View profile  Send private message
wkempees


Posts: 1679
Posted: 01/10/2008, 4:51 AM

To both:
- is database running on same machine (local) or on other machine(remote)?
- check the acces through odbc using a different front end, i.e. Not CCS.
my setup XP SP2 all hotfixes, XAMPP local environment No such problems.


_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
londo58

Posts: 10
Posted: 01/10/2008, 2:14 PM

The ODBC interface works fine with other products either local or remote

I am currently using MyODBC 3.51.16 driver

all of the latest patches and updates have been applied to W2K3

remember this has also failed with SQL Server for me

you didnt say what environment worked for you - local? or remote? or both?
View profile  Send private message
datadoit
Posted: 01/10/2008, 4:16 PM

May not be related, but try turning off AutoComplete (Tools -> Options
-> General).
londo58

Posts: 10
Posted: 01/10/2008, 6:51 PM

already turned off Autocomplete - it didnt help
View profile  Send private message
wkempees
Posted: 01/11/2008, 3:35 AM


"londo58" <londo58@forum.codecharge> schreef in bericht
news:4478698cd1f3f6@news.codecharge.com...
> The ODBC interface works fine with other products either local or remote
>
> I am currently using MyODBC 3.51.16 driver
>
> all of the latest patches and updates have been applied to W2K3
>
> remember this has also failed with SQL Server for me
>
> you didnt say what environment worked for you - local? or remote? or both?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

Using ODBC only local.
Published application will directly connect to MySQL.
In other words I never use ODBC on a remote database.
If you are using local too, I imagine Server 2003 as a development platform
might require some different settings as to user policy or so.
I would suggest to contact support.

londo58

Posts: 10
Posted: 01/11/2008, 5:32 PM

my user id on this server is administrator - so it has every ability enabled

I have contacted support, but am awaiting a patch for debugging purposes or a version file from them that my agent created so that I can compare machines software levels
View profile  Send private message
csydow


Posts: 22
Posted: 01/12/2008, 4:04 AM

Just performed a test to try to solve problems I've been having.

I created a grid with two connections:
#1 using ODBC Data Source (DSN)
#2 using just connection string (DSN-less)

I switched between the two numerous times and clicked on the Data Source for the grid in the property panel. Never did it hang using DSN-less. However, it hung up 50% of the time while using DSN (requiring me to force quit the app).

It's only one test, but I for one am going to DSN-less for now!
View profile  Send private message
DonB
Posted: 01/12/2008, 5:32 AM

Sounds like you might have ODBC tracing turned on. I've had it turned on
and forgotten to turn it off, and the log file grows to be huge and
eventually grinds things to a halt.

http://support.microsoft.com/default.aspx/kb/274551

That would explain why the connection speeds up with DSN-less, because you
aren't using the DSN that has tracing enabled on it.
--
DonB

http://ccswiki.gotodon.net


"csydow" <csydow@forum.codecharge> wrote in message
news:44788ace576b78@news.codecharge.com...
> Just performed a test to try to solve problems I've been having.
>
> I created a grid with two connections:
> #1 using ODBC Data Source (DSN)
> #2 using just connection string (DSN-less)
>
> I switched between the two numerous times and clicked on the Data Source
> for
> the grid in the property panel. Never did it hang using DSN-less. However,
> it
> hung up 50% of the time while using DSN (requiring me to force quit the
> app).
>
> It's only one test, but I for one am going to DSN-less for now!
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>

csydow


Posts: 22
Posted: 01/12/2008, 5:47 AM

No, I do not have ODBC tracing turned on!
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.