Stack Overflow
Stack Overflow

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

How to cause a timeout

We are investigating a timeout issue and would like to replicate it as part of initial testing. I am new to Devart, Borland C++ Builder 6 and SQL Server and unsure of the syntax required. I am looking for example code to execute a query or series of…
Michael Sandler
  • 1,290
  • 3
  • 17
  • 30
1
vote
3 answers

What is an icon file (.ico) that I can rely on every Windows user having?

I am extracting the icon from .exes, but want to have a fallback generic icon if for some reason Icon.ExtractAssociatedIcon(sPathOfExe) fails. Is there one I can resort to like so that would be safer than what I'm currently using: private const…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
2 answers

Is a cursor parameter really to be declared differently than a "regular" parameter?

OK, nobody seems to know how to solve the problem I'm having looping through a cursor/result set for storage into a List, so I'm going to break it down into pieces and try to slog through it that way. So, first of all: I add SQL Parameters to an…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

Oracle Parameter not supported

I'm getting this err msg: System.ArgumentException was unhandled Message=Value with type Devart.Data.Oracle.OracleParameter not supported. ...with this code: OracleParameter pRes = new OracleParameter("C_REF", OracleDbType.Cursor); …
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
0
votes
1 answer

3dparty component leaves dead threads

While an app tries to connect to database server and retrieve some data, it sometimes raise an exception and it seems like it leaves dead threads when expcetion raised even when it's handled. So there are about 300 threads that getting service…
kseen
  • 359
  • 8
  • 56
  • 104
0
votes
1 answer

Performance Issues Using TUniTable

I'm in the process of converting a Paradox database application written in Delphi to use SQL Server 2008 R2. We are using the UNIDAC components from Devart to access the database/tables. However, I am finding the performance rather slow. For…
PDM
  • 503
  • 2
  • 12
  • 27
0
votes
3 answers

Can you include linq-to-sql changes and ADO.NET dataset table adapter updates in a single transaction?

Here are the relevant technologies that I'm working with: Devart's dot Connect for Oracle (to facilitate Linq-to-Sql for Oracle). Strongly Typed ADO.NET Datasets. An Oracle database. Here's the challenge: My legacy code submits database updates…
Jim G.
  • 15,141
  • 22
  • 103
  • 166
0
votes
1 answer

Error when connecting unidac 4.0.1 with sqlite database

I'm delphi user, i got problem when try to connect sqlite with my unidac 4.0.1 component. I've dropped TUniConnection, Sqlite uniprovider, setting client library at specification property, but it always raised an error: file is encrypted or is…
Abdullah Al- Arief
  • 39
  • 5
0
votes
1 answer

Porting from ODP.NET to dotConnect - what's the equivalent of the OracleParameter.CollectionType property?

I'm porting a bunch of code from the ODP.NET drivers to DevArt dotConnect for Oracle. I ran into the following code that no longer compiles: OracleParameter parameter = new OracleParameter("state", OracleDbType.Number); parameter.CollectionType =…
Mike Christensen
  • 88,082
  • 50
  • 208
  • 326
0
votes
1 answer

Keep valid DB connections alive without native pooling

Is there any way to keep DB connections open and ready to use in runtime? Our WCF service should keep connections that way. Now we have code that looks similar to this piece of code: // This is the class of objects that has connections…
kseen
  • 359
  • 8
  • 56
  • 104
0
votes
0 answers

Devart dotConnect for Oracle use with Azure Function license key issue

I am looking to connect to an old Oracle 8i database from an Azure Function written with .NET 6. The only thing that seems to work is using Devart dotConnect Direct mode so I do not need an Oracle client installation (which wouldnt work with a…
Steve
  • 89
  • 1
  • 1
  • 4
0
votes
0 answers

There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server

Please help, as I can not seem to upload/insert data from my SQL Server to my SSH Postgre and I get this error: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server I checked the…
Raymond Mashishi
  • 1
0
votes
1 answer

Masstransit EntityFramework Saga management

I have been trying to use the Devart Postgres EFCore library as this is used at the company I work at. The NpgSql lib works fine with Mass Transit from what I can tell. However I almost immediately ran into a problem with Mass Transit and…
Captain John
  • 1,859
  • 2
  • 16
  • 30
0
votes
1 answer

Oracle Parameters: expects padded value for fixed char length

How do you efficiently use OracleCommand and Parameters to get data from an Oracle DB when you have a fixed length char colum and don`t know how big the column is? Let`s assume we want to get an ID named IID which is a char (5 bytes) fixed. …
Marc Wittmann
  • 2,286
  • 2
  • 28
  • 41
0
votes
1 answer

Byte array for GUID must be exactly 16 bytes long - Devart - Oracle

I'm having a problem when I insert a Guid value in an Oracle database (raw(16) field). I'm using the Devart library in my C# application to record records. The error occurs randomly because I use Guid.NewGuid() to generate the values that will be…
Leonardo Souza
  • 13
  • 3
1 2 3
…
25 26