Questions tagged [devart]

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird, and SQLite.

Devart is a software development company specializing in native data access solutions, tools and database tools for the most popular databases, including:

  • MS SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • InterBase
  • Firebird
  • SQLite.

We try to provide high-end products to let you have the fastest data access and the broadest database support.

386 questions
0
votes
1 answer

Devart LinqConnect for mysql A field initializer cannot reference the non-static field, method, or property

I couldn't solve this problem after linqConnect For Mysql generated entity of models for me. I thought devart is good software, without testing trial period, I purchased their license, but now I am facing this issue, I couldn't even get it working.…
Steven Li
  • 754
  • 1
  • 8
  • 16
0
votes
0 answers

Issues connecting to Oracle server via Oracle Instant Client. When to use 32bit vs 64bit?

I have issues to connect to Oracle Server (10g) 32bit running on a Windows Server 2008 R2 (x64), from a remote computer using Oracle Instant Client (11.2.0.4) 64bit which runs Windows 10 Home (x64). The error message I get is "Underlying provider…
Learner
  • 3,297
  • 4
  • 37
  • 62
0
votes
0 answers

visual studio 2015: could not load odp.net when dotConnect for Oracle installed

I have ODP.NET installed using ODAC 32bit on a machine with Devart dotConnect for Oracle installed. http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html Got the error when adding a ADO.NET Entity Data Model...\New Connection: Click…
beewest
  • 4,486
  • 7
  • 36
  • 63
0
votes
1 answer

Devart dotConnect for Oracle in Visual Studio 2015 - compatibility problems

Visual Studio 2015 is now supported as well for dotConnect. The setup file SetupODTforVS2015.exe was released in Oct 2015 (download here). I'm using oracle version 8.4 and Visual Studio 2015 and would like to get Oracle Developer Tools. The…
LM358
  • 141
  • 9
0
votes
1 answer

Setting Authentication type SFTP connection delphi

I am using devart SecureBridge to create a connection over SFTP and I am having trouble setting the authentication type on the SSHClient. When i try without it gives me an exception: 'The negotioation of host key algorithm is failed'. I guess it's…
Matt Baech
  • 404
  • 11
  • 23
0
votes
2 answers

Suggestions for caching a dataset

I'd like to perform the following: 1) Open a dataset (using TMSQuery, SDAC DevArt component) 2) caching the content to disk (imagine a list of cutsomers) 3) the next time I need to Open the dataset I will first populate it with cached data, then I…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
0
votes
0 answers

.Net error : Attempted to read or write protected memory

I decide to post my question here after many unsucessful research. I have an error on my application when i generate a report. I didn't have the problem when i'm debugging on visual studio but when i deploy on my server (windows server 2012) i have…
Fonzzy
  • 44
  • 4
0
votes
1 answer

Handling NOTICE events from PostgreSQL in a separate thread in Delphi with Devart's PgDAC components

I want to execute long queries in a separate thread in order to be able to abort them and also to give feedback to the users. All of this is working but I sometimes get Access Violations because, I think, the processing of the OnNotice events is not…
JC Boggio
  • 367
  • 1
  • 11
0
votes
1 answer

How to see the SQL generated by Entity Framework when using an Oracle database?

I'm using devArt dotConnect to talk to an oracle 11g database. In another project with SQL Server it was very easy to see the SQL that was generated using the debugging tools from Visual Studio. However this doesn't seem to work when the database is…
paddingtonMike
  • 1,441
  • 1
  • 21
  • 37
0
votes
1 answer

Runtime error while creating database context using dotConnect and Entity Framework 6

We're using DevArt dotConnect to connect to an Oracle backend. Our previous dev machines have all used dotConnect 8.4.254.4, which is what's checked into Subversion. I've set up a new dev machine and installed the newest version, which is…
Mike Christensen
  • 88,082
  • 50
  • 208
  • 326
0
votes
1 answer

Devart ChangeConflictException but values still written to database

I have an intermittent Devart.Data.Linq.ChangeConflictException: Row not found or changed raising it's ugly head. The funny thing is, the change is still written to the database! The stack trace says: Devart.Data.Linq.ChangeConflictException: Row…
Ian
  • 1,475
  • 2
  • 15
  • 31
0
votes
1 answer

Error when using Dapper and Devart driver together to connect to Oracle

I am trying to do a simple select from a Oracle table with Dapper using the Devart driver using (var sqlConnection = new Devart.Data.Oracle.OracleConnection(cs)) { sqlConnection.Open(); var sql = @"SELECT ""AnalasisId"" = @AnalasisId,…
Mech0z
  • 3,627
  • 6
  • 49
  • 85
0
votes
0 answers

Why inherit from EntityObject?

I'm using "Devart Entity Developer" to model my database for Entity Framework. Why are my classes inheriting from EntityObject? I cannot see in any Entity Framework documentation that this is either required nor best practice. This is an example of…
Annish
  • 2,145
  • 1
  • 14
  • 15
0
votes
0 answers

How solve this erro I Get error concurent update? Firebird 3.0 Devart Ibdac

Need help me how solve this problem I Get error concurent update? Delphi Unigui Web application master detail cacheupdatemode I have MainConnection ReadTransaction isolation :ReadCommited WriteTransaction isolation :Snapshot masterqry…
Good Bit
  • 23
  • 6
0
votes
1 answer

Tasks with new Devart backed DbContexts raise errors

I have been pulling my hair on this one for a while now: When i use the DbContext backed by the Devart DB2 provider in several tasks i get a NullReferenceException with the following stacktrace: at Devart.Data.DB2.DB2ParameterCollection.Clear() at…
Erik Karlsson
  • 570
  • 1
  • 6
  • 17