CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge -> General/Other

 CodeCharge5 not responding

Print topic Send  topic

Author Message
cagali

Posts: 10
Posted: 02/21/2014, 6:02 AM

Recently, I had installed a trail version codecharge5. Whenever I tried to select two tables using the database connection I setup, the codecharge will then not responding and force close at the end. May I know what is the problem with my codecharge?
View profile  Send private message
eratech


Posts: 512
Posted: 02/21/2014, 10:30 PM

Can't be sure from your description.

Could CCS be timing out from some problem with the Database connection? Does it work OK when selecting a single table instead of two?

I've found that when I put my project onto the 'Live Server' (ie: publishing to a live server, out on the web) that the DB connection (correctly) can't be found and will be slow. It's a subtle reminder for me to switch back to local dev, do the DB stuff, and finally publish to the live server.

Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message
cagali

Posts: 10
Posted: 02/24/2014, 6:42 PM

Hi eratech,

I try to select one table in my dev DB, which is a people Table. It consists of large records of data.

And the same thing happened when I select this table in CCS5. Below are the info I capture when the force close window prompt to me:

Description:
A problem caused this program to stop interacting with Windows.

Problem signature:
Problem Event Name: AppHangB1
Application Name: CodeChargeStudio5.exe
Application Version: 5.1.0.0
Application Timestamp: 526a6e35
Hang Signature: 7d85
Hang Type: 256
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 18441
Additional Hang Signature 1: 7d85bf1bc49caa76ab7a1b9d99c67d9b
Additional Hang Signature 2: b33a
Additional Hang Signature 3: b33a06c1854b7614ca2bf64901aad565
Additional Hang Signature 4: 7d85
Additional Hang Signature 5: 7d85bf1bc49caa76ab7a1b9d99c67d9b
Additional Hang Signature 6: b33a
Additional Hang Signature 7: b33a06c1854b7614ca2bf64901aad565

Can you help me see what is this kind of error about? Is it because of my DB connection or DB setting problem?

Extra Info:
Query I used in CCS5 to select the people Table:
SELECT *
FROM SCHEMA.PEOPLE


Thank you so much.

View profile  Send private message
eratech


Posts: 512
Posted: 02/24/2014, 10:13 PM

Unfortunately the hang errors mean nothing to me.

What database are you using (MySQL, MS-SQL etc), and when you say the People table is large - do you mean hundreds of thousands of records, or are each record got some really big columns in them?

If the later, you might hit some limits when reading them (both MySQL and MS-SQL have maximum limits for records, although they are very large limits.

Can you try a smaller table to prove that CCS works with your data, and then build up to the bigger table?

Also - do you need the 'SCHEMA' in the Query? I've seen it before for security, but it's usually the name of the schema, not the word 'SCHEMA' (eg: select * from limited.People)

Cheers

Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
View profile  Send private message
cagali

Posts: 10
Posted: 03/07/2014, 2:39 AM

Hi I had temporary find a solution. I copy the query I typed on notepad and copy over to SQL sheet on CCS5 UI. And it won't crash anymore. :-)
View profile  Send private message
eratech


Posts: 512
Posted: 03/08/2014, 12:09 AM

Good to hear it's working.

It's a good practice to be in - I usually do my SQL queries in the DB first and copy over when I'm ready to build the page. Saves a lot of mucking around.

Eric
_________________
CCS 3/4/5 ASP Classic, VB.NET, PHP
Melbourne, Victoria, Australia
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.