sybase odbc driver client unable to establish a connection

[Former Member]

Please some one help me at this. I am new to sysbase.

I am try to create dsn name for sysbase.

While connecting sysbase i gave sa as user name and administrator as password.

Its connecting and show master db and some other db.

After that i am trying to create dsn. While i creating dsn i gave

1) Hostname as my system hostname.

2) Database name as master db

3) Logon Id as sa (sa is my user name i gave)

4) Port : 5000

When i click test connection it asked password. i gave as administrator.

After few seconds it show sybase odbc driver client unable to establish a connection error.

I provide screenshot what i did and what error is occured.

Please guide me at this.

[former_member182259]

Is this for an SAP installation or non-SAP (yes, I know you posted in SAP applications SCN, but.....a lot of folks don't pay attention).

....if SAP, then the default installation for SAP on ASE requires password encryption - which you would have to tell your DSN to enable.

[Former Member]

This sysbase is automatically installed when i installed IPOCC.

I installed this IPOCC server in vmware using ova file.

How should i enable the dsn? Where the option is?

Thanks for your reply.

[dawn_kim]

Hi Srinivasan,

This is the first thing I noticed. You have a Windows 2012 R2 box. Make sure you install the SDK 15.7 SP130 or later or SDK 16.0 PL04 or later. We just got the SDK certified with the R2 box so the installation runs correctly.

Second thing, when you run the odbc manager if you are creating a system dsn you need to start the Windows odbc manager as administrator on a Windows 2012 or Windows 8 box or you get permission issues on this system.

Third thing you should pay attention to is if the application is a 32 or 64 bit application. This decides if you run the 32 or 64 bit Windows odbc manager.

If your still having problems please tell me and I will investigate. I got a Windows 2012 R2 box with SDK 15.7 SP130 and it seems to be working fine.

Thanks,
Dawn Kim