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?
|
 |
 |
eratech
Posts: 513
|
| 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 |
|
|
|
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.
|
|
|
|
eratech
Posts: 513
|
| 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 |
|
|
|
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. 
|
|
|
|
eratech
Posts: 513
|
| 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 |
|
|
|
|
