Accessing a database from a class library

I'd like to do some database access from a class library. All of the ways I'm familiar with for adding database connectivity revolve around a Windows Form and dragging stuff onto it. These facilities don't exist for a class library really.

What is the prefered way to do this? Should I create a dummy winform for the sole purpose of hosting the database objects? Or are there ways to manually create the database objects in the library itself. The thing that seems to tripping me up however is that all of the classes get customized and generated when you drag them over and that aspect would be missing if I were to "roll it by hand"

Thanks

Bill

There are a number of examples of providing data access from a class library.

I believe this article on creating strongly typed datasets, will work within a class library project as well.

Access Reports via URL

Hi,
I figured, that I can call reports directly via URL and pass the
appropriate parameters in the URL when adding '&mypara=value'.
So far so good. But I could not figure out so far, how I can pass
parameters that allow "multiselections". Using the above notation
doesn't seem to work ... :(
--
Henning Eiben
busitec GmbH
Consultant
e-mail: eiben@.busitec.de
+49 (251) 13335-0 Tel
+49 (251) 13335-35 Fax
Rudolf-Diesel-Straße 59
48157 Münster
www.busitec.de
Sitz der Gesellschaft: Münster
HR B 55 75 - Amtsgericht Münster
USt-IdNr. DE 204607833 - St.Nr. 336/5704/1277
Geschäftsführer: Simon Böwer, Henning Eiben, Stefan Kühn, Martin Saalmann
--
... There are 10 kinds of people. Those who know binary code, and those
who don't.On Aug 24, 2:05 am, Henning Eiben <ei...@.busitec.de> wrote:
> Hi,
> I figured, that I can call reports directly via URL and pass the
> appropriate parameters in the URL when adding '&mypara=3Dvalue'.
> So far so good. But I could not figure out so far, how I can pass
> parameters that allow "multiselections". Using the above notation
> doesn't seem to work ... :(
> --
> Henning Eiben
> busitec GmbH
> Consultant
> e-mail: ei...@.busitec.de
> +49 (251) 13335-0 Tel
> +49 (251) 13335-35 Fax
> Rudolf-Diesel-Stra=DFe 59
> 48157 M=FCnsterwww.busitec.de
> Sitz der Gesellschaft: M=FCnster
> HR B 55 75 - Amtsgericht M=FCnster
> USt-IdNr. DE 204607833 - St.Nr. 336/5704/1277
> Gesch=E4ftsf=FChrer: Simon B=F6wer, Henning Eiben, Stefan K=FChn, Martin =Saalmann
> --
> ... There are 10 kinds of people. Those who know binary code, and those
> who don't.
This link might help.
http://www.esa-server.net/index.php?option=3Dcom_content&task=3Dview&id=3D1=
14&Itemid=3D103&lang=3Den
Regards,
Enrique Martinez
Sr. Software Consultant|||http://ServerName/reportserver?/FolderName/ReportName&Param1=value1&Param2=value2
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henning Eiben" <eiben@.busitec.de> wrote in message
news:%23VLf70h5HHA.1208@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I figured, that I can call reports directly via URL and pass the
> appropriate parameters in the URL when adding '&mypara=value'.
> So far so good. But I could not figure out so far, how I can pass
> parameters that allow "multiselections". Using the above notation
> doesn't seem to work ... :(
> --
> Henning Eiben
> busitec GmbH
> Consultant
> e-mail: eiben@.busitec.de
>
> +49 (251) 13335-0 Tel
> +49 (251) 13335-35 Fax
> Rudolf-Diesel-Straße 59
> 48157 Münster
> www.busitec.de
> Sitz der Gesellschaft: Münster
> HR B 55 75 - Amtsgericht Münster
> USt-IdNr. DE 204607833 - St.Nr. 336/5704/1277
> Geschäftsführer: Simon Böwer, Henning Eiben, Stefan Kühn, Martin Saalmann
>
> --
> ... There are 10 kinds of people. Those who know binary code, and those
> who don't.

Access denied while adding node

I have a SQL Server 2k cluster setup on one node and I'm trying to add it to the second one. I already have the two server clustered with MSDTC, however I cannot get the SQL install to add the second node. Every time I run the setup to add it I receive
the following error: "An error occurred while creating virtual server resources for clustering. Access is Denied". I have tried several methods of the install but with no success. Any help would be greatly appreciated.
Ed
Is the account you are using to run the installation a domain user who is a
local admin on both machines?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Check KB article 273769 and see if that describes your problem.
|||Unfortunately, no. I chose Per Seat licensing from the beginning.
|||Yes, I am using my domain admin account to install the second node and also have the same username as an administrator on both servers.