Connection String Changes in Different ASE Client Versions

[Former Member]

When we migrated from Sybase client (Adaptive Server Enterprise?) 12.5 to 15.5 there were changes in the connection string format:

Under Sybase 12.5, connection strings typically looked like this:

Provider=Sybase.ASEOLEDBProvider.2;Data Source=APPLICATION;Initial Catalog=R01223;User ID=$USER;Password=$PASSWORD

The equivalent string for Sybase 15.5 looks like this:

Provider=Sybase OLEDB Provider;Data Source=application.domain.com:8000;Initial Catalog=R01223;User ID=$USER;Password=$PASSWORD

Now, in 15.7, the connection string appears to have changed again:

Provider=ASEOLDB;Data Source=application.domain.com:8000;Initial Catalog=R01223;User ID=$USER;Password=$PASSWORD

Is there a way for me to upgrade to 15.7 SP136 without having to force another connection string change?

[former_member343861]

Hi Mr. Schmitt,

The “SAP” branding was added to SDK components (& ASE) as part of the 16.0 release.

The 15.7 version of the OLEDB driver seems to have picked this up from 15.7 SP124 release.

Short name     Long Name

ASEOLEDB     SAP ASE OLE DB Provider

The short name has not changed.

You can try changing the ASEOLEDB and ASEOLEDB.1 name to Sybase ASE OLE DB Provider in the Registry Editor.

Thanks,

Ron Nero