TD 2000 open DB Oracle 11g

[m.burkhardt]

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]

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]

Thank allott!!!

It succeed!!!!!

[Jeff Luther]

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.