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
1
vote
1 answer

ODAC: nvarchar column value is truncated

I am using ODAC library version 8.6.12 to connect to oracle with Delphi 6, I have a nvarchar(32) column as you can see it has a maximum of 32 characters and lets say that I always use 32 character values, e.g. "123456789-123456789-123456789-12" The…
ZORRO_BLANCO
  • 849
  • 13
  • 25
1
vote
2 answers

EF 6 + DevArt Mysql connector + MONO

It is my first expirience to deploy .net on debian. My app was created and test in win 7 vs2012 using Devart mysql connector by using database first method, after that i was started to deploy it on linux. I met a BUNCH of obstacles!! I am out of my…
NyoNor
  • 199
  • 2
  • 13
1
vote
2 answers

Why does OraNet.dcu have no corresponding .pas file?

I have a related post - Assertion failure in DBAccess.pas but thought this was worth asking separately. We are licensed for the full source-code release of DevArt ODAC but have been experiencing tremendous difficulties performing an upgrade. In the…
Hugh Jones
  • 2,706
  • 19
  • 30
1
vote
1 answer

Get an error with DevArt'sUniversal Oracle Provider but not with Microsoft's Syste.Data.OracleCleint

I am using DevArt's dotConnect Universal to connect to Oracle database. It works very well in test enviroment and also on my local machine, but when I deployed it to production, it keeps giving errors intermittently. These errrors are like ORA…
Sunil
  • 20,653
  • 28
  • 112
  • 197
1
vote
1 answer

Devart Oracle. Insert and returning ID

We are trying out the Devart Oracle adapter but are having problems with existing code that worked with the Oracle's DataAccess DLL. We get the following example error on command.ExecuteNonQuery(): ORA-01400: cannot insert NULL into …
xbrady
  • 1,683
  • 14
  • 23
1
vote
2 answers

Getting an invalid number error at random

I am using the following code with an Oracle ADO.Net provider (DevArt's dotConnect Universal). Funny thing is that it works sometimes and then most times it throws Devart.Data.Oracle.OracleException: ORA-01722: invalid number string sql = "SELECT…
Sunil
  • 20,653
  • 28
  • 112
  • 197
1
vote
2 answers

Entity Framework 4 / Devart - ORA-00904 : invalid identifier

Our intranet site stopped working over night. A short look into the errorlog showed me a EntityCommandExecutionException - An error occurred while executing the command with the inner exception Devart.Data.Oracle.OracleException - {"ORA-00904:…
csteinmueller
  • 2,427
  • 1
  • 21
  • 32
1
vote
2 answers

OracleClient to devart dotConnect for Oracle

Has anyone tried migration from Microsoft OracleClient to dotConnect for Oracle? Is it realy so easy (as they wrote at their blog http://www.devart.com/blogs/dotconnect/?p=67) or just another marketing trick? I've tried ODP.NET, but it seems to me…
lex9081
1
vote
1 answer

Alternative to DevExpress to use Entity Framework?

Recently I have been working on a website using a trial version of DevExpress with the latest version of Entity Framework, but my trial has run out. Is there a free alternative anyone knows of that I could use in it's place? I'd like to keep the…
Smoore
  • 732
  • 2
  • 10
  • 27
1
vote
1 answer

Devart Oracle Cross Apply Exception

I´m running a problem where in one machine the code works and another don´t. Apparently we´re using the same Devart dotConnect for Oracle version (6.80.325.0). The problem is when we have a subquery in the LINQ and we get Cross Apply Not Supported…
1
vote
3 answers

Entity Framework 4.4.0 code first migrations on MySql keeps adding dbo to new tables

I have setup entity framework 4.4.0 (EF5) code first migrations for a MySql database but when I run Add-Migration command I always get dbo prepended to the tablenames like so: CreateTable( "dbo.Fields", c => new …
1
vote
1 answer

How to query an Entity Framework entity for null field value with DotConnect for PostgreSQL

I observe a strange behavior when querying for null field an Entity Framework entity with the Devart DotConnect for PostgreSQL connector. For example: If I made the 2 following tests: var test1 = context.blocs.Where(x => x.id_bloc == null); var…
Etienne Desgagné
  • 3,102
  • 1
  • 29
  • 36
1
vote
1 answer

The number of members in the conceptual type does not match

I am using entity framework code first with dotConnect for MySQL, and for some reason I get an error about one of my models mapping. I've searched this error and it is usually caused by bad xml file or entity framework specific files. I am not using…
Aviran Cohen
  • 5,581
  • 4
  • 48
  • 75
1
vote
2 answers

Oracle oci.dll missing when running on MSTest agent

I'm trying to get some database related integration tests running on a MSTest test agent. We use c# and an oracle db with devart dotconnect. Since we need to use indirect mode, I installed devart and an oracle client on the test agent. The tests…
Efrain
  • 3,248
  • 4
  • 34
  • 61
1
vote
1 answer

Unable to connect to mySql database useing just code

I searched here but did not see an answer . I am using Delphi2010. I using Devart Mydac to connect to mySql data base . When i set the Server, Database, Name , Pass in the component it connects no problem. BUt when I try to connect just with code it…
grant1842
  • 357
  • 1
  • 7
  • 23