Solved TD 2000 open DB Oracle 11g

General discussion forum about all databases other than SqlBase.
m.burkhardt
Germany
Posts: 50
Joined: 19 Feb 2020, 10:13
Location: Duisburg, Germany

TD 2000 open DB Oracle 11g

Post by m.burkhardt » 28 Nov 2012, 10:55

Hello, I have a question about connecting from Team Developer 2000 to a Oracle Database 11g.

Can somebody tell me, how do I have to edit the SQL.INI and wich ROUTER do I have to Install from the Team Developer 2000 CD?

I've tried the following:

[WIN32CLIENT.DLL]
COMDLL=SQLWS32
COMDLL=SQLORA32

[oragtwy]
remotedbname=timos,@TNS:TIMOS_T
longbuffer=32767
substitute=SYSSQL.,
substitute=",
fetchrow=20

TNSNAMES.ORA
...
TIMOS_T=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=TKSTIMOS-ENTW)
(PORT=1521)
)
(CONNECT_DATA=
(SID=timos)
)
)

Thank allott. :)

Greetings from Germany
Michael

Mike Vandine

Re: TD 2000 open DB Oracle 11g

Post by Mike Vandine » 28 Nov 2012, 11:06

Hi Michael,

I'm sure that others will jump in, but *first* try swapping the comdll= statement to make the comdll=sqlws32 *after* the comdll=sqlora32.

m.burkhardt
Germany
Posts: 50
Joined: 19 Feb 2020, 10:13
Location: Duisburg, Germany

Re: TD 2000 open DB Oracle 11g

Post by m.burkhardt » 28 Nov 2012, 11:29

Thank allott!!!

It succeed!!!!!

Jeff Luther

Re: TD 2000 open DB Oracle 11g

Post by Jeff Luther » 28 Nov 2012, 19:58

I'll jump in. Glad Mike's suggestion worked for you. And FYI, the latest TD SQL.INI files has this comment in that section:
[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
comdll=sqlora32
comdll=sqlsyb32
comdll=sqlodb32
comdll=sqlws32
The order of first 3 comdll= entries does not matter.

Return to “General Discussion”

Who is online

Users browsing this forum: [Applebot], [Ccbot] and 0 guests