Re: database dilemma

From: James Lang (j.lang_at_blueyonder.co.uk)
Date: 02/17/04 

Date: Tue, 17 Feb 2004 00:46:35 -0000

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 ... > versions) most efficiently as it has native drivers for these databases ... > Other databases use ODBC which work but with an overhead. ...
    (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)
Quantcast