Oracle Connection settings TD 6.3.sp1

Discussion regarding installation problems for all products.

Oracle Connection settings TD 6.3.sp1

Postby mlachlan » Tue Jul 05, 2016 11:52 am

Good afternon,
I'm using GUPTA since 1991 also later CENTURA).
The I stopped and now I'm back to perform a PoC for a customer using the latest Trial Version of TD and SqlBase.
Now I'm not able anymore to connect either to an Oracle nor a SQLServer DB.
It seems there has a lot changed over the last 15 years.

Im using an Oracle 11g 64bit DB and SQLServer 2014 also 64bit.
can someone get me how the SQL.ini file has to look like with this Versions ?

This is how my current SQL.ini Looks like:
;
; Unify Corporation 2008
; SQLBase INItialization file

; Win32 (Windows 2000, XP and Vista)
;------------------------------------
; This section is for the SQLBase Win32 database server. You can
; specify which communication protocol(s) the server can use as well as which
; protocol(s) a database can use.

[dbntsrv]
dbname=ISLAND
dbname=SBTASK
ANSIJoinSyntax=1
centurydefaultmode=1

; The default value for readonly is 1, which allows use of "read only" and
; "read committed" (RO and RC) isolation levels. Uncommenting "readonly=0"
; will disallow use of RO and RC isolation levels.
;readonly=0

; To get process logging, specify a log file and display level.
;log=c:\dbsrv.log
;displevel=4

;
; SQLBase supports communicating through named pipes. Named pipes
; support Windows network authentication and allows a client running
; on the same machine to find a server without explicit configuration
; Options are:
; namedpipes=No ; 0 - Named pipes not enabled
; namedpipes=Yes ; 1 - Named pipes are enabled for local and remote access
; namedpipes=LocalOnly ; 2 - Named pipes are enabled for local access only. Remote access is denied
;
NamedPipes=Yes
servername=Server1
dbdir=C:\ProgramData\Gupta\Team Developer 6.3\sqlbase
tempdir=C:\ProgramData\Gupta\Team Developer 6.3\sqlbase

;
; The USECLIENTCOUNTRY setting is used to require the client
; COUNTRY configuration setting to match what is being used on the server.
;
; 0 - Server assumes client COUNTRY setting is compatible with the
; one the server is using. The client no longer needs to specify
; the COUNTRY configuration parameter when the server has it set.
; However, the client should be using the same character set as
; the server.
; 1 - Client COUNTRY= setting must match what the server is using
;
; The default value is 0, COUNTRY setting not required
;
; USECLIENTCOUNTRY=0

[dbntsrv.gui]

[dbntsrv.dll]
comdll=sqlws32
;comdll=sqlapipe

[dbntsrv.apipe]

[dbntsrv.ws32]
ListenPort=2155

; Win32 (Windows 2000, XP and Vista)
;------------------------------------
; Use this section to specify Win32 client workstation parameters that
; are independent of the communications protocol(s) being used.
;
; This section is for the Win32 client workstations. Here you will specify
; the COMmunication DLL(s) that the Win32 application(s) intend to use.
; Use the following protocol(s) to connect to the specified SQLBase product:
;
; comdll SQLBase target
; ------ --------------
; sqlapipe LOCAL database using Anonymous Pipes
; sqlws32 REMOTE database using TCP/IP (WinSock)

[win32client]
; On 11.7 and above, if the CLIENTNAME is not specified, the computername
; will be displayed on the server. Also, the CLIENTNAME is not limited to 12 characters.
clientname=test_user
; The transports option overrides the [win32client.dll] section.
; Possible values for transports are
;
; npipe,tcpv4,tcpv6,apipe

transports=npipe,tcp,apipe
clientruntimedir="C:\Program Files (x86)\Gupta\Team Developer 6.3\sqlbase"

;
; The [win32client.dll] used to have a list of communication .dll's
; to use for communication. Communication .dll's have been removed.
; This section is read and interpreted to be backwards compatibible.
; The transports parameter now supersedes it.
;
;[win32client.dll]
;comdll=sqlws32
;comdll=sqlapipe

[win32client.ws32]
serverpath=Server1,localhost/*
autostartserverpath="C:\Program Files (x86)\Gupta\Team Developer 6.3\sqlbase\dbntsrv.exe"

[ConnectionStrings]
comdll=sqlodb32;alias=SqlServer ODBC AX;dbname=AX_NAME_TEST_MMN
comdll=sqlodb32;alias=SqlServer ODBC NAME;dbname=NAME_Test
comdll=sqlora32;alias=OracleKW;dbname=EWA

[oragtwy]
remotedbname=EWA,@//SERVER:1521/VITO
fetchrow=20
maperror=OFF
substitute=SYSSQL.,
longbuffer=32767

Please could someone reply ?

Regards
Michael
mlachlan
 
Posts: 1
Joined: Tue Jul 05, 2016 11:39 am

Re: Oracle Connection settings TD 6.3.sp1

Postby frevelundfey » Wed Jul 06, 2016 1:27 am

Hi Michael,

you can have 64Bit Oracle Server - but you have to use 32-Bit Oracle-Client!
You also have to configure ODBC32 Bit for sqlserver
(look for it here c:\windows\syswow64\odbcad32.exe).

Regards Thomas
frevelundfey
 
Posts: 172
Joined: Fri May 11, 2012 2:23 am
Location: Munich, Germany


Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest