Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Languages / C# / December 2005

Tip: Looking for answers? Try searching our database.

Newbie : C# and Foxpro tables or Access tables???

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
General Fear - 17 Dec 2005 03:41 GMT
Our firm does not want to spend the cash and buy SQL Server or Oracle.
So we have to make do with what we have.

Has anyone in this forum tried Access or Foxpro as a backend to C#?
What has been your result like?  

Thanking you all in advance
carion1 - 17 Dec 2005 04:48 GMT
You may want to check out MySQL or PostgreSQL.  I wouldn't use Foxpro or
Access as the back end of a multi user application.  Jet is terrible for
this.

Signature

Derek Davis
ddavis76@gmail.com

> Our firm does not want to spend the cash and buy SQL Server or Oracle.
> So we have to make do with what we have.
[quoted text clipped - 3 lines]
>
> Thanking you all in advance
SpotNet - 17 Dec 2005 12:48 GMT
Hi General Fear,

For single use applications being mainly desktop applications, Access works
quite well with C# using the OLEDB classes. If your firm has C# then it's
quite likely it has the MSDE 2000 which would be much better for limited
user server database application, using the SQL classes. You can download
this for free, if not you can buy it for $AUD 84.00, now that it's 'older'
technology but, it's still real good.

If you're using Access and there will be more than one simultaneous users,
make sure your database is well constructed and your data access layer(s)
and your business layer(s) as well. MS Access can be (sometimes) a bit
tempermental on a server with multiple simultaneous users (particularly too
many). There's been times when I've seen it work very well indeed. Generally
when the Access DB starts getting real *big* on the server side, that when
it usually decides to drop tools and go on strike.

Keep in mind that MS Access is the world's most popular ***Desktop***
database application\program. Not server side.

HTH you in some way Mr. G. Fear.

- SpotNet

: Our firm does not want to spend the cash and buy SQL Server or Oracle.
: So we have to make do with what we have.
[quoted text clipped - 3 lines]
:
: Thanking you all in advance
Cindy Winegarden - 17 Dec 2005 18:07 GMT
Hi Rich,

SQL Server 2005 Express is designed to meet needs like yours.
http://msdn.microsoft.com/vstudio/express/sql/

Signature

Cindy Winegarden  MSCD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com  www.cindywinegarden.com

> Our firm does not want to spend the cash and buy SQL Server or Oracle.
> So we have to make do with what we have.
>
> Has anyone in this forum tried Access or Foxpro as a backend to C#?
Chris R. Timmons - 17 Dec 2005 18:16 GMT
> Our firm does not want to spend the cash and buy SQL Server or
> Oracle. So we have to make do with what we have.
[quoted text clipped - 3 lines]
>
> Thanking you all in advance

You may want to consider FireBird:

 http://firebird.sourceforge.net/

It's an open source version of Borland's Interbase database server,
and comes with a .Net data provider.

Signature

Hope this helps.

Chris.
-------------
C.R. Timmons Consulting, Inc.
http://www.crtimmonsinc.com/

Jerry Walter - 17 Dec 2005 23:01 GMT
> Our firm does not want to spend the cash and buy SQL Server or Oracle.
> So we have to make do with what we have.
[quoted text clipped - 3 lines]
>
> Thanking you all in advance

I second MySQL. The latest release is starting to round out it's features
to compete with the likes of SQL Server and Oracle.

Access is NOT for a multi-user environment.

J

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.