Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP.NET Data Source - Clients/Web Server

Thread Tools

ASP.NET Data Source - Clients/Web Server

trevor oakley
Posts: n/a
I have solved an earlier problem which I posted here, about coding Data
Source in OleDbConnection - I am new to ASP.Net. I do not understand the
solution, I just blindly followed the book (Teach Yourself ASP.NET in 21
Days), and guessed, and it worked.

When OleDbConnection is used to connect to a database, ASP.NET appears to
expect a client source, not a Web server reference. I just coded
c:\WWWRoot\.... and it worked.

Does this mean that ASP.NET downloads a database, like HTML pages are
downloaded, and then uses the actual client? I find such a concept to be
unbelieveable, or does ASP.NET download only a database definition? In any
case it is dangerous to download anything to the client regarding a database
due to security.

I expected the Web server to handle the data query and only generated HTML,
including the data query or update message, to be downloaded to client, and
the client to have no knowledge about the database. Therefore, I find it
difficult to understand why a harddrive reference should be included
anywhere in database connection code.

Code: dbStr="c:wwwroot\...", objConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _
& " Data Source=" & dbStr & ";")

I would be grateful for any clarification on this?


Reply With Quote
Natty Gur
Posts: n/a
Trevor Hi,

OleDBConnection class is part of the CLR classes and it can be used on
the SERVER side to generate HTML that will be sending to the client. So
the local path is the server local path. Neither the OLEDBConnection
will happened on the client machine nor the DB will be download to the

Natty Gur, CTO
Dao2Com Ltd.
28th Baruch Hirsch st. Bnei-Brak
Israel , 51114

Phone Numbers:
Office: +972-(0)3-5786668
Fax: +972-(0)3-5703475
Mobile: +972-(0)58-888377

Know the overall picture

*** Sent via Developersdex ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Object data source, setting parameter source to Page.Partner.Guid Allan Ebdrup ASP .Net Web Controls 2 10-06-2006 10:24 AM
Need some ideas to selectively fetch data via object data source or cache... Siva ASP .Net 1 04-24-2006 08:54 PM
Need advice on paging data from data source. Ken Varn ASP .Net 4 01-19-2005 05:35 PM
Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software ) Author Tarun Tyagi C Programming 0 12-29-2004 05:10 PM
Data Recovery SOURCE CODE ( SOURCE CODES of Professional Data Recovery Software ) Author Tarun Tyagi Cisco 0 12-29-2004 05:03 PM