Configuring Application with Centura 4.2

Discussion regarding installation problems for all products.

Configuring Application with Centura 4.2

Postby kumarravik » Wed Jun 06, 2012 9:48 am

Hi ,

I am currently using Team Developer 4.2(Centura 4.2). I need to use an application that connects me with My database (Oracle 10g). whenever tried to logging in, it throws an error "can't open the database" error (401). I need to know that if I need to change any setting like if need to specify the application name or database path in team developer directory to use my application. I have attached a screen-shot of the error message. Greatly appreciate the help you can provide to resolve this issue.
please let me know, if any other details required

Regards:
Ravi
You do not have the required permissions to view the files attached to this post.
kumarravik
 
Posts: 9
Joined: Wed Jun 06, 2012 1:18 am

Re: Configuring Application with Centura 4.2

Postby Jeff Luther » Wed Jun 06, 2012 2:28 pm

I would guess that you have not edited TD's SQL.INI file to enable connections to Oracle, and add remotedbname= entries for the Oracle DBs you want to connect to.

TD v4.2 shipped with a series of PDF books, including one called CCOD.PDF that has information for how to configure the INI for the DB brands then supported. Look in there for the Oracle info.

Very briefly, these sections (I'll put in bold) need to changed or added to:
[win32client.dll]
; order of win32client dll's is important when connecting to multiple databases.
; sqlws32 should always be the last and sqlodb32 be 2nd last.
comdll=sqlifx32
; Jeff comment - sqlora32 just below must be uncommented -- remove the ';' char
comdll=sqlora32
; for sybase
comdll=sqlsyb32
; at least sqlws32 must be uncommented and be listed last; if you connect to MS SQL Server, then sqlodb32 must be uncommented and 2nd to last
comdll=sqlodb32
comdll=sqlws32

[oragtwy]
; Jeff comment -- here is where you list the Oracle DBs you want to connect to, like our oracle10g DB
remotedbname=oracle10g,@tns:oracle10g
Jeff Luther
 


Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest

cron