Devart Forums

I am trying to implement this in Delphi 7. Do you have any instructions?

What is e-support?

After upgrading from 6.3.x to 6.4.x the sql give the error ora-00907: missing right parenthesis

select distinct a.* ,x.obj_id
from chg_master a,object_ids x
where a.chg_num = ''

order by a.ECP_NUM ASC,a.CHG_CAGE ASC ,a.TYPE ASC ,a.REV DESC,a.CORR ASC,a.CHG_TYPE ASC



by changing the sql to this (commenting out the order by), the error goes away:

select distinct a.* ,x.obj_id
from chg_master a,object_ids x
where a.chg_num = ''

--order by a.ECP_NUM ASC,a.CHG_CAGE ASC ,a.TYPE ASC ,a.REV DESC,a.CORR ASC,a.CHG_TYPE ASC


That is the most isolated way I could show it. Unfortunately, there are other parts of our code where many queries are run to and I would likely spend a week going through it all.

Perhaps it has nothing to do with case construction, I don't know, but I do know that a paid upgrade from 6.3.x to 6.4.x resulted in this.

I downloaded Universal Data Access Components Professional 6.4.16 21-Nov-2016

and it is still broken.

Is there a hot release? or when will the release be available?

Thanks, but that doesn't explain why mine stopped working with 6.4.14

Can anyone help me???

I just upgraded to 6.4.14, and after compiling my app I got the error message, Direct Mode is not supported when connecting to Oracle.

What changed?

I will check with our customer and see what can be done. Thank you!

Sorry for waiting so long, but it has taken time to reevaluate this customer's issue.

The problem is actually with Direct Mode. While investigating it turns out that from the DBA's machine, they can direct connect to one database but get that access violation when trying to connect to their other database. Both using the same client application.

This is a Delphi 7 application. One of the databases uses port 1521. The database that yields the access violation uses port 1524. The databases are on different servers.

What could cause this?

Since version 6 of UNIDAC one of our customers can not login to oracle from our application using UNIDAC.

It happens on UniConnection.Open

This happens no matter if we use direct connect or not. On the same machine, UNIDAC 5 and below work fine using the OCI adaptor.

I'm not even sure how to debug this.

Help!

I have a customer running a Delphi 7 app with Unidac 6.2.7 on a new Windows 8.x machine. When he goes to log into the sql server database he gets this error:

Named Pipes Provider Could not open a connection to SQL Server [53]

What is missing?

Further testing shows that the dataset is getting closed when the master dataset scrolls.

I upgraded to 5.3.8 last week and none of my master/details are working. So, I upgraded to 5.3.9, and same problem. This is with SQL Server, and Oracle.

Can one use SecureBridge to do simple symmetrical file encryption/decryption using the algorithms in SecureBridge?

Thanks!

Alex,

I wasn't passing in the server info properly. Thank you so much!

Jeff