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
1 answer
5 views

I am using telerik version 2014.3.1024.45 with Asp.Net Webforms

I am using Telerik RadGrid. Columns are being sorted using string value. However if a particular column has integer values, it fails to sort properly. E.g. For the values 0, 1, 10, 2, 12, 3   It will sort as 0, 1, 10, 12, 2, 3

I tried setting 
DataType="System.Int32"   for column but still it considers as string. This column has on the fly values so I can not sort at database also.

Would appreciate any suggestion here. Is there any way to do it ? 

Thanks In advance

Attila Antal
Telerik team
 updated answer on 14 Mar 2024
1 answer
6 views

I am currently experiencing an I/O exception when trying to export the RadDocument to a byte array using the Telerik.Windows.Documents.FormatProviders.Pdf.PdfFormatProvider.

Here is a code snippet of how am I using the Provider:

PdfFormatProvider pdfProvider = new PdfFormatProvider();

_printReportByteArray = pdfProvider.Export(_printReportDocument);

using (var memoryStream = new MemoryStream(_printReportByteArray))
{
    this.PrintReportViewer.DocumentSource = new PdfDocumentSource(memoryStream);
}

The exception occurs at

pdfProvider.Export(_printReportDocument)

It appears that the provider is trying to load the font file from the Windows directory, but for some reason this particular file is causing the exception randomly on certain machines (not on all machines). I would like to know if there is a way to resolve this issue. Like loading the font file into the memory instead of relying on the Windows directory.

Note: the font file does exist at the provided path location, and is not missing.

Here is the full exception message:

System.IO.IOException: I/O error occurred while opening the file "C:\WINDOWS\FONTS\MSYH.TTC".
   at MS.Internal.FontCache.FileMapping.OpenFile(String fileName)
   at MS.Internal.FontCache.FontSource.GetUnmanagedStream()
   at System.Windows.Media.GlyphTypeface.ComputeSubset(ICollection`1 glyphs)
   at Telerik.Windows.Documents.FormatProviders.Pdf.Fonts.GlyphMappings.ComputeSubset(PdfFontKey key, ICollection`1 glyphs)
   at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfFontFile2.CreateFileFontFile()
   at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfFontFile2.WriteContents(PdfWriter writer)
   at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfStream.WriteToCore(PdfWriter writer)
   at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfObject.WriteTo(PdfWriter writer)
   at Telerik.Windows.Documents.FormatProviders.Pdf.RadPdf.PdfWriter.WritePdfObject(PdfObject obj)
   at Telerik.Windows.Documents.FormatProviders.Pdf.PdfDocumentExporter.Export()
   at Telerik.Windows.Documents.FormatProviders.Pdf.PdfFormatProvider.Export(RadDocument document, Stream output)
   at Telerik.Windows.Documents.FormatProviders.DocumentFormatProviderBase.Export(RadDocument document)
   at Cairful.Desktop.Module.Care.NursingReports.NursingReports.Dialogs.PrintReportsDialogVM.PrintReportDocument()
   at Cairful.Desktop.Module.Care.NursingReports.NursingReports.Dialogs.PrintReportsDialog.PrintReportsDialog_OnLoaded(Object sender, RoutedEventArgs e)
   at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
   at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
   at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
   at System.Windows.UIElement.RaiseEvent(RoutedEventArgs e)
   at System.Windows.BroadcastEventHelper.BroadcastEvent(DependencyObject root, RoutedEvent routedEvent)
   at System.Windows.BroadcastEventHelper.BroadcastLoadedEvent(Object root)
   at MS.Internal.LoadedOrUnloadedOperation.DoWork()
   at System.Windows.Media.MediaContext.FireLoadedPendingCallbacks()
   at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
   at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
   at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)


Dess | Tech Support Engineer, Principal
Telerik team
 answered on 04 Mar 2024
3 answers
27 views
Hello!

I would like to know how to delete the telerik user account I had to create in order to download a trial version a while ago. Unfortunately, I couldn't find any hints on how to do this. :-( Maybe someone here can help me to remove the account?

Any help appreciated.
Thanks in advance!
Missing User
 answered on 29 Feb 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
1 answer
9 views
 I am attempting to incorporate a data source parameter and a report parameter to create a parameterized query. I am certain my report parameter has values and can pass the correct value and data type I went (I create a text box to display the report parameter value and it did so correctly. However, the moment I then change my SQL query to include the parameter and then make the data source parameter equal to the value of my report parameter it does not work as intended.  Once I set the data source parameter value equal to the report parameter value and hit preview all available parameter value options disappear and nothing loads. 
Momchil
Telerik team
 answered on 26 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
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?