Deprecated: Function ereg() is deprecated in /rscs/rs/websites/lmpx.com/code/nav/common.inc on line 82

From:	kenn.minear	Date:	Tue Jan 12 22:52:41 2010
Subject:	Re: How to use connection.GetSchema()?

Hi, Yes I am using IIS and an ASP.Net application, also
using a standard WinForms application (using Gizmox
libraries to convert the WinForm app to an ASP.Net app).
Error occurs both under WinForms and under IIS. I will try
including the other dll's and follow up with a post on the
results.

Thanks for your response and help, regards, Kenn

> 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.Dat
> a.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
> >>>
> >>>
>
>