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 Entity Developer Can't See Certain Picklist Fields

I'm having a problem seeing certain picklist fields from a Standard Salesforce table called Lead in my Devart Entity Developer Model. I am unable to see the below item in the Model I generate using Devart. Lead.Status_Reason is a Picklist and IS…
Tim
  • 1,249
  • 5
  • 28
  • 54
0
votes
1 answer

Unable to connect to Sybase15.7 :Cannot connect to server on host 'localhost': Permission denied

I''m connecting PHP7 with Sybase15.7 using Devart drivers in RedHat Linux and getting the following error. ** SQLSTATE[08001] SQLDriverConnect: 0 [unixODBC][Devart][ODBC][Adaptive Server Enterprise] Cannot connect to server on host 'localhost': …
Raja Shekhar
  • 31
  • 1
  • 5
0
votes
1 answer

The Type spatial_geometry is not qualified with a namespace or alias. Only primitive types can be used without qualification

We've got an existing solution that uses EF5 and DevArt's dotConnect for PostgreSQL to connect to a PostgreSQL 9.4 database, and generate the entities. I just installed Visual Studio 2013, and the dotConnect for PostgreSQL provider, and pulled the…
0
votes
0 answers

DataServiceException on using Devart Oracle provider with OData

I am using Devart Oracle driver calling it using OData endpoint. On one of the environments I am getting an error: Data service failure. An exception was thrown of type DataServiceException. Message: Internal Server Error. The type…
Nick
  • 798
  • 1
  • 7
  • 14
0
votes
2 answers

DevArt dotConnect for Oracle - how to do a WHERE LIKE clause with a parameter?

How do I do a WHERE COLUMN LIKE '%SearchTerm%' with the DevArt dotConnect for Oracle libraries? Ideally using a CommandParameter for the SearchTerm? I've tried the following with no joy: cmd.CommandText = "SELECT ID, COLUMN_A, COLUMN_B FROM…
Andrew
  • 12,991
  • 15
  • 55
  • 85
0
votes
1 answer

Postgresql Devart EF : The underlying provider failed on Open

i got this exception when executing a simple read query using entity framework on our Postgre Db, in the code, which throw this exception, i dont use transactions the code do not fail systematically but randomly this the stack trace : { "Depth":…
Mouadh
  • 289
  • 1
  • 3
  • 12
0
votes
1 answer

System.Data.Entity.Core.MetadataException: Schema specified is not valid

I tried to add a db-Migration to my solution. But it quit with the folloing error: System.Data.Entity.Core.MetadataException: Schema specified is not valid. Errors: (0,0) : error 0040: The Type NVARCHAR2 is not qualified with a namespace or alias.…
Hauke Lü
  • 75
  • 7
0
votes
1 answer

EF6 code first with devart doesn't create index

Following setup: dotConnect for Oracle 9.5.454.0 EF 6.2.0 .NET 4.6.1 oracle 12c We defined our models with the fluent API. When the tabels are created is everything fine except that there are no indexes created. [Table(nameof(Preisliste) +…
Hauke Lü
  • 75
  • 7
0
votes
1 answer

Devart.Data.MySql 'Feature is not supported.' Error

I've been desperately trying to find a way to notify the client of changes in the database. I tried TableDependency Package but then noticed that that uses SQL and not MYSQL. I stumbled upon Devart and they have the same thing. I've installed the…
Ruben Versavel
  • 161
  • 2
  • 12
0
votes
1 answer

Devart.Data.Oracle.Vs.OracleDataProviderPackage package did not load correctly

I am facing this problem (Devart.Data.Oracle.Vs.OracleDataProviderPackage package did not load correctly) in visual studio 2015 Error Message the ActivityLog.xml file show this error Log file message 53
Smn Dvp
  • 3
  • 9
0
votes
0 answers

Stuck WCF IIS hosted webservice and DevArt dotConnect for MySQL

We have a problem with the webservice being stuck: it's not even accepting new requests and only application pool recycling helps (It's not crashing, just stucks as if threads are in infinite timeout loop). Here is how the Entity Framework…
0x49D1
  • 8,505
  • 11
  • 76
  • 127
0
votes
2 answers

Text value of the picklist field. Salesforce, Dotconnect, Devart

I am using Devart DotConnect to access Salesforce database. And there is a problem accessing field that is a picklist. Here is part of my Enterprise.wdsl:
shlasasha
  • 165
  • 1
  • 14
0
votes
1 answer

VS 2017 Dataset Designer operations extremely slow (not just save)

I’m using Visual Studio 2017 to manage a large dataset, which until recently, was working fine. Now I’m experiencing excessive wait times for several Dataset Designer operations. I’m using: Visual Studio 2017 (v15.5.1) PostreSQL 9.3 (running…
0
votes
1 answer

How to deal with composite type arguments at DevArt PostgreSql dotConnect

I have something like this in postgre: create type "test_complex_rec" as ( num$ numeric, str$ character varying ) create or replace function "test_complex_fun"(INOUT…
garry
  • 25
  • 5
0
votes
1 answer

ProviderIncompatibleException with entity framework 4 ctp5 and oracle express

I encountered a ProviderIncompatibleException when I tried to connect on a Oracle express database with dotConnect for Oracle and entity framework 4 ctp5. I have Oracle Express 10g and I download the trial version for Oracle express today, so I have…
Breach
  • 1,288
  • 1
  • 11
  • 25