Re: [Dev-C++] accessing mdb/mssql with dev-cpp

[Per W. <pw...@ia...>]

I think you have missed something fundamental here.

What you call DB tools seems to be the administrative tools used to create
databases and tables, optimize queries, set up privileges etc.

That is a completely separate issue from retrieving and using the data.

You normally don't manage a database using ODBC. The ODBC interface isn't
even complete enough to retrieve all meta information about tables,
queries, views etc. You use it to insert/update/delete/query data. While
ODBC might not be the hottest item in the world, it is one of severeal
methods of accessing SQL databases.

Note that when accessing the database, there is no requirement to access
individual tables. You might just as well use ODBC to access pre-designed
views in the database.

Your mail can almost be read as if it is the DB admins that are on call
24/7 that retrieves the data and returns it to the applications. Now that
doesn't seem like a very fast interface ;)

/Per W

On Tue, 29 Aug 2006, Thomas O'Hare wrote:

> I have some data handling experience.
>
> My experience says ODBC is out as it is really slow, and depending on
> the tools used, can be quite expensive.
>
> I have taken the opposite approach and use higher level tools that can
> do data better then trying by yourself.  I am using Dev-C++ to do the
> dirty work and pass the results of my functions to these higher level
> languages that can process data tables much better then I ever could in
> my own C programs.
>
> IOW, let DB tools do DB work, let low level tools do low level work.
> Just make the 2 communicate well with each other via your own interface.
>
> There are many technologies that are better then ODBC.  And beware of
> Access.  MS flat out stipulates it was never intended as a "true"
> multi-user database but rather as a simple data store for simple operations.
>
> Remember, if you get into real data handling you have to look at record
> or table locks, keeping data integrity, maybe working with DB triggers,
> relational tables, SQL standards, indexes and a whole host of other issues.
>
> There is a reason people use specific database tools for specific
> purposes.  It can depend on how heavy of a load it can take on a high
> end web server, or how secure the data must be maintained.
>
> I just wanted to throw this into the mix to make sure some people better
> understand true database concepts as opposed to simple data stores.
> Remember, the high end DB admins get paid very well and are on call 24/7
> -- and that is all they do, manage DB's.
>
> Thanks,
> ~ Thomas O'Hare ~
> President, RedTile, Inc. - DBA: RedTile Software
> Web, Wireless, Network, Database & Systems Software
> +1.407.295.9148 ; +49.8651.717950 ; http://www.RedTile.Com/
> Operations Manager; Virtual FoxPro User Group
> To...@VF... ; http://www.VFUG.Org/
>
>
> rodolfo d'Ettorre wrote:
> > Hi,
> >
> > I have not tried it yet, but WxWidget includes a ODBC library which may
> > allow you to work with both MSSQL and MSAccess.
> >
> > Good Luck
> >
> > Rodolfo d'Ettorre
> >
> >
> >
> >
> >> From: Andrea <ab...@li...>
> >> To: dev...@li...
> >> Subject: [Dev-C++] accessing mdb/mssql with dev-cpp
> >> Date: Sun, 27 Aug 2006 15:48:03 +0200
> >>
> >>
> >> Hi everybody,
> >> I need to access some tables from (a mess of) .mdb
> >> files (and later I'll be required to access data in a
> >> MSSQL server). Please don't tell me I can use
> >> SQLite or MySQL for I did as long as I could (BTW the
> >> program I built using devcpp/sqlite worked about 10
> >> times faster than the one developed by another guy
> >> with vb; but dumping results to a text file which took
> >> less than a minute to be imported by a DTS is now
> >> considered unacceptable).
> >> I googled around but I found nothing usable about it.
> >> Can anyone address me to tutorials/articles (better
> >> if with some sample code) covering the topic?
> >>
> >> Thanks a lot
> >>
> >> Andrea
> >>
> >>
> >>
> >>
> >> -------------------------------------------------------------------------
> >> Using Tomcat but need to do more? Need to support web services, security?
> >> Get stuff done quickly with pre-integrated technology to make your job
> >> easier
> >> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> >> _______________________________________________
> >> Dev-cpp-users mailing list
> >> Dev...@li...
> >> TO UNSUBSCRIBE: http://www23.brinkster.com/noicys/devcpp/ub.htm
> >> https://lists.sourceforge.net/lists/listinfo/dev-cpp-users
> >
> >
> >
> > -------------------------------------------------------------------------
> > Using Tomcat but need to do more? Need to support web services, security?
> > Get stuff done quickly with pre-integrated technology to make your job easier
> > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> > _______________________________________________
> > Dev-cpp-users mailing list
> > Dev...@li...
> > TO UNSUBSCRIBE: http://www23.brinkster.com/noicys/devcpp/ub.htm
> > https://lists.sourceforge.net/lists/listinfo/dev-cpp-users
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Dev-cpp-users mailing list
> Dev...@li...
> TO UNSUBSCRIBE: http://www23.brinkster.com/noicys/devcpp/ub.htm
> https://lists.sourceforge.net/lists/listinfo/dev-cpp-users
>