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

[Thomas O'H. <To...@Re...>]

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