Telerik Forums
Community Forums Forum
0 answers
530 views

Hi,

I know this product is retired since long ago.

But in our 10 years old legacy code, we have now requirement to migrate few tables in MySQL from SQL server. This old code is using Telerik.OpenAccess Nuget version 2016.2.822.1 and there is complex business logic written using it.

It is hard to change that bulk of code to use Entity Framework, so we thought to use My SQL connector with Telerik ORM as explained here https://docs.telerik.com/data-access/developers-guide/database-specifics/database-specifics-mysql-overview

I've everything setup as per the Article above. But when I run this code, it throws error which says Connection option 'datasource' is duplicated.

The connection string is perfectly fine and nothing duplicated in it: DataSource=127.0.0.1;port=3306;database=dbname;user=root;password=******

In fact, anything I change in connection string, it complains with same kind of error. For example Server=127.0.0.1;port=3306;database=dbname;user=root;password=******

It shows Connection option 'Server' is duplicated.

Kindly please help if you have used Telerik ORM with MySQL previously.

Aron
Top achievements
Rank 2
 asked on 23 Jun 2021
0 answers
2 views
 I can't find the option, I won't be using this account anymore so I want it deactivated, probably won't be answering replies to this question either since I won't have access to the email associated anymore, so if a staff can delete the account just do it please.
Joseph
Top achievements
Rank 1
 asked on 18 Mar 2024
0 answers
3 views

I am getting this error when hosting on our application. It does not appear to happen locally.

 

We are using the new .Net 8 autorender functionality and this seems to happen only in a virtual environment. I can give more context if needed.

image

Dane
Top achievements
Rank 1
 updated question on 18 Mar 2024
1 answer
4 views
Please delete my Telerik account, it was created in error.
Nick Iliev
Telerik team
 answered on 15 Mar 2024
0 answers
23 views
Today, all of a sudden, the list of packages in the telerik nuget source is empty.  This is keeping me from building locally as well as in Azure devops.   This app is several years old and I build it several times a day and deploy to qa several times a week.  Here is the devops message similar to what I get locally.

2024-02-28T18:00:41.4616269Z Installed:
2024-02-28T18:00:41.4616442Z     88 package(s) to packages.config projects
2024-02-28T18:00:41.4938491Z ##[error]The nuget command failed with exit code(1) and error(Unable to find version '2023.3.1010' of package 'Telerik.UI.for.AspNet.Ajax.Net45'.
  https://api.nuget.org/v3/index.json: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://api.nuget.org/v3/index.json'.
  https://nuget.devexpress.com/redacted/api: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://nuget.devexpress.com/redacted/api'.
  https://nuget.telerik.com/V3/index.json: Canceled

Errors in packages.config projects
    Unable to find version '2023.3.1010' of package 'Telerik.UI.for.AspNet.Ajax.Net45'.
      https://api.nuget.org/v3/index.json: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://api.nuget.org/v3/index.json'.
      https://nuget.devexpress.com/redacted/api: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://nuget.devexpress.com/redacted/api'.
      https://nuget.telerik.com/V3/index.json: Canceled
    Unable to find version '2023.3.1010' of package 'Telerik.UI.for.AspNet.Ajax.Net45'.
      https://api.nuget.org/v3/index.json: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://api.nuget.org/v3/index.json'.
      https://nuget.devexpress.com/redacted/api: Package 'Telerik.UI.for.AspNet.Ajax.Net45.2023.3.1010' is not found on source 'https://nuget.devexpress.com/redacted/api'.
      https://nuget.telerik.com/V3/index.json: Canceled)
2024-02-28T18:00:41.4948266Z ##[error]Packages failed to restore
2024-02-28T18:00:41.4958660Z ##[section]Finishing: NuGetCommand
When I open the url, `
https://nuget.telerik.com/V3/index.json
` in a web browser and provide my creds, the returned json is there just fine

This happened back on 1/26/2024 as well, and then it seemed to magically heal itself.  But I have to do a production deployment today and this is holding me up.
Doug
Top achievements
Rank 1
 asked on 28 Feb 2024
0 answers
13 views

Hello there.

I'm presently working on a Node.js project that uses Telerik and MongoDB with Mongoose for database operations, however I'm having trouble quickly implementing CRUD (Create, Read, Update, Delete) actions. I'm hoping to receive some ideas and advice from the community to help us overcome these obstacles and enhance our database interactions.

Scenario Overview:

In our Telerik-based Node.js application, we use MongoDB as our database solution, with Mongoose as the MongoDB object modeling tool. Our application manages a variety of entities and data collections, and we must use CRUD operations to create, read, update, and remove data entries in MongoDB.

The code sample below demonstrates our current method to implementing CRUD operations using Mongoose and MongoDB in our Telerik Node.js application. Take a look, and let's go into the complexities of database interactions using Mongoose and MongoDB.


// Sample code demonstrating CRUD operations with Mongoose and MongoDB in Telerik
const mongoose = require('mongoose');

// Connect to MongoDB database
mongoose.connect('mongodb://localhost:27017/mydb', { useNewUrlParser: true, useUnifiedTopology: true });
const db = mongoose.connection;

