Re: Connecting to Sybase ASE from MS SQL Server 2005 Integration Services via OLEDB provider connection....
Matthew P. Seltzer
So far, so good. The 15.0.3 components work very nicely with SSIS 2005.
Am hoping that my good luck holds out!
Best,
Matt
"Paul Vero [Sybase]" <pv...@nospam.com> wrote in message
news:4a2ffc82$1@forums-1-dub...
> Hi Matthew,
>
> yes the drivers are okay to use with ASE 12.5.X, just don't go lower.
>
> You can download them - they are under the SDK 15.0 for Winx86 (32 bit) or
> Winx64.
> I believe you need to be licensed to use the SDK.
>
> Also they're available on the ASE PC Client - but I think 15.0 starts from
> ASE 12.5.4 and up.
>
> -Paul
>
>
> "Matthew P. Seltzer" <msel...@fideliscare.org> wrote in message
> news:4a2e7488$1@forums-1-dub...
>> Hello, Paul,
>> We are at ASE version 12.5--are the 15.0.x components
>> backward-compatible? (Can they also be downloaded from Sybase's web
>> site?)
>>
>> TIA,
>>
>> Matt P. Seltzer
>> "Paul Vero [Sybase]" <pv...@nospam.com> wrote in message
>> news:4a2e6f16@forums-1-dub...
>>> Hi Matthew,
>>>
>>> Have you tried using the ASE OLE DB Provider by Sybase (Included in the
>>> SDK 15.0
>>> for PC Windows, or included on PC Client for Windows distributed with
>>> ASE 15.0.X)?
>>>
>>> It should work okay - in fact, Sybase prefers you use the OLE DB
>>> Provider since the
>>> SSIS uses OLEDB API.
>>>
>>> If you run into issues let me know in this forum.
>>>
>>> -Paul
>>>
>>>
>>> "Matthew P. Seltzer" <msel...@fideliscare.org> wrote in message
>>> news:4a2e60ff@forums-1-dub...
>>>> ...has anyone succeeded in doing this? I have had to use an ODBC
>>>> connection in SSIS to connect to ASE, which I would rather not do.
>>>>
>>>>
>>>>
>>
>>
Paul Vero [Sybase]
Sounds good. Keep in mind you should be able to download SDK 15.0 ESDs from
the Sybase
download site. The current level is 15.0 ESD#18 (OLE DB File version for
sybdrvoledb.dll is 15.0.0.350)
If you do encounter difficulty try the esd to see if it resolves. If
trouble still occurs open a case
with Tech Support here at Sybase so we can investigate.
-Paul
"Matthew P. Seltzer" <msel...@fideliscare.org> wrote in message
news:4a3b...@forums-3-dub.sybase.com...
Paul Vero [Sybase]
Sounds good. Keep in mind you should be able to download SDK 15.0 ESDs from
the Sybase
download site. The current level is 15.0 ESD#18 (OLE DB File version for
sybdrvoledb.dll is 15.0.0.350)
If you do encounter difficulty try the esd to see if it resolves. If
trouble still occurs open a case
with Tech Support here at Sybase so we can investigate.
-Paul
"Matthew P. Seltzer" <msel...@fideliscare.org> wrote in message
news:4a3b...@forums-3-dub.sybase.com...
Paul Vero [Sybase]
Sounds good. Keep in mind you should be able to download SDK 15.0 ESDs from
the Sybase
download site. The current level is 15.0 ESD#18 (OLE DB File version for
sybdrvoledb.dll is 15.0.0.350)
If you do encounter difficulty try the esd to see if it resolves. If
trouble still occurs open a case
with Tech Support here at Sybase so we can investigate.
-Paul
"Matthew P. Seltzer" <msel...@fideliscare.org> wrote in message
news:4a3b...@forums-3-dub.sybase.com...