This is a migrated thread and some comments may be shown as answers.

Error when attempting to upgrade

2 Answers 151 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
cayates
Top achievements
Rank 1
cayates asked on 17 Nov 2008, 07:23 PM
I am getting a table or view cannot be found error after upgrading to telerik.  I turned on logging output and see it's because the new version is putting quotes arround voa_keygen.  The previous version did not so it was not case sensitive, however, now it is because of the quotes.

I tried accessing the backend configuration dialog that used to be there but the only menu options I have are "Launch Telerik ORM Wizard" and "Enable Project to use ORM".  I tried running the enable project wizard and it finishes succesfully but the menu options don't change.

When I right click in the project and try to expand the "Open Access" menu on the popup menu it just shows a blank sub-menu.

Any help on how to get to the backend configuration and modify the keygen table name would be great.

Thanks,

Chris

2 Answers, 1 is accepted

Sort by
0
cayates
Top achievements
Rank 1
answered on 17 Nov 2008, 08:16 PM
As a follow up, I would also like to mention that I found that I could add:

<ext.db-key-generator.keyColumnName>VOA_KEYGEN</ext.db-key-generator.keyColumnName>

but it also puts double quotes around the column names as well, so it complains that the "last_used_id" and "table_name" column can't be found.  I see there's a way to specify the column name for "table_name" but I don't see the option for the "last_used_id" column name.  Even if I could I fear that I'm going to keep running into this case sensitivity problem.  So I need a way to turn off Telerik's use of the double quote in the generated SQL.

Thank you,

Chris
0
Accepted
Thomas
Telerik team
answered on 18 Nov 2008, 03:34 PM
Hi Chris,

the default highlow key generator can be configured in the backend section with

<ext.db-key-generator.keyColumnName>table_name</ext.db-key-generator.keyColumnName>
<ext.db-key-generator.valueColumnName>last_used_id</ext.db-key-generator.valueColumnName>
<ext.db-key-generator.tableName>voa_keygen</ext.db-key-generator.tableName>

so you can control all names used.

But what you seem to need is to turn off the delimiting of identifiers, which is a different backend setting:

 <useDelimitedSQL>False</useDelimitedSQL>

You can only turn it off, and when done so, there will be no delimitation been done in the SQL generated.

Hope this helps,
Thomas
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
General Discussions
Asked by
cayates
Top achievements
Rank 1
Answers by
cayates
Top achievements
Rank 1
Thomas
Telerik team
Share this question
or