Re: Issues with connecting from .NET to Sybase ASE 12

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bruce Loehle-Conger (bruce_lcNOSPAM_at_hotmail.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 12:47:56 -0500

I have used both the ODBC and OLEDB providers. I have not used the dotnet
managed provider. Correct me if I am wrong but it would only use the
provider if you used the generic designer. At runtime it would use it but
during development only the oledb provider?

Bruce L-C

"Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message
news:%233M8BkweEHA.2028@tk2msftngp13.phx.gbl...
> I have not done it myself, but this should get you started with using
Sybase
> ASE 12 in Reporting Services:
>
> * First, you have to make sure the ASE data provider is installed
correctly,
> so that the report designer in VS.NET and report server inside ASP.NET are
> able to load the dlls of the data provider at runtime. Note: there could
be
> file system permissions issues which prevent ASP.NET from accessing the
ASE
> data provider dlls. You might want to try to copy the dlls directly into
the
> report designer and report server installation directories.
>
> * close down all VS.NET sessions before modifying rsReportDesigner.config
> * backup the existing rsReportDesigner.config and rsReportServer.config
>
> * Add these entries to rsReportDesigner.config in the Data section:
> <Extension Name="Sybase"
> Type="Sybase.Data.AseClient.AseConnection,Sybase.Data.AseClient"/>
> ... and in the Designer section:
> <Extension Name="Sybase"
>
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
>
> * Stop the ReportServer Windows service
> * Add this entry to rsReportServer.config in the Data section:
> <Extension Name="Sybase"
> Type="Sybase.Data.AseClient.AseConnection,Sybase.Data.AseClient"/>
> * Restart ReportServer Windows service
> * Reset IIS/ASP.NET by running iisreset from the command line
>
> There are several people on this newsgroups who have indicated they are
> using Sybase. Not sure if they have tried the managed Sybase provider.
>
> You might also want to read this thread:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f02812e9-65de-4007-a142-b689522d4c93&sloc=en-us
> As indicated in the thread, it should work on the report server, but I'm
not
> sure about the report designer. It will depend on how the Sybase ASE
> provider is implemented internally.
>
> Documentation on the config files:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_8iqq.asp
>
>
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Ian Allchin" <ian.allchin@talk21.com> wrote in message
> news:1f2dd58b.0408050554.4a18275d@posting.google.com...
> > Further to my earlier posting, I contacted Sybase who were helpful. I
> > have resolved the first issue. My Sybase installation was corrupted,
> > so I uninstalled completely. I then installed Sybase ASE 12.5.2 PC
> > Client which includes the ASE ADO .NET Provider. I have been able to
> > write a .NET Windows Forms application using this provider in very
> > much the same way as the SQL Server .NET Provider.
> >
> > Information about the Sybase ASE .NET Data Provider can be found at:
> >
> > http://sybooks.sybase.com/onlinebooks/group-adonet/asnetg0110e/adonet
> >
> > I AM STILL LOOKING FOR HELP ON HOW TO CONNECT TO SYBASE ASE 12 FROM A
> > SQL SERVER REPORTING SERVICES PROJECT. PLEASE RESPOND IF YOU HAVE ANY
> > INFORMATION.
> >
> > Ian Allchin
> > Alpha Ventures Limited, UK
>
>

Relevant Pages

  • Re: Issues with connecting from .NET to Sybase ASE 12
    ... I have not done it myself, but this should get you started with using Sybase ... ASE 12 in Reporting Services: ... so that the report designer in VS.NET and report server inside ASP.NET are ... able to load the dlls of the data provider at runtime. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Issues with connecting from .NET to Sybase ASE 12
    ... If you register any managed data provider in report designer and select it ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [Full-disclosure] Re: kiddie porn warning [was: Fwd: Re: montspace -- child porn (si
    ... A provider should initially call the National Center for Missing and Exploited Children to receive an identification number and a password that will enable it to log on to the section of the "Cyber Tipline" that is designed for provider reporting. ... Reporting of child pornography by electronic communication service providers ... Duty to report. ... Not later than 180 days after the date of enactment of this section, the Attorney General shall designate the law enforcement agency or agencies to which a report shall be forwarded under paragraph. ...
    (Full-Disclosure)
  • Re: Parameters and Combo Box
    ... acFormPivotChart ... ProviderID field and the Provider Name. ... In the Query that is the Report's Record Source, ... When ready to run the report, ...
    (microsoft.public.access.queries)
  • Re: IP announce DOS
    ... I don't think there is anyone you can report them to that will take ... Have you contacted your new ISP to try to resolve the issue through them? ... > running to our office provided by a local provider. ... and suddenly our old provider starts announcing these IPs again. ...
    (Security-Basics)