// Define Mongoose schema and model
const userSchema = new mongoose.Schema({
    name: String,
    email: String,
    age: Number
});

const User = mongoose.model('User', userSchema);

// CRUD operations
// Implement CRUD operations using Mongoose model methods
// ...

Key Points of Concern:

Model Schema Design: Creating effective Mongoose schemas to describe our data models and build relationships among distinct things in the MongoDB database. How can we optimize our schema design to maintain data consistency and integrity while allowing for complicated data structures?

Implementing CRUD operations (Create, Read, Update, and Delete) with Mongoose to interface with MongoDB collections. How can we simplify the implementation of CRUD procedures to ensure speedy and error-free database interactions?

Data validation and error handling: Putting in place measures to assure data integrity and prevent incorrect data from being put into the database. How can we apply data validation rules and gracefully manage mistakes during CRUD operations?

Performance optimization entails optimizing database queries and processes to increase performance and scalability, as described in the documentation. How can we use Mongoose query optimization and MongoDB indexing algorithms to improve the speed of CRUD operations in our Node.js application?

Let's work together to overcome these CRUD operations difficulties!

Thanks

jhonson
Top achievements
Rank 1
Iron
Iron
 asked on 25 Feb 2024
1 answer
13 views

Dear Kendo Experts,

I hope this message finds you well.

I am currently facing an issue with custom validation error messages in a Kendo Grid. I have created a sample Dojo link to demonstrate the problem:

https://dojo.telerik.com/IgOLaREr

I have a kendo grid with a custom editor (dropdownlist) for a column (Category). 

In the provided Kendo Grid, I have two columns: "ProductName" and "Category". While "ProductName" has a default editor, "Category" has a custom editor (dropdown list).

I have defined custom validation error messages for both columns in the schema. However, the custom validation error message for the "Category" column does not appear when validation fails, unlike the "ProductName" column. Please refer the below screenshot.

Could you please assist me in resolving this issue? I would like the custom validation error message for the "Category" column to be displayed when validation fails, similar to the "ProductName" column.

Thank you very much for your time and assistance. I look forward to hearing from you soon.

Best regards,

Varun Shridhar.

Neli
Telerik team
 answered on 23 Feb 2024
0 answers
18 views

Hello,

Although Telerik is awesome I wish to delete my Telerik account, Telerik Forums account and all of the data associated with this account. Please help me out with this.

 

Thanking You,

With Regards,

Missing User
 asked on 21 Feb 2024
0 answers
10 views

你好!

我想知道如何删除我不久前为了下载试用版而必须创建的 telerik 用户帐户。不幸的是,我找不到任何关于如何做到这一点的提示。

任何帮助表示赞赏。
提前致谢!

asd
Top achievements
Rank 1
 asked on 20 Feb 2024
0 answers
13 views

I'm currently fine-tuning a project that involves MySQL and Telerik, and I've hit a roadblock when it comes to understanding the nuances between CHAR and VARCHAR. Specifically, I'm interested in how these choices may impact UI development with Telerik controls. Can someone help me decode these intricacies?

Let's start by sharing a CodeIgniter model snippet and MySQL table structure:


class Customer_model extends CI_Model {
    public function add_customer($customer_id, $customer_name, $email) {
        $data = array(
            'customer_id' => $customer_id,
            'customer_name' => $customer_name,
            'email' => $email
        );

        $this->db->insert('customers', $data);
        return $this->db->insert_id();
    }
}



CREATE TABLE customers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id CHAR(8),
    customer_name VARCHAR(50),
    email VARCHAR(255)
);

Question 1: CHAR vs. VARCHAR in MySQL
I've opted for CHAR(8) for customer_id and VARCHAR(50) for customer_name. Could someone shed light on the primary distinctions between CHAR and VARCHAR in MySQL, particularly concerning storage efficiency and how these choices might influence Telerik controls used in UI development?

Question 2: Telerik and MySQL Integration
Considering Telerik controls in the UI development landscape, are there specific considerations when working with VARCHAR fields like customer_name or email in MySQL? How do these considerations align with best practices for Telerik UI components, and are there potential pitfalls to be mindful of during integration?

Question 3: Effective Data Handling using Telerik.
In the context of data transmission between MySQL and Telerik, as seen here, how does the decision between CHAR and VARCHAR affect the effectiveness of data retrieval or processing within Telerik controls? Are there any ideas or best practices for managing variable-length fields in Telerik UI components?

Question 4: The impact on Telerik Grids and Forms.
Finally, when developing Telerik Grids or Forms, how do the MySQL data types used effect the layout, performance, and validation? Are there any special obstacles or benefits to using CHAR or VARCHAR fields in MySQL when working with Telerik UI components?

Your expertise on these questions will be invaluable as I strive for a seamless integration of MySQL data and Telerik controls in my UI development. Thanks a bunch for sharing your insights!

jhonson
Top achievements
Rank 1
Iron
Iron
 asked on 30 Jan 2024
Narrow your results
Selected tags
Tags
+? more
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?