ASE Database forum - OLEDB variety

Author

OLEDB variety

Frank Rizzo

2005-10-28, 3:24 am

Hello,

It seems that there is a variety of OLEDB providers out there for Sybase
all with different Provider names.

Is there a guide somewhere that lists them all with the required
Provider tokens that are needed in the connection string.

Paul

2005-10-28, 8:24 pm

Hi Frank,

Sybase has 2 different OLEDB releases now. On this table of info - it
compares the OEM version (DataDirect) with the Sybase built version:

OLE DB Provider Product Differences
OEM
OLE DB Provider Name (Long) Sybase ASE OLE DB Provider
OLE DB Provider Name (Short) Sybase.ASEOLEDBProvider
Latest Version String (Format) 12.5.1/P-EBF12833 ESD #10/02.70.0053
Filename sydaase.dll
Directory %SYBASE%\OLEDB

SYBASE
OLEDB Provider Name (Long): ASE OLE DB Provider
OLEDB Provider Name (Short): ASEOLEDB
Latest Version String: 12.5.1.475 (OCS ESD#10 EBF 12833) (Also there is
a release in OCS SDK 15.0 ESD#1 15.0.0.51 or higher)
Filename: sybdrvoledb.dll
Directory: %SYBASE%\DataAccess\
OLEDB\dll

With the 15.0 release of ASE and OCS SDK, there will no longer be the OEM
version of Provider, only the Sybase version.

For the docs I will provide you with the links to the 12.5.1 versions since
you are probably on that level of SDK, and I will provide the 15.0 doc link
for the ASE OLE DB Provider by Sybase:

The docs contain sections on the connection strings, supported datatypes,
etc. Our (Sybase) docs include some info on advanced features (SSL, LDAP,
Etc...)

OEM : Reference Manual:
http://www.datadirect.com/download/...ref/coleref.zip

Sybase

12.5.1:
This is all the SDK doc: http://sybooks.sybase.com/sdg1251e.html
This is for OLEDB: http://download.sybase.com/pdfdocs/sdg1251e/oledb.pdf

15.0
SDK: It uses eclipse so it is a littel strange to me:
http://sybooks.sybase.com/sdg1500e.html
or
http://infocenter.sybase.com/help/i...dk_15/title.htm

OLEDB:
http://infocenter.sybase.com/help/t...oledb/oledb.pdf

These are the 2 Providers I know of and work with. Let me know if you have
other questions on this.
Both of these Products are written to use the TDS specification directly
(communication protocol for ASE client to ASE server).

-Paul

"Frank Rizzo" <none@none.net> wrote in message news:4361c6a3@forums
-1-dub...
> Hello,
>
> It seems that there is a variety of OLEDB providers out there for Sybase
> all with different Provider names.
>
> Is there a guide somewhere that lists them all with the required
> Provider tokens that are needed in the connection string.

Frank Rizzo

2005-10-28, 8:24 pm

When I create a .UDL file and create a connection string with it, the
Provider token is set to Sybase.ASEOLEDBProvider.2. Is that the same as
Sybase.ASEOLEDBProvider?

Thanks

Paul wrote:
> Hi Frank,
>
> Sybase has 2 different OLEDB releases now. On this table of info - it
> compares the OEM version (DataDirect) with the Sybase built version:
>
> OLE DB Provider Product Differences
> OEM
> OLE DB Provider Name (Long) Sybase ASE OLE DB Provider
> OLE DB Provider Name (Short) Sybase.ASEOLEDBProvider
> Latest Version String (Format) 12.5.1/P-EBF12833 ESD #10/02.70.0053
> Filename sydaase.dll
> Directory %SYBASE%\OLEDB
>
>
> SYBASE
> OLEDB Provider Name (Long): ASE OLE DB Provider
> OLEDB Provider Name (Short): ASEOLEDB
> Latest Version String: 12.5.1.475 (OCS ESD#10 EBF 12833) (Also there is
> a release in OCS SDK 15.0 ESD#1 15.0.0.51 or higher)
> Filename: sybdrvoledb.dll
> Directory: %SYBASE%\DataAccess\
OLEDB\dll
>
> With the 15.0 release of ASE and OCS SDK, there will no longer be the OEM
> version of Provider, only the Sybase version.
>
> For the docs I will provide you with the links to the 12.5.1 versions since
> you are probably on that level of SDK, and I will provide the 15.0 doc link
> for the ASE OLE DB Provider by Sybase:
>
> The docs contain sections on the connection strings, supported datatypes,
> etc. Our (Sybase) docs include some info on advanced features (SSL, LDAP,
> Etc...)
>
> OEM : Reference Manual:
> http://www.datadirect.com/download/...ref/coleref.zip
>
> Sybase
>
> 12.5.1:
> This is all the SDK doc: http://sybooks.sybase.com/sdg1251e.html
> This is for OLEDB: http://download.sybase.com/pdfdocs/sdg1251e/oledb.pdf
>
> 15.0
> SDK: It uses eclipse so it is a littel strange to me:
> http://sybooks.sybase.com/sdg1500e.html
> or
> http://infocenter.sybase.com/help/i...dk_15/title.htm
>
> OLEDB:
> http://infocenter.sybase.com/help/t...oledb/oledb.pdf
>
> These are the 2 Providers I know of and work with. Let me know if you have
> other questions on this.
> Both of these Products are written to use the TDS specification directly
> (communication protocol for ASE client to ASE server).
>
> -Paul
>
>
> "Frank Rizzo" <none@none.net> wrote in message news:4361c6a3@forums
-1-dub...
>
>
>
>

Frank Rizzo

2005-10-29, 8:24 pm

Thank you, Paul.
Is there a correct (sybase approved, so to speak) programmatic way to
determine which one is installed?
I wrote up the following pseudo method.

if %SYBASE%\OLEDB exists then
use Sybase.ASEOLEDBProvider provider
elseif %SYBASE%\DataAccess\
OLEDB\dll exists then
use ASEOLEDB provider
else
Provider is NOT installed.
Install my own set of drivers
end if

Is this the right way to proceed? Or can I look in the registry
somewhere to locate the right driver?

In addition, can both sets of drivers be installed? Will they conflict
with each other?

Thanks.

Paul wrote:
> Hi Frank,
>
> Sybase has 2 different OLEDB releases now. On this table of info - it
> compares the OEM version (DataDirect) with the Sybase built version:
>
> OLE DB Provider Product Differences
> OEM
> OLE DB Provider Name (Long) Sybase ASE OLE DB Provider
> OLE DB Provider Name (Short) Sybase.ASEOLEDBProvider
> Latest Version String (Format) 12.5.1/P-EBF12833 ESD #10/02.70.0053
> Filename sydaase.dll
> Directory %SYBASE%\OLEDB
>
>
> SYBASE
> OLEDB Provider Name (Long): ASE OLE DB Provider
> OLEDB Provider Name (Short): ASEOLEDB
> Latest Version String: 12.5.1.475 (OCS ESD#10 EBF 12833) (Also there is
> a release in OCS SDK 15.0 ESD#1 15.0.0.51 or higher)
> Filename: sybdrvoledb.dll
> Directory: %SYBASE%\DataAccess\
OLEDB\dll
>
> With the 15.0 release of ASE and OCS SDK, there will no longer be the OEM
> version of Provider, only the Sybase version.
>
> For the docs I will provide you with the links to the 12.5.1 versions since
> you are probably on that level of SDK, and I will provide the 15.0 doc link
> for the ASE OLE DB Provider by Sybase:
>
> The docs contain sections on the connection strings, supported datatypes,
> etc. Our (Sybase) docs include some info on advanced features (SSL, LDAP,
> Etc...)
>
> OEM : Reference Manual:
> http://www.datadirect.com/download/...ref/coleref.zip
>
> Sybase
>
> 12.5.1:
> This is all the SDK doc: http://sybooks.sybase.com/sdg1251e.html
> This is for OLEDB: http://download.sybase.com/pdfdocs/sdg1251e/oledb.pdf
>
> 15.0
> SDK: It uses eclipse so it is a littel strange to me:
> http://sybooks.sybase.com/sdg1500e.html
> or
> http://infocenter.sybase.com/help/i...dk_15/title.htm
>
> OLEDB:
> http://infocenter.sybase.com/help/t...oledb/oledb.pdf
>
> These are the 2 Providers I know of and work with. Let me know if you have
> other questions on this.
> Both of these Products are written to use the TDS specification directly
> (communication protocol for ASE client to ASE server).
>
> -Paul
>
>
> "Frank Rizzo" <none@none.net> wrote in message news:4361c6a3@forums
-1-dub...
>
>
>
>

Frank Rizzo

2005-10-29, 8:24 pm

So, my understanding is that ASE 15 Client piece will ship with
sybdrvoledb.dll, while the ASE 12.5.x or lower ships with sydaase.dll.
Correct?

Thanks.

Paul wrote:
> Hi Frank,
>
> Sybase has 2 different OLEDB releases now. On this table of info - it
> compares the OEM version (DataDirect) with the Sybase built version:
>
> OLE DB Provider Product Differences
> OEM
> OLE DB Provider Name (Long) Sybase ASE OLE DB Provider
> OLE DB Provider Name (Short) Sybase.ASEOLEDBProvider
> Latest Version String (Format) 12.5.1/P-EBF12833 ESD #10/02.70.0053
> Filename sydaase.dll
> Directory %SYBASE%\OLEDB
>
>
> SYBASE
> OLEDB Provider Name (Long): ASE OLE DB Provider
> OLEDB Provider Name (Short): ASEOLEDB
> Latest Version String: 12.5.1.475 (OCS ESD#10 EBF 12833) (Also there is
> a release in OCS SDK 15.0 ESD#1 15.0.0.51 or higher)
> Filename: sybdrvoledb.dll
> Directory: %SYBASE%\DataAccess\
OLEDB\dll
>
> With the 15.0 release of ASE and OCS SDK, there will no longer be the OEM
> version of Provider, only the Sybase version.
>
> For the docs I will provide you with the links to the 12.5.1 versions since
> you are probably on that level of SDK, and I will provide the 15.0 doc link
> for the ASE OLE DB Provider by Sybase:
>
> The docs contain sections on the connection strings, supported datatypes,
> etc. Our (Sybase) docs include some info on advanced features (SSL, LDAP,
> Etc...)
>
> OEM : Reference Manual:
> http://www.datadirect.com/download/...ref/coleref.zip
>
> Sybase
>
> 12.5.1:
> This is all the SDK doc: http://sybooks.sybase.com/sdg1251e.html
> This is for OLEDB: http://download.sybase.com/pdfdocs/sdg1251e/oledb.pdf
>
> 15.0
> SDK: It uses eclipse so it is a littel strange to me:
> http://sybooks.sybase.com/sdg1500e.html
> or
> http://infocenter.sybase.com/help/i...dk_15/title.htm
>
> OLEDB:
> http://infocenter.sybase.com/help/t...oledb/oledb.pdf
>
> These are the 2 Providers I know of and work with. Let me know if you have
> other questions on this.
> Both of these Products are written to use the TDS specification directly
> (communication protocol for ASE client to ASE server).
>
> -Paul
>
>
> "Frank Rizzo" <none@none.net> wrote in message news:4361c6a3@forums
-1-dub...
>
>
>
>

Paul

2005-10-31, 8:24 pm

Hi Frank

To answer your questions:

15.0 will only ship sybdrvoledb.dll (Sybase built) while 12.5.1 will ship
both OEM and the Sybase version (this was done so programmers could start
getting used to the new stuff, compare them, migrate etc.)

The 2 products can co-exist together on the same machine.

There is no programmatic way I know of to "easily" tell which provider you
are using. Something like this:

if %SYBASE%\OLEDB exists then
use Sybase.ASEOLEDBProvider provider
elseif %SYBASE%\DataAccess\
OLEDB\dll exists then
use ASEOLEDB provider
else
Provider is NOT installed.
Install my own set of drivers
end if

Would probably work - and then your code would build the appropriate
connection string. You could also search the registry to see if
ASEOLEDBProvider (OEM) or ASEOLEDB (sybase) exist.

-Paul

"Frank Rizzo" <none@none.net> wrote in message
news:4363e513$1@foru
ms-1-dub...[color=darkred]
> So, my understanding is that ASE 15 Client piece will ship with
> sybdrvoledb.dll, while the ASE 12.5.x or lower ships with sydaase.dll.
> Correct?
>
> Thanks.
>
> Paul wrote:
is[color=darkred]
OEM[color=darkred]
since[color=darkred]

link[color=darkred]
datatypes,[color=dar
kred]
LDAP,[color=darkred]

http://download.sybase.com/pdfdocs/sdg1251e/oledb.pdf[color=darkred]
http://infocenter.sybase.com/help/i...dk_15/title.htm[color=darkred]
http://infocenter.sybase.com/help/t...oledb/oledb.pdf[color=darkred]
have[color=darkred]
news:4361c6a3@forums
-1-dub...[color=darkred]

Sponsored Links