How to connect oracle for version5.1?

[KEVIN]

 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:

Code: Select all

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

sql.ini

Code: Select all

[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]

 Posted by:  Mike 

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

[Daniel Osborne]

 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:

Code: Select all

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

[win32client.ws32]
serverpath=Server1,localhost/ISLAND

Daniel Osborne

[Remi]

 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]

 Posted by:  Ryan Phillips 

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