Connection to Oracle

forum.centura.team.developer (1998-2005) & forum.sqlwindows (2000-2005)
RahulMR

Connection to Oracle

Post by RahulMR » 22 Sep 2010, 06:56

 Posted by:  RahulMR <rahul.m.ra...@gmail.com> 

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

Connection to Oracle

Post by peatoo » 27 Oct 2010, 12:43

 Posted by:  peatoo <piotr.p....@gmail.com> 

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

bOk =3D 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=09Receive 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.

Return to “forum.sqlwindows”

Who is online

Users browsing this forum: No registered users and 0 guests