Establishing a connection to data

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Establishing a connection to data

Message

From

23/10/2007 23:13:48

Kevin Goff
Pennsylvania, United States

23/10/2007 17:44:37

Dave Nantais
Light speed database solutions
Ontario, Canada

General information

Forum:

ASP.NET

Category:

Reporting

Title:

Re: Establishing a connection to data

Environment versions

Environment:

C# 2.0

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Miscellaneous

Thread ID:

01262931

Message ID:

01262951

Views:

Dave,

In general, I don't establish connections to SQL Server from the report - for the same reason that I wouldn't make database connections from a Windows Form.

I always use ADO.NET or XML or something disconnected - that way the report can run in situations where the report resides on a different layer than the database.

Kevin

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313

Map

View

Click here to load this message in the networking platform