1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

TDBXError “Remot error: Dbx.SQL is an unrecognized command type”.

Discussion in 'SQL PL/SQL' started by Al_Alter, May 17, 2011.

  1. Al_Alter

    Al_Alter Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    Hi All!
    In an effort to get thru trouble of getting DataSnap WebBroker Application with Oracle DB going I created a testing project in which on server side there is only one component: SQLConnection with Oracle driver (dbxora.dll) and on client side only one component: SQLConnection with datasnap driver.
    In this simplified situation I am trying to execute simple Update statement: SQLConnection1->ExecuteDirect(Update Table…..). It results in an error message:
    SQLConnection TDBXError “Remot error: Dbx.SQL is an unrecognized command type”. You see CommandType is not the property of TSQLConnection where I could have been able to set proper value.
    The same Update… with Oracle driver is executed without errors.
    Can anyone tell me please what is the point in all this?
    Thanks in advance, Alex.