I have a default connection to an oracle connection called EMPTST.

I am trying to change the connection to EMPDEV

Itried the command:

ENGINE SQLORA SET CONNECTION_ATTRIBUTES EMPTST/user/pass

and it still pointed to the EMPDEV data on sql pass thru.

Is this the correct string and is that all you have tot do?

Thank you in advance.

This is how we do it.

SET SQLENGINE = SQLORA

SQL SET SERVER dbasename

SQL SET CONNECTION_ATTRIBUTES dbasename/user,password

SQL SQLORA

Select ...

This message has been edited. Last edited by: Nightowl,

Problem is fixed.

This message has been edited. Last edited by: secret,