How to connect oracle for version5.1?

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
KEVIN

How to connect oracle for version5.1?

Post by KEVIN » 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]

Mike

How to connect oracle for version5.1?

Post by Mike » 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.

Daniel Osborne

How to connect oracle for version5.1?

Post by Daniel Osborne » 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

Remi

How to connect oracle for version5.1?

Post by Remi » 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

Ryan Phillips

How to connect oracle for version5.1?

Post by Ryan Phillips » 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