Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Connection to Oracle

54 views
Skip to first unread message

RahulMR

unread,
Sep 22, 2010, 12:56:28 AM9/22/10
to
I have using centura 1.5.1.
Now i want to connect centura with oracle directly(Without using
ODBC).


Is this support in this current centura version.

If it possible, please let me know what is the solution.


Appreciate any response

peatoo

unread,
Oct 27, 2010, 6:43:45 AM10/27/10
to

From CTD 2000 help (Sorry, I don't have 1.5.1) :

bOk = SqlConnect ( hSql )
Connects to a database.
Centura uses the values in the SqlDatabase SqlUser and SqlPassword
variables. The default values for these variables are DEMO, SYSADM,
and SYSADM. The value of other system variables such as SqlNoRecovery,
SqlInMessage, and SqlOutMessage take effect after this function
executes.
Parameters - hSql Receive Sql Handle. A handle that identifies a
database connection.
Return Value - bOk is TRUE if the function succeeds and FALSE if it
fails.

As a SqlDatabase you can set any connection that you have in
TNSNAMES.ORA file.
Set those values in On SAM_AppStartup or in some login dialog if
you're using such one.

0 new messages