How do I configure a 15.7.0.80 client?

[Former Member]

We have been using Sybase client 12.5.1 to connect to Sybase ASE 12.5.4 with PowerBuilder 12.5.1 (build 4015).  Now we have PCs with the Sybase client 15.7.0.80 installed.  I tried to just update the general information but the test connection fails.  Any help on how to configure the client's data source to be able to connect to the database appreciated ... SBC 101 on moving from one client to the next.

[Former Member]

Make sure you use the ASE driver instead of SYC in your PowerBuilder app / DB Profile.

[Former Member]

Hi Da;

  Here is an example of what I use for my ASE 15.7.x connection ....

// Profile DEV_Repository

SQLCA.DBMS = "ASE Adaptive Server Enterprise"

SQLCA.Database = "PCI_Repository"

SQLCA.LogPass = <********>

SQLCA.ServerName = "DEVCI2"

SQLCA.LogId = "<xxxxxxxxxxx>"

SQLCA.AutoCommit = False

SQLCA.DBParm = "PacketSize=2048,Async=1,AppName='PowerBuilder 12.5,1',Host='DEV99999"

Note: Your Server Name has to be in the SQL.ini file of the ASE 15.7 client.

HTH

Regards ... Chris

[Former Member]

The attached file contains the GUI used in the client software for configuration.  I want to use the test connection button in the client software.  The connection fails because I am guessing on values.  The 12 client has very little while the 15 client has many tab pages.  I know I have settings in PB also, but how do I map those values to the GUI?  For example, what was my prior server address had characters plus the port.  In 15 there is no server address to enter but a port field that doesn't allow characters.

[Former Member]

Here's what my dsedit looks like for ASE 15...

You need to specify the server address info. Separate the server and port with a comma.

Your screenshot list the server service as "SQL Server"? It should be "Adaptive Server Enterprise" if you're connecting to ASE 15x.

Make sure you're using the dsedit here too: C:\Sybase\OCS-15_0\bin

hth,

Mark

[Former Member]

Sorry, I thought the interface changed ... Attached, DSedit displays an error message whether running from the start menu or right from the folder.  BTW, I did not install the client but am just trouble shooting/trying to configure.

[Former Member]

I'm pretty sure you need to install the client.

[CobyKako]

Hello Da,

Which db profile are you using: ASE Sybase ASE 15.x?

Can you share your connection settings?

Did you enable some database tracing?

Can we get the error message you got or screenshots?

Thanks

Jacob