pcdoctor
Posts: 15
|
| Posted: 11/11/2008, 11:48 AM |
|
Hello all. I have the following problem:
I'm trying to re-design a system with CCS4 - 4.01. I create/use my connection accordingly, but when I try to use the table than contains the Account Details for the Login page, not all the columns are listed. My original project is fine, and all the columns list etc. Even if I use a builder to add a new grid.
No matter wether I use the builder or blank project, I can't get all the columns listed in this new project. This holds true for all the tables - some columns are simply not displayed.
The DSN has the all the correct connection details and the account that I am using to connect to my SQL2K5 database has the appropriate SQL permissions.
I've tried using SQL Native Client and SQL Server connections The result is the same.
So, my question is why cannot I not list all the columns? This used to work some time ago when I first created my original project.
Thanks.
|
 |
 |
Gena
Posts: 591
|
| Posted: 11/11/2008, 1:19 PM |
|
Are you sure that you use the correct source? I mean may be you use some old version of you DB, check it.
Also check this: if you have selected some fields in VQB then you will see just these fields. To see all fields - check first checkbox for the table in VQB (that means * - all fields)
_________________
Gena |
|
|
|
melvyn
Posts: 333
|
| Posted: 11/11/2008, 2:18 PM |
|
Are you using a trial ? A cracked one?
Some behavior like that one is typical. If your installation is correct, contact support.
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/11/2008, 2:25 PM |
|
Quote Gena:
Are you sure that you use the correct source? I mean may be you use some old version of you DB, check it.
Also check this: if you have selected some fields in VQB then you will see just these fields. To see all fields - check first checkbox for the table in VQB (that means * - all fields)
Hi Gina, yes I've checked and double checked the ODBC DSN, the DB is correct. I've confirmed this with and ASPmaker and ASPrunner, they are fine.
I'm sorry, but I'm not sure what you mean by VQB? Here are my steps:
1) Add new Connection: a) Name it, b) SQL Server, select DSN, c) enter credentials,
2) Advanced: a) Select Catalog, b) deselect everything else (Views, Synonyms etc),
3) Server Tab, Data format, Boolean,
4) Disable "Auto Increment", leave everything else alone,
That's it.
In this DB, I have 16 tables, only 6 are displayed when I get to the Security Page to create a Login Page. On this page, I select Accounts (which contains all the info for the account: Login_ID, Password, user_Level etc). I can only see 5 columns listed, none of which has Login_ID, Password which I need to create the login page).
Also, as mentioned I can load a previous project and all is well. I checked the config for this project (in so far as connections etc) and they are the same. They use the same DSN, credentials etc.
Thanks.
|
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/11/2008, 2:28 PM |
|
Quote melvyn:
Are you using a trial ? A cracked one?
Some behavior like that one is typical. If your installation is correct, contact support.
No trial, and certainly not a cracked version. The company I work for bought this some time ago and we've not upgraded or anything. We didn't see a need to do so.
I understand the idea about contacting support, but the underlying issue still is, why does our previous project work just fine and this new one won't? By this I mean, in the orginal project, I just added a New Test Page to simply list all the details from the Accounts DB with no problem.
Thanks.
|
|
|
|
melvyn
Posts: 333
|
| Posted: 11/11/2008, 2:59 PM |
|
Quote pcdoctor:I'm sorry, but I'm not sure what you mean by VQB?
VQB = Visual Query Builder
It refers to the window which appear when you edit a form and click on "DataSource", the same which appear when you go to Application builder. It's the "form wizard" or "form assistant" launched by Application Builder, from builder or record builder....
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
Gena
Posts: 591
|
| Posted: 11/11/2008, 3:03 PM |
|
melvyn, yes, exactly.
pcdoctor, check there if you have SELECT * from table .....
_________________
Gena |
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/11/2008, 3:38 PM |
|
Quote melvyn:
Quote pcdoctor:I'm sorry, but I'm not sure what you mean by VQB?
VQB = Visual Query Builder
It refers to the window which appear when you edit a form and click on "DataSource", the same which appear when you go to Application builder. It's the "form wizard" or "form assistant" launched by Application Builder, from builder or record builder....
I'm sorry folks, I need to detail my issue more accurately. My bad...
In the scenario in my post I should more accurately have indicated; I'm simply launching CCS4 and using the App Builder from start. I should not have used the term redesigning as it implies a rework of the same project.
However let's bear in mind, that I can load my original project and do everything that I used to be able to do, in fact I used the grid builder to create a "Test/Dummy" grid. No problem.
So here is a more accurate descrition of what I'm attempting to do:
1) Launch CCS4,
2) Create "New" project and use the "App Builder" wizard. I get to the Authentication Builder (step 4/9) and this is where some of the tables are missing and some of the columns for the tables that I can see are missing.
So, I cancelled and started from scratch again. I created no project, just in the IDE. Then I started to create a Project and add a new connection. The connection wizard walks me thru everything, but when I get to the Authenticaion Builder I can't see all my tables, nor do I see all the columns for the tables that I can see. For example, my Accounts Table has 21 columns, I can only see 11. None of which are the ones that I need.
I appologize for the incomplete/inaccurate information.
Additional information: I've disabled my anti-virus software and made sure that nothing obtuse or invasive is running.
I've just recently removed CCS4 and re-installed, thinking that over time something was installed on my system which is causing the issue. But alas, the same thing.
It's not a complete crippler as I can manipulate the original project, which I don't really want to do.
So now I'm wondering, can I download the latest and greatest and run a parallel install? More so to see if it's something with this version and my system more than anything else.
Thanks for all the assistance and guidance.
BTW: Thanks for the clarification of VQB, appreciated.
|
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/11/2008, 8:13 PM |
|
AH!!! Got it figured out. Now all is well.
It is a CCS4 issue with SQL2K5 and Native Client connections.
I want to thank a direct contributor for pointing me in the right direction.
As her email suggested - look to security!
Cheers. 
|
|
|
|
mamboBROWN
Posts: 1713
|
| Posted: 11/12/2008, 4:54 AM |
|
pcdoctor
Could you please put [RESOLVED] or [SOLVED] in your thread title. Thanks.
|
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/12/2008, 5:07 AM |
|
Quote mamboBROWN:
pcdoctor
Could you please put [RESOLVED] or [SOLVED] in your thread title. Thanks.
Normally I would put something in the title, but I wanted to make sure that the fix did indeed resolve the issue.
The email I rec'd suggested that the SQL port should be set to auto, not explicitly set to 1433 which mine was.
It looked like it was fixed. Well, the problem is back. I managed to run it fine once, then all of a sudden it stopped working again.
I'm at a loss.
|
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/12/2008, 7:12 AM |
|
Well, we couldn't figure it out so we've downloaded v4.1.00.027 from the web site. However, it says "Trial Period has expired".
I removed my previous version, so how can I enable this trial period?
I really suspect something got broke with my version as I've obviously installed software over the years. Most particularly RegFix and SQL2K5.
I think this would confirm it that theory.
Again, thanks to everyone for the input and suggestions. I realize that trying to "Fix" something like this via forum communications is difficult to say the least. So the effort put forth here is very encouraging.
Thanks.
|
|
|
|
melvyn
Posts: 333
|
| Posted: 11/12/2008, 7:31 AM |
|
Sorry pcdoctor
As I told in my first answer, that appear to be related to a cracked installation. CCS have coded everything very serious. There are some post regarding this issue: when is a cracked ccs, some buggy behavior come to the IDE.
Contact support to reactivate your installation.
Cheers.
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/12/2008, 7:59 AM |
|
Hi melvyn. As mentioned, we purchased this some time ago, it is not a cracked version but I certainly do see that there could be issues with cracked flavors. Anyway, I fired up my laptop (remembering that I had a copy on it) and it worked just fine. Created new pages, ran several builders with no problem.
So there is clearly something on my tower system that caused this issue.
Anyway, I cleaned out the registry on my tower and re-installed the new version and entered Trial Version for the SN. No problem with the trial version now. So I think I'm going to play with this new version and upgrade if it offers something significant.
I do thank you and everyone else for the assistance.
|
|
|
|
melvyn
Posts: 333
|
| Posted: 11/12/2008, 10:35 AM |
|
Well, no ofense about which I told above. Please note this:
Registry cleaners aren't as good they says (and people believe). Lot of them search for "invalid keys" or keys with no related info, or doubt info. and delete them. Some of those keys can be serials and activations stored in some hidden branch of the registry.
My advise is: some registry cleaner can be a disaster for some programs which requires sensitive information from registry.
Let's say: There's no registry cleaner wich knows exactly which key is set by Yes Software and which key is set by me and by you. When some installed software wich depend on those deleted keys find they aren't, the software can recreate them, or ignore. Some software can stop working.
Understood?
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
pcdoctor
Posts: 15
|
| Posted: 11/12/2008, 11:03 AM |
|
Quote melvyn:
Well, no ofense about which I told above.
No problem.
Quote melvyn:
When some installed software wich depend on those deleted keys find they aren't, the software can recreate them, or ignore. Some software can stop working.
Understood?
Generally agreed and not to be argumentative, however, being a Systems Engineer with over 25 years experience , I can tell you that many registry cleaners actually do work and work very well. In particular, if they take snapshots of the registry and when an uninstaller such as CCS4 says it cannot remove keys from HKCU and recommends removing them manually, for example, it's a pretty straight forward process. After all, the registry is nothing more than a heirarchal jet db.
This cleaner actually asks you to search for strings, data etc and allows one to selectively remove entries. I've been using this particular cleaner for about 3 years with no ill effects.
Having said the above, some are dangerous and can be disasterous. Not withstanding your comments, this is not a forum for discussing cleaners, but your point is well worth mentioning.
Again, no offence regarding the cracked copy etc
Cheers.
|
|
|
|
|
