How to connect oracle for version5.1?

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

How to connect oracle for version5.1?

Post by NewsgroupServer » 10 Oct 2007, 06:02

 Posted by:  KEVIN 

I use sqlplus to test connecting oracle fine.
But when I execute program until the sqlconnect function,system error cann't
connect oracle database!!
I use sqltalk,typing "connect artis scott/tiger;":system error code
401(Error: 00401 DBA COD Cannot open database)!!
But I use sqltalk function key F2 to connect oracle
database(database=ARTIS;USER=scott;PASSWORD=tiger;SERVER=ARTIS) fine.
I use sqltalk function key F2 to connect dbase
database(database=THOME;USER=scott;PASSWORD=tiger;SERVER=THOME) fine.
Could someone help me,please?

code:

Set SqlDatabase='ARTIS'
Set SqlUser='SCOTT'
Set SqlPassword='tiger'
Call SqlConnect( hSqlPubRead )

sql.ini

[dbntsrv]
dbname=ISLAND,sqlws32
servername=server1,sqlws32
cache=2000
sortcache=2000
readonly=0
oracleouterjoin=0
logfileprealloc=0
partitions=0
optimizerlevel=2
ansijoinsyntax=0
dbdir=C:\Program Files\Unify\Team Developer 5.1

[dbntsrv.dll]
comdll=sqlws32

[win32client]
clientname=2007uni
clientruntimedir="C:\Program Files\Unify\Team Developer 5.1"

[win32client.dll]
comdll=sqlws32
comdll=sqlora32
comdll=sqlodb32
;comdll=sqlapipe

[win32client.ws32]
serverpath=Server1,localhost/*
autostartserverpath="C:\Program Files\Unify\Team Developer
5.1\sqlbase\dbntsrv.exe" "ini=C:\Program Files\Unify\Team Developer
5.1\sqlbase\sql.ini"

;[win32client.ws32]
; Resource Manager (sqlmpipe uses port 2156 explicitly declared instead of
; default port 2155
;serverpath=server1,localhost,2156/*
[oragtwy]
remotedbname=ARTIS,@tns:ARTIS
longbuffer=32767
fetchrow=20
substitute=SYSSQL.,
[sybgtwy]
remotedbname=test, robbyia64, master, 0
[odbcrtr]
remotedbname=THOME,DSN=msfoxpro;UID=SYSADM;PWD=SYSADM
odbctrace=off
odbctracefile=sql.log
[win32client.apipe]

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

How to connect oracle for version5.1?

Post by NewsgroupServer » 10 Oct 2007, 12:43

 Posted by:  Mike 

Be sure to not have an ODBC entry that is also named ARTIS then it goes painfully wrong.

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

How to connect oracle for version5.1?

Post by NewsgroupServer » 13 Oct 2007, 03:10

 Posted by:  Daniel Osborne 

If there are multiple comdll's in the sql.ini, then the SQLBase router entry
should either be last in the list of comdll's, or the serverpath entry in
[win32client.ws32] needs to be altered to only pickup certain databases.

Try this:

[win32client.dll]

comdll=sqlora32

comdll=sqlodb32

comdll=sqlws32

;comdll=sqlapipe

[win32client.ws32]

serverpath=Server1,localhost/ISLAND

Daniel Osborne

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

How to connect oracle for version5.1?

Post by NewsgroupServer » 26 Apr 2008, 17:46

 Posted by:  Remi 

Hi :

First you have to add a new key in your registry ORAOCI = ORACLIENT10.dll
with the full path in the
(see the connectivity pdf).

Remi

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

How to connect oracle for version5.1?

Post by NewsgroupServer » 19 Apr 2010, 16:51

 Posted by:  Ryan Phillips 

I am having the same problem. Where do you find the "connectivity pdf"?
Thanks, Ryan

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests