Not connecting to Adaptive Sybase 15 using

[rahulaict]

Hi All -
we are using Adaptive Sybase 15.7 and 16 versions. We were using OLEDB connection and TD4.2. as Sybase 16 is not supporting OLEDB, we used the traditional TD connectivity using the SQL.INI

In my development machine, am able to connect to the database using SqlConnect. I used the same SQL.ini in client machine and its not working.


Here is what I did:
1. I used the iSQL command and connection to Sybase succeded.
2. Used the same Sql.ini which I used in development machine. Changed the DB name alone.
3. Tried to connect using SQLtalk. Getting 401 Cannot connect to Database error.
4. Then I setup the Sybase connection with ODBC and modified the SQL.ini to support the created ODBC.
5. This time its connected to the Database.

My guess: It could be an network issue, like listenport might not be opened. But not sure which port is using for the connection. It could be something else too.

Please let me know if you have any thoughts.

Thanks
Rahul Ramchandran


SQL.Ini attached below.

;
; Centura Software Corporation 1996
; SQLBase INItialization file
; Modified by OToulan 23/10/2013
;
[winclient.comments]
;
; Windows
;-------------
; Use this section to specify Windows client workstation parameters that are
; independent of the communications protocol(s) being used.
;
; This section is for the Windows client workstations. Here you will specify
; the COMmunication DLL(s) that the Windows application(s) intend to use.
; Use the following protocol(s) to connect to the specified SQLBase product:
;
; comdll SQLBase target
; ------ --------------
; sqldbw LOCAL single-user database engine (dbwindow.exe)
; sqlwsv LOCAL multi-tasking database engine (dbwservr.exe)
; sqlnbiow REMOTE database using NetBios
; sqlspxw4 REMOTE database on a Netware server
; sqlwsock REMOTE database using TCP/IP (WinSock)
;

;-------------------------------------------------------------------------; Added for SQLBase

[dbnt1sv]
servername=OFFLINE,sqlapipe,sqlws32
dbname=ISLAND,sqlapipe,sqlws32
centurydefaultmode=1
;dbdir=C:\DBOFF
cache=2000
oracleouterjoin=0
partitions=0
secureapi=0
dbname=I40OFF,sqlapipe,sqlws32

[dbnt1sv.dll]
comdll=sqlapipe
comdll=sqlws32
;comdll=sqlntnbi

[dbnt1sv.apipe]
debug=15,C:\dbntsrv.dbg

;-------------------------------------------------------------------------
[winclient]
clientname=WinUser
connecttimeout=5

[winclient.dll]
comdll=sqlsybw
comdll=sqlspxw
;-------------------------
; Added for SQLBase
comdll=sqlapipe
comdll=sqlws32
;-------------------------

[winclient.wsock]

[sqsgtwy]
;

mapgticursors=off
sybautocommit=off
enhancedcursors=off
yieldonservercall=0
locktimeout=0
longbuffer=4095
maperror=off
displaybinaryashex=off
checkexists=off
sybapplicationname=@appname
sybworkstationname=@appname
[win32client.comments]
;
; Win32 (Windows 95 or NT)
;--------------------------
; Use this section to specify Win32 client workstation parameters that
; are independent of the communications protocol(s) being used.
;
; This section is for the Win32 client workstations. Here you will specify
; the COMmunication DLL(s) that the Win32 application(s) intend to use.
; Use the following protocol(s) to connect to the specified SQLBase product:
;
; comdll SQLBase target
; ------ --------------
; sqlapipe LOCAL database using Anonymous Pipes
; sqlntnbi REMOTE database using NetBios
; sqlws32 REMOTE database using TCP/IP (WinSock)
; sqlspx32 REMOTE database using IPX/SPX (Win32 Novell Client)
; sqlwsspx REMOTE database using IPX/SPX (Win32 Microsoft Client)
;
[win32client]
clientname=Win32User

[DSNOption]
;ConnectUsing= System
ConnectUsing = User

[win32client.dll]
;Connects to Sybase
comdll=sqlspx32
comdll=sqlsyb32
;Connects to MSSqlServer
comdll=sqlodb32

[win32client.ws32]
;serverpath=server1,localhost/island

[sybgtwy]
;
remotedbname=SybDb,CON,DBName

longbuffer=32650
locktimeout=0
sybautocommit=on
yieldonservercall=0
sybworkstationname=@workstation
sybapplicationname=CENTURA Sybase App
checkexists=off
fetchrow=20
sybmaxmessages=0
enablemultipleconnections=on
closecursorateof=on
;sybtracefile=c:\sybase.log

[win32client.ws32]
; Resource Manager (sqlmpipe uses port 2156 explicitly declared instead of
; default port 2155
serverpath=server1,localhost,2156

[odbcrtr]
;DSN is defined in ODBC datasources-use the alias in phoenix.ini ,for eg:-PhoenxDB1 connects to DSN PhoenixSER1, which could ;point to the phoenix database in the SERVER1.You must have phoenix / staging as the default database for the DSN.
odbctrace=off
ENABLEMULTIPLECONNECTIONS=ON
;remotedbname=DBName,DSN=DNS Name


[SQLEdit]
winclient.realname=1

[win32client.syb32]
log=c:\r.log

[win32client.odb32]
log=c:\msodbc.log

[win32client.async]
debug=c:\async1.log
[win32client.wsspx]
;
[win32client.ntnbi]
;