Wrox Programmer Forums
|
VB.NET 2002/2003 Basics For coders who are new to Visual Basic, working in .NET versions 2002 or 2003 (1.0 and 1.1).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET 2002/2003 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 19th, 2007, 06:17 PM
Authorized User
 
Join Date: Dec 2006
Posts: 43
Thanks: 4
Thanked 0 Times in 0 Posts
Send a message via MSN to Yasho
Default client server programming

is it possible to develop a client Server environment program using oledb connection to an acess databse
If yes can some one give me some pointers.
Yasho

yvk
__________________
yvk
 
Old June 19th, 2007, 10:16 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Along the lines of using access for a client-server program? I'd recommend against it. Save access based applications for programs that will be desktop only. Anything client-server should use a "real" data system like mySql, MSSQL Server or Oracle. If you are concerned with obtaining systems that require licensing, there are some free options: Microsoft SQL Server (2000) Desktop Edition (MSDE); SQL Server 2005 Express (fully functional RDBMS but missing enterprise level features).

What kind of client server app are planning to build?

-Peter
 
Old June 20th, 2007, 05:33 PM
Authorized User
 
Join Date: Dec 2006
Posts: 43
Thanks: 4
Thanked 0 Times in 0 Posts
Send a message via MSN to Yasho
Default

I* am planning to build a point of sale program with a full inventory, Sales and Sales tax reports capacity. Initially it will not have accounting capabilities but later i would like to include it.


yvk
 
Old June 20th, 2007, 05:42 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

well.. you better use Peter suggestion and try with a more robust database... SQL server 2005 is a good choice...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old June 20th, 2007, 06:30 PM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

POS systems, how fun! ><

In any case, SQL Server 2005 Express should work out nicely for you but there are a few limitations to it:
-It can not utilize more then 1GB of RAM
-It can not utilize multiple CPU's
-The Database size can not exceed 4GB
-No Built in Mgmt tools (Though you can download Express Manager for free which gives you Query Analyzer and such)
-No analysis or reporting tools. (DTS)

The POS side of things should have no problem with the above limitations, however, the financial data may be a problem since (in the states any way) you are required to keep 7 years worth of financials on file in the event that you would be audited. 7 Years worth of data is a lot of information so you need to take that 4GB size limitation into account. (Of course you could back up the .mdf file to DVD at the end of the year, trucate the data tables and start the new year fresh)

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
 
Old June 20th, 2007, 09:16 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

just to add.. if you use access aren't you limited to 1 GB??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========
 
Old June 20th, 2007, 09:29 PM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

I believe Access had/has a limit of 2GB but it has been my experience that access starts getting flakey when your database starts getting above 500MB.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========





Similar Threads
Thread Thread Starter Forum Replies Last Post
device DLL programming in client side programming hendyhanusin ASP.NET 1.0 and 1.1 Professional 2 February 19th, 2009 12:01 PM
connecting client to client (Socket programming) maricar C# 0 September 25th, 2008 04:34 AM
device DLL programming in client side programming hendyhanusin ASP.NET 1.0 and 1.1 Basics 0 March 21st, 2007 08:05 AM
device DLL programming in client side programming hendyhanusin ASP.NET 2.0 Professional 1 March 21st, 2007 08:04 AM
DDE Client Programming Examples GeekyGreek VB How-To 0 July 20th, 2006 09:50 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.