SQL.ini not read by Sybase Central 6

[william-paul_philibert]

Bonjour,

   I am using Sybase Central 6.0.0.4790 with Sybase ASE 15.7 pluggin.

The problem comes when I try to add a database connection.  Sybase Central does not read the sql.ini file.

I have %SYBASE% and %SYBROOT% weel defined on my computer but for unknown reason, I have to enter hostname and port and there is no way to identify the connexion by the ASE server name.

Anyone enver had the same issue?

Thanks for your help

Regards

William

[dawn_kim · Accepted solution]

Hi,

What version of Windows are you running?

I currently have this set-up with the same version of Sybase Central and it has the 15.7 plug-in on a Windows 7 box. So check the following:

Double check the permission on the sql.ini file.
When you added the ASE did you use dsedit or the menu option Sybase - Connectivity - Open Client Directory Service Editor? Can you ping the server from this tool?
It could be if you moved the sql.ini file from somewhere else  it got spaces put in it so check the file for unwanted characters.
Sql.ini uses client to some extent it could be the version C++ redistributable package you have installed on your machine also, but you would see a side-by-side error or something to that extent.
What version of the C++ Redistributable package are you running on your Windows machine.

Thanks,
Dawn Kim

[Former Member · Accepted solution]

Hi Dawn ,

Is there a 15.7 Plug-in for Sybase Central ? from what I know the latest was 15.5 ? then it was replaced by SCC.

Thanks

[dawn_kim · Accepted solution]

The last drop of Sybase Central was in the early version of PC-Client 15.7. They pulled it from PC-Client 15.7 SP100 and later. Sybase Central was never certified with Windows 8, Windows 2012.
So this customer must have an older installation of PC-Client. Sybase Central did support ssl.

Thanks,
Dawn Kim

[Former Member · Accepted solution]

Thanks for the detailed information

[william-paul_philibert]

Thanks Dawn,

    after reading your post I went trough the file, checking first permissions and state and after that I went trough the file structure.

I found out that, even though the structure was working correctly from isql command line, it was not correct for Sybase Central.  I did not have comma separating the port number and the ssl definition.

Wrong :

[SERVER]

query=tcp,ether,srvname,5555 ssl="cn=commonname"

query=tcp,ether,srvname,5555 ssl="cn=commonname"

Good:

[SERVER]

query=tcp,ether,srvname,5555,ssl="cn=commonname"

query=tcp,ether,srvname,5555,ssl="cn=commonname"

Working perfectly now.

Cheers