[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.inetserver.asp.db

michael kors wallet vgv

Katadedajab

12/27/2013 10:59:00 AM

<a href=http://www.electrolysis.ca><b&... kors bags</b></a>Fantastic issues altogether,all your family members do nothing more than won a logo many of the new reader. What might or might not your family recommend about your thanks for the that all your family do nothing more than made a short time a long time ago Any positive?<a href=http://www.synray.ca><b&... kors outlet</b></a>On going to be the numerous hand,it is certainly plausible are buying and taking Lingzi all of which is more or less quite effective on the treating certain ailments. The come in your 6 colors. These six, identified by their color, are easy to read into five different types according to their healing paths; violet and red are for joints, skin and going to be the heart; white is always that and for lungs; " green " also liver; white and then for spleen and intestines; and black along with brain and kidney. It could be the quite advanced and popular so that you have rich mainland visitors.<a href=http://www.electrolysis.ca><b&... kors wallet</b></a>My favorite almost any of comment is because going to be the a minumum of one that shouldn't exist. I owned or operated an all in one couple of you need to Wordpress sites where they use Facebook as going to be the commenting platform,but the footprint as well as for WP commenting having said all that comes into the world as part of your html document that means they be able to get words of flattery both to and from people which of you figured out coping with upper hand to learn more about the unused comment section... always organic gold to understand more about read those.<a href=http://www.electrolysis.ca><b&... kors outlet canada</b></a>Something amazing has to be that happening around your family Now I find a good deal more interesting thing by way of reading your home business,I get pleasure from life,appreciate my best family member and take pleasure in going to be the world<a href=http://www.hummingbirdhollow.ca><b&... kors outlet canada</b></a>
24 Answers

Miha Markic

9/12/2007 12:40:00 PM

0


"Kerry Moorman" <KerryMoorman@discussions.microsoft.com> wrote in message
news:7623F44B-23B4-4D31-8312-09552659487E@microsoft.com...
> Jonathan,
>
> If you want to write a program that works with SQL Server data then you
> must
> go through SQL Server.
>
> There is no way to access SQL Server data with ADO.Net (or any other
> technology) without SQL Server.

You could write and read directly from its files ;-).
Just kidding

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_...

Jonathan Wood

9/12/2007 1:52:00 PM

0

What I'm asking is if it's possible to write an ADO.NET Windows application
that doesn't require or use any type of server software. If I can just
access the database file directly using the ADO.NET built in to the .NET
framework.

If I'm still being unclear, for the purposes of this question, I do *NOT*
want the program to work with SQL Server.

Jonathan

"Kerry Moorman" <KerryMoorman@discussions.microsoft.com> wrote in message
news:7623F44B-23B4-4D31-8312-09552659487E@microsoft.com...
> Jonathan,
>
> If you want to write a program that works with SQL Server data then you
> must
> go through SQL Server.
>
> There is no way to access SQL Server data with ADO.Net (or any other
> technology) without SQL Server.
>
> Kerry Moorman
>
>
> "Jonathan Wood" wrote:
>
>> William,
>>
>> >>>> Yes, you can create an application without using a DBMS engine to
>> >>>> manage the data, but I expect you would be re-inventing a number of
>> >>>> cogs and wheels--all of which are available for free in one form or
>> >>>> another.
>>
>> So, if I want to access a database in a .NET application, are you saying
>> I
>> must either A) make certain the computer my application is running on has
>> server software such as MS SQL Server installed, or B) I must bypass
>> ADO.NET?
>>
>> There's no way ADO.NET can simply open and work with an MDF file directly
>> without database server software?
>>
>> Jonathan
>>
>>

Jonathan Wood

9/12/2007 2:43:00 PM

0

Kerry,

> You could work with a non-server DBMS such as Access through ADO.Net
> without
> needing Access installed.

Really, I can use an Access database without Access? Where would I find out
about this? Is a connection string still involved? What does it look like?
That's what I'm trying to find out.

> But for any of the server-type DBMSs like SQL Server, Oracle, DB2, etc.,
> you
> need the DBMS installed and then your ADO.Net code "talks to" the server
> DBMS.

Yes, I understand. If I want to access some sort of server software then
that software must be installed. The only purpose of this thread is to
explorer what options I have that don't involve these.

Jonathan

Kerry Moorman

9/12/2007 2:58:00 PM

0

Jonathan,

Here is an example of a connection string to connect to an Access mdb
database file named "myDB.mdb":

Dim cn As New OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=myDB.mdb;"))

Kerry Moorman


"Jonathan Wood" wrote:

>
> Really, I can use an Access database without Access? Where would I find out
> about this? Is a connection string still involved? What does it look like?
> That's what I'm trying to find out.
>
>
> Jonathan
>
>

Jonathan Wood

9/12/2007 3:03:00 PM

0

If that works with no additional software other than the .NET framework,
that is exactly what I'm looking for.

I'll check it out. Thanks.

Jonathan

"Kerry Moorman" <KerryMoorman@discussions.microsoft.com> wrote in message
news:6F761E34-14C8-48C3-87F7-1FC8209067D1@microsoft.com...
> Jonathan,
>
> Here is an example of a connection string to connect to an Access mdb
> database file named "myDB.mdb":
>
> Dim cn As New OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=myDB.mdb;"))
>
> Kerry Moorman
>
>
> "Jonathan Wood" wrote:
>
>>
>> Really, I can use an Access database without Access? Where would I find
>> out
>> about this? Is a connection string still involved? What does it look
>> like?
>> That's what I'm trying to find out.
>>
>>
>> Jonathan
>>
>>

