database dilemma

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Greetings. I apologize for posting this if it is in the wrong group. The
Click to expand...
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
Click to expand...
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?
 
John said:
Greetings. I apologize for posting this if it is in the wrong group. The
Click to expand...
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
Click to expand...
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
Click to expand...

You've got a number of good options. If your desktop app and web app
are relatively low volume, you should try MSDE:

http://www.microsoft.com/sql/msde/

It's a functional version of SQL Server with some concurrent connection
restriction, if I recall correctly. It also provides a nice upgrade path to
SQL Server if your apps grow in size.

Erik
 
John,

What will the application do? Who will be using it?

John said:
Greetings. I apologize for posting this if it is in the wrong group. The
Click to expand...
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
Click to expand...
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?
 
Tom, eventually the sales, marketing, and client services will be using it to house all (w/emphasis) data for all (emphasis again) clients within the organization. I should also mention that the almost clients info will also be here. No doubt various other info will also be stored. End reporting is also a must to the senior mgt people. Or if done right, they could get their info without waiting for qrtrly updates. There could be easily 50 people at a time using this from various parts of the country. The organization is across the country with 112 offices.
*** Joh

----- Tom Leylan wrote: ----

John

What will the application do? Who will be using it

John said:
Greetings. I apologize for posting this if it is in the wrong group. Th
Click to expand...
boss last week dropped vb.net on my desk and wants to create a web app and
corresponding desktop app. And I'm a newbie to vb.net. Have done vb6 wor
but not alot. The boss only dropped vb.net and no db to go with it. H
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.ne
Click to expand...
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 consensu
among vb.net developers? What does vb.net work best with
 
Well John.... that sounds like a SQL-Server or Oracle system to me. MSDE or
Access probably isn't going to have the horsepower.

Doesn't your organization have a database admin at the moment? You must
have systems in place, what is the company using presently?

Tom Leylan

John said:
Tom, eventually the sales, marketing, and client services will be using it
Click to expand...
to house all (w/emphasis) data for all (emphasis again) clients within the
organization. I should also mention that the almost clients info will also
be here. No doubt various other info will also be stored. End reporting is
also a must to the senior mgt people. Or if done right, they could get
their info without waiting for qrtrly updates. There could be easily 50
people at a time using this from various parts of the country. The
organization is across the country with 112 offices.
 
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.
Click to expand...

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

There can in my opinion only be one answer in your situation.

Microsoft SQL server

The documentation to connect to for that is the most clear in my opinion and
that is a very important thing in your situation now.

While if you get problems you only have to do with one supplier, also very
important in your situation now.

I think that what is the best is not so important now, more is which gives
you the quickest and with the less problems the result that is needed.

Just my thoughts.

Cor
 
Sounds like you've got a nice dilemma on your hands. If you're boss is
willing to expend for SQL Server 2000, go with that as a great beginning
approach. Oracle requires a strong knowledge of Java, and some of the other
require other specialized skills and/or don't have the ass to drive what you
need. A good book to start with is "Visual Basic .NET Complete" by Sybex.
It's not the most comprehensive book, but it covers everything from Windows
Forms to ADO.NET to ASP.NET. Another good book that has helped me get
started was "SQL Server and ADO" also by Sybex. Granted, this covers
classic ADO, but it's got great pointers on SQL server, and both books will
set you back about $40.00 combined.
Also, without a strong knowledge of database programming and interface,
it will take you a better part of a year to get things to work. There's a
definate learning curve, and some stuff. Let me make one suggestion, make
the stuff work, then worry about nifty looking stuff. I can whip out a
database and front-end program in about 2 months, working my ass off and
using VB6, but I'm pushing myself to .NEt, and having to relearn alot of
stuff, but mostof the principles are the same.

HTH
Sueffel
 
I would like to thank all of you for your expertise on this issue. It appears to be either Microsoft SQL or Oracle. After today, I think it will be Oracle. I found out today at our weekly meeting that the "boss" dropped vb.net standard 2003 on my desk and the oracle9i pack on another person's desk who was out last week. We just shook our heads and laughed. You gotta just love those corner office people that really don't have a sense of technology and the importance of it until they see how it affects below the line.

Again, thank you all for your feedback.
*** John


----- John wrote: -----

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
 
Back
Top