Re: database dilemma

From: Dominique Vandensteen (domi.vds_insert_at_tralala_tenforce.com)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 07:55:36 +0100

> Dot net uses SQL Server and Oracle ( check the help for the supported
> versions ) most efficiently as it has native drivers for these databases
> Other databases use ODBC which work but with an overhead.

just for information, there are native drivers for other db's also

"James Lang" <j.lang@blueyonder.co.uk> wrote in message
news:%23rOfA%23O9DHA.3648@TK2MSFTNGP11.phx.gbl...
> Hi
> Dot net uses SQL Server and Oracle ( check the help for the supported
> versions ) most efficiently as it has native drivers for these databases
> Other databases use ODBC which work but with an overhead.
> on the down side both sql server and oracle are big bucks to a small
> company. If you don't have them already it would be a big outlay.
> Also think about scalability, how big will the data get and how many
> concurrent users at any one time. Will the data be held in one location
or
> replicated over many servers
>
> From what you wrote I assume you will be using ASP.NET, ADO.NET WEB Forms
> and Windows forms
> if you are new to this ( even seasoned ASP and VB6 pros would struggle for
a
> while ) you might want to push for some training courses and what ever
time
> scale you come up with DOUBLE IT
> I hope this helps
>
> Regards
> James
>
> "John" <anonymous@discussions.microsoft.com> wrote in message
> news:0FACB353-B348-4FC3-B41E-75593E2DDAD2@microsoft.com...
> > Greetings. I apologize for posting this if it is in the wrong group.
The
> boss last week dropped vb.net on my desk and wants to create a web app and
a
> corresponding desktop app. And I'm a newbie to vb.net. Have done vb6
work
> but not alot. The boss only dropped vb.net and no db to go with it. He
> indicated for me to use my best judgement on the db.
> > So, I would like to find out what db others of you are using with vb.net
> for over the web/desktop. I've worked with A2k so I'm familiar with that.
> What about some of the others? Are there pros/cons? Is there a consensus
> among vb.net developers? What does vb.net work best with?
> > I am open to any thoughts and suggestions.
> > Thanks in advance to anyone who responds.
> > *** John
>
>

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: database dilemma
    ... Dot net uses SQL Server and Oracle (check the help for the supported ... Other databases use ODBC which work but with an overhead. ... boss last week dropped vb.net on my desk and wants to create a web app and a ...
    (microsoft.public.dotnet.languages.vb)
  • MS SQL server Meata data question
    ... I have sql server 2000 up and running and using the provided ... browsing tools poked around and found that the databases in the system were ... the native php support for sql server doesn't have meta data functions like ... I need to do this for Oracle too but I think the native support for Oracle ...
    (comp.lang.php)
  • Re: Data access perfomance
    ... Sorry, I'm using Sql Server and Oracle 9i, on both databases the process is ... >> Databases and I fell like I've perfomance problems inserting into the DB. ... >> I insert the data after I've finished reading the xml file. ...
    (microsoft.public.data.oledb)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
Loading