Thank you Michael,
The newer releases require these DLLs. It's required for some security
functioanlity - so though
the DLLs need to be accessed and loaded they aren't used.
Sorry about missing that - still getting used to it myself.
So, Kenn, see if this helps in loading the Provider.
Are you using ASP.NET with IIS?
-Paul
"Michael Garza" <mikeagarza@gmail.com> wrote in message
news:4b4cc67f$1@forums-1-dub...
> There is another newsgroup posting called "Anyone tried using the
> Sybase.AdoNet2.AseClient from ASP.NET?" which mentions that you need to
> include the following DLLs along with sybdrvado20.dll. I've come to find
> that we need to do this for our WinForms application as well.
>
> msvcr80.dll
> sybcsi_certicom_fips26.dll
> sybcsi_core26.dll
> sbgse2.dll
>
>
> "kenn.minear" wrote in message news:4b4cbf5b.53d3.1681692777@sybase.com...
>> Hi Paul,
>>
>> In my bin directory I have Sybase.AdoNet2.AseClient.dll
>> (version 2.155.1000.0) and sybdrvado20.dll (version
>> 2.155.1000.0).
>>
>> I gave up on using GetSchema and instead query the
>> syscolumns table directly which works well for me, Sybase is
>> the only database I connect to that requires an explicit
>> conversion from integer to varchar, the six other databases
>> I connect to will do that implicitely.
>>
>> My new error is when I try to load the AseDataAdapter, my
>> code is:
>>
>> IDbDataAdapter idbAdapter = null;
>>
>> idbAdapter =
>> (IDbDataAdapter)Activator.CreateInstance(typeof(Sybase.Data.AseClient.AseDataAdapter));
>>
>>
>> And the result is:
>>
>> Could not load file or assembly 'Sybase.AdoNet2.AseClient,
>> Version=2.155.1000.0, Culture=neutral,
>> PublicKeyToken=95d94fac46c88e1e' or one of its dependencies.
>> The located assembly's manifest definition does not match
>> the assembly reference. (Exception from HRESULT: 0x80131040)
>>
>> Should I open a new thread?
>>
>> Regards, Kenn
>>
>>
>>
>>> Hi Kenn,
>>>
>>> What sort of application are you running here and please
>>> indicate exactly how you deployed the DLLs.
>>>
>>> Thank you,
>>>
>>> -Paul
>>>
>>> <kenn.minear> wrote in message
>>> > news:4b478162.28b8.1681692777@sybase.com... Hello, well
>>> > I found Sybase.AdoNet2.AseClient.dll and changed the
>>> > reference to the new dll in my project. I kept
>>> sybdrvado20.dll in my bin path, but when I run my app I
>>> > get this exception:
>>> >
>>> > System.IO.FileLoadException was unhandled
>>> > Message="Could not load file or assembly
>>> > 'Sybase.AdoNet2.AseClient, Version=2.155.1000.0,
>>> > Culture=neutral, PublicKeyToken=95d94fac46c88e1e' or one
>>> > of its dependencies. The located assembly's manifest
>>> > definition does not match the assembly reference.
>>> > (Exception from HRESULT: 0x80131040)"
>>> >
>>> > Obviously a DLL mismatch. I suspect sybdrvado20.dll.
>>> >
>>> > Any ideas?
>>> >
>>> > Regards and thanks for your help, Kenn
>>>
>>>
|