Search found 651 matches
- Mon 23 Mar 2020 13:54
- Forum: Oracle Data Access Components
- Topic: ORA-12637 and Oracle 19.5.1 support
- Replies: 3
- Views: 16120
Re: ORA-12637 and Oracle 19.5.1 support
We'll investigate the issue with Oracle connection in the "Out Of Band Break" mode and notify you as soon as it's resolved.
- Wed 18 Mar 2020 17:13
- Forum: Oracle Data Access Components
- Topic: ORA-12637 and Oracle 19.5.1 support
- Replies: 3
- Views: 16120
Re: ORA-12637 and Oracle 19.5.1 support
Hello
To reproduce the issue, we need more details. Please give us the following information: does the user employ Direct mode or Oracle client (in the latter case, please specify the exact version of Oracle client); the content of the sqlnet.ora file from the server and, in Oracle client is used, the content of the sqlnet.ora file from the client.
To reproduce the issue, we need more details. Please give us the following information: does the user employ Direct mode or Oracle client (in the latter case, please specify the exact version of Oracle client); the content of the sqlnet.ora file from the server and, in Oracle client is used, the content of the sqlnet.ora file from the client.
- Mon 22 Oct 2018 08:57
- Forum: SQL Server Data Access Components
- Topic: Support for Microsoft OLE DB Driver for SQL Server?
- Replies: 8
- Views: 8114
Re: Support for Microsoft OLE DB Driver for SQL Server?
We are under NDA, so we cannot comment the release date. We will release UniDAC compatible with new IDE as soon as the new IDE is released. If you have UniDAC with Source code license and an active subscription, please contact us via the contact form www.devart.com/company/contactform.html and we will provide you UniDAC night build to test compatibility.
- Fri 06 Jul 2018 14:00
- Forum: Oracle Data Access Components
- Topic: Access Violation with XMLTYPE and Unicode Environment
- Replies: 2
- Views: 1639
Re: Access Violation with XMLTYPE and Unicode Environment
Hello
We investigated this issue several years ago and it looks like Oracle client bug. You shouldn't use Unicode Environment, but you can use the Direct mode, which allows using XML with Unicode Environment without any errors.
We investigated this issue several years ago and it looks like Oracle client bug. You shouldn't use Unicode Environment, but you can use the Direct mode, which allows using XML with Unicode Environment without any errors.
- Thu 05 Jul 2018 08:06
- Forum: ODBC Drivers
- Topic: Possible to install Salesforce ODBC driver with .net 4.0?
- Replies: 1
- Views: 1686
Re: Possible to install Salesforce ODBC driver with .net 4.0?
Hello
Unfortunately, Salesforce security rejects all connections with TLS 1.0. TLS 1.1 and 1.2 available in .NET 4.5 or higher, for this reason we cannot use .NET 4.0.
Unfortunately, Salesforce security rejects all connections with TLS 1.0. TLS 1.1 and 1.2 available in .NET 4.5 or higher, for this reason we cannot use .NET 4.0.
- Mon 02 Jul 2018 07:13
- Forum: Oracle Data Access Components
- Topic: TOraQuery AsDateTime property
- Replies: 8
- Views: 3164
Re: TOraQuery AsDateTime property
We can't provide any official patches for previous ODAC versions. But if you have ODAC with source code and an active subscription, please contact us via the contact form devart.com/company/contactform.html , specify your license number and we will help you to add the fix to your source code.
- Wed 27 Jun 2018 12:21
- Forum: Oracle Data Access Components
- Topic: TOraQuery AsDateTime property
- Replies: 8
- Views: 3164
Re: TOraQuery AsDateTime property
We will change the AsDateTime method behaviour in the next ODAC release and it will return milliseconds for TIMESTAMP fields.
- Wed 27 Jun 2018 07:26
- Forum: VirtualDAC
- Topic: Cloned cursor?
- Replies: 5
- Views: 5872
Re: Cloned cursor?
Now VirtualDAC and UniDAC don't support CloneCursor functionality like TClientDataSet. We plan to add this functionality in one of the next VirtualDAC and UniDAC versions. You can vote for this feature at UserVoice to speed up the implementation.
- Wed 29 Jun 2016 12:25
- Forum: EntityDAC
- Topic: How to use unicode with TEntityConnection?
- Replies: 6
- Views: 5403
Re: How to use unicode with TEntityConnection?
If you use UniDAC as data provider, you should specify ProviderName, because UniDAC allows connection to various databases. In your case, this connection string is valid:
Please specify the connection string that you are using to establish connection via PgDAC.
Code: Select all
EntityConnection.ConnectionString := 'Data Provider=UniDAC;ProviderName=PostgreSQL;SQL Dialect=PostgreSQL;UseUniCode=True;Server=your_server;Port=5432;User=your_user;Password=your_password';
- Thu 09 Jul 2015 14:28
- Forum: Oracle Data Access Components
- Topic: ODAC 9.5 Installation Issues (Lazarus 1.2.6 PFC 2.6.4)
- Replies: 9
- Views: 2477
Re: ODAC 9.5 Installation Issues (Lazarus 1.2.6 PFC 2.6.4)
Hello,
We have sent you ODAC Trial for Lazarus 1.4 fully compatible with Windows 7 x86 to your e-mail.
We have sent you ODAC Trial for Lazarus 1.4 fully compatible with Windows 7 x86 to your e-mail.
- Tue 30 Jun 2015 08:32
- Forum: Universal Data Access Components
- Topic: [Oracle] Empty string and NULL Value
- Replies: 7
- Views: 1595
Re: [Oracle] Empty string and NULL Value
Try to set TDataSetProvider.ResolveToDataSet = True. In this case, SQL for update will be generated by TUniQuery. If TDataSetProvider.ResolveToDataSet = False, then SQL is generated by TDataSetProvider or TClientDataSet and can be invalid.
- Fri 26 Jun 2015 10:44
- Forum: Universal Data Access Components
- Topic: Compile Error oraprovider and ibprovider in Lazarus
- Replies: 5
- Views: 1080
Re: Compile Error oraprovider and ibprovider in Lazarus
Hello
We plan to release next build next week.
We plan to release next build next week.
- Fri 26 Jun 2015 10:44
- Forum: Oracle Data Access Components
- Topic: bug in TCRDBGrid - clob
- Replies: 1
- Views: 1200
Re: bug in TCRDBGrid - clob
Hello
Null terminator means the end of the string, so a string, that contains a null terminator, can be displayed incorrectly by any VCL controls. If you need to store big data with null terminators, we recommend to use the BLOB data type.
CRDBGrid is not supported for several years already. It is a FREE bonus, and we deploy it with our components in source code as is. If you have found any bugs in CRDBGrid, you can fix them by yourself.
Null terminator means the end of the string, so a string, that contains a null terminator, can be displayed incorrectly by any VCL controls. If you need to store big data with null terminators, we recommend to use the BLOB data type.
CRDBGrid is not supported for several years already. It is a FREE bonus, and we deploy it with our components in source code as is. If you have found any bugs in CRDBGrid, you can fix them by yourself.
- Fri 26 Jun 2015 10:40
- Forum: Universal Data Access Components
- Topic: [Oracle] Empty string and NULL Value
- Replies: 7
- Views: 1595
Re: [Oracle] Empty string and NULL Value
Here is a sample updating the table by key field, that contains NULL:
In this sample, TUniQuery generates the following query:
Please modify this sample to reproduce your issue.
Code: Select all
var
Connection: TUniConnection;
Query: TUniQuery;
begin
Connection := TUniConnection.Create(nil);
try
Connection.Server := '...';
Connection.Username := '...';
Connection.Password := '...';
Connection.ProviderName := 'Oracle';
Connection.Open;
Connection.ExecSQL('CREATE TABLE TEST_NULL (NAME VARCHAR2(50), VALUE NUMBER)');
Connection.ExecSQL('INSERT INTO TEST_NULL VALUES (NULL, 10)');
Query := TUniQuery.Create(nil);
try
Query.Connection := Connection;
Query.SQL.Text := 'select * from test_null';
Query.KeyFields := 'name';
Query.Open;
Query.Edit;
Query.FieldByName('value').AsFloat := Query.FieldByName('value').AsFloat + 1;
Query.Post;
finally
Query.Free;
end;
finally
Connection.Free;
end;
end;
Code: Select all
UPDATE TEST_NULL
SET
VALUE = :VALUE
WHERE
NAME IS NULL
- Fri 26 Jun 2015 09:46
- Forum: Oracle Data Access Components
- Topic: connect with instant client
- Replies: 5
- Views: 2944
Re: connect with instant client
Hello
We cannot reproduce this issue with a simple application that contains TOraSession only. Can you send us a simple sample application reproducing this issue at alexp[dog]devart[dot]com?
In addition, please specify whether you are get the "run-time error 216" with standard Oracle client, instant Oracle client or in both cases.
We cannot reproduce this issue with a simple application that contains TOraSession only. Can you send us a simple sample application reproducing this issue at alexp[dog]devart[dot]com?
In addition, please specify whether you are get the "run-time error 216" with standard Oracle client, instant Oracle client or in both cases.