ECC 6.0 and SQL statements

Former Member — Fri, 14 Aug 2009 08:53:22 GMT

Hi,

We have upgraded from ecc 5.0 to ecc 6.0 and we have a problem when connecting to an external DB using the following statements :

select single con_name into h_conname from dbcon where con_name = 'GBL'.
 
    EXEC SQL.
      CONNECT TO :h_conname
    ENDEXEC.

This works fine in 5.0.

In 6.0 however, when trying to connect the connection gets refused due to a wrong password.

I have noticed that the ( encrypted ? ) password in 6.0 has changed in table DBCON.

I've already tried by setting the password to the one from 5.0, it still refuses the connection.

Does anybody have any idea how i can solve this ?

Best regards,

Dirk.

Re: ECC 6.0 and SQL statements

Former Member — Fri, 14 Aug 2009 08:58:34 GMT

Check whether the password is case sensitive or not.

Give the same password in ur tbale too.