Miha Markic

9/12/2007 3:08:00 PM

0

Jonathan,

Take note that JET driver (Access) is installed with MDAC (which is
installed along .net, too).
However, JET driver was pulled out of MDAC for a while (now it is back in)
and thus it isn't guaranteed to be available. I don't know which versions
are missing the JET out of my head.
--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_...

"Jonathan Wood" <jwood@softcircuits.com> wrote in message
news:OQjwB4U9HHA.484@TK2MSFTNGP06.phx.gbl...
> If that works with no additional software other than the .NET framework,
> that is exactly what I'm looking for.
>
> I'll check it out. Thanks.
>
> Jonathan
>
> "Kerry Moorman" <KerryMoorman@discussions.microsoft.com> wrote in message
> news:6F761E34-14C8-48C3-87F7-1FC8209067D1@microsoft.com...
>> Jonathan,
>>
>> Here is an example of a connection string to connect to an Access mdb
>> database file named "myDB.mdb":
>>
>> Dim cn As New OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0;Data
>> Source=myDB.mdb;"))
>>
>> Kerry Moorman
>>
>>
>> "Jonathan Wood" wrote:
>>
>>>
>>> Really, I can use an Access database without Access? Where would I find
>>> out
>>> about this? Is a connection string still involved? What does it look
>>> like?
>>> That's what I'm trying to find out.
>>>
>>>
>>> Jonathan
>>>
>>>
>

Jonathan Wood

9/12/2007 3:32:00 PM

0

Is it assumed I know what MDAC is? So, you're saying the OleDbConnection
string posted below may not work on all computers with the .NET framework
installed?

Jonathan

"Miha Markic" <miha at rthand com> wrote in message
news:OeOxt7U9HHA.5948@TK2MSFTNGP04.phx.gbl...
> Jonathan,
>
> Take note that JET driver (Access) is installed with MDAC (which is
> installed along .net, too).
> However, JET driver was pulled out of MDAC for a while (now it is back in)
> and thus it isn't guaranteed to be available. I don't know which versions
> are missing the JET out of my head.
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_...
>
> "Jonathan Wood" <jwood@softcircuits.com> wrote in message
> news:OQjwB4U9HHA.484@TK2MSFTNGP06.phx.gbl...
>> If that works with no additional software other than the .NET framework,
>> that is exactly what I'm looking for.
>>
>> I'll check it out. Thanks.
>>
>> Jonathan
>>
>> "Kerry Moorman" <KerryMoorman@discussions.microsoft.com> wrote in message
>> news:6F761E34-14C8-48C3-87F7-1FC8209067D1@microsoft.com...
>>> Jonathan,
>>>
>>> Here is an example of a connection string to connect to an Access mdb
>>> database file named "myDB.mdb":
>>>
>>> Dim cn As New OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0;Data
>>> Source=myDB.mdb;"))
>>>
>>> Kerry Moorman
>>>
>>>
>>> "Jonathan Wood" wrote:
>>>
>>>>
>>>> Really, I can use an Access database without Access? Where would I find
>>>> out
>>>> about this? Is a connection string still involved? What does it look
>>>> like?
>>>> That's what I'm trying to find out.
>>>>
>>>>
>>>> Jonathan
>>>>
>>>>
>>
>

Gregg Walker

9/12/2007 3:51:00 PM

0

http://www.connectionst...


Jonathan Wood

9/12/2007 5:59:00 PM

0

Miha,

>> Is it assumed I know what MDAC is? So, you're saying the OleDbConnection
>> string posted below may not work on all computers with the .NET framework
>> installed?
>
> Yes, it depends on the MDAC version installed (somebody might install a
> different version of MDAC regardless of version installed with .net).
> BTW here you'll find connection string definitions:
> www.connectionstrings.com

I wasn't sure what I was looking for at that link.

The bottom line for me is that I want my application to install painlessly
on customers' computers. When writing a Windows .NET application, I can
write my own code to save data to disk, or I can use the .NET database
stuff. If the database stuff either requires additional installations or is
not guaranteed to work on all computers with .NET, then I'll avoid it.

It sounds like you're saying it may not work on all computers with .NET, so
I should avoid the database routines for my desktop applications.

Thanks.

Jonathan

Jonathan Wood

9/12/2007 6:05:00 PM

0

Norman,

> Do not beconfused with application (you developed), application
> development framework (.NET Framework) and various type s of data source,
> be it server-base database system (MySQL, SQL Server, Oracle), or file
> base database system (Jet database, *.mdb/*.mde, or you can loosely call
> it Access database), or even a flat text file.

I didn't think I was confused on that issue.

> When you do ADO.NET app, you could then use a *.mdb file as data source
> (using OleDb namespace in ADO.NET), you could even use Excel sheet (*.xls)
> or comma delimited flat text as data source. In this case, yes you do not
> need anything else installed besides .NET.

Well, that's the exact info I'm after. However, it's a little confusing
because of Miha's comments that the "JET driver is installed with MDAC" and
that driver was "pulled out of MDAC for a while." This seemed to suggest to
me that, on some systems with .NET, additional drivers may be required to
use MDB files.

> However, if you need truy database system, then you have make your choice
> of database system products, which most likely is not a part of either
> Windows or .NET, and most likely, it cost money to buy and cost time to
> learn and use. In this case, you app might be a very small part of the
> entire system and cost the least to build.

That's the approach I'll take for Web development. Not for desktop
applications.

Thanks.

Jonathan