Using SQL with C++

[magezi]

How can I use C++ to make use of my SQL to manipulate databases ?

Also Is it possible to access Database objects eg Tables designed in MS-Access(97/2000)and manipulate data therein? if so how.

Thanx alot cllegues. Nkabirwa Sowed Magezi
nkabirwa@yahoo.com

A Ugandan Developer for

(1) School Management Information System(SMIS) - Foxpro 2.6 ; Ms-Acess 97

(2)Debt onitoring System(DMS) - Ms-Acess 97

(3) The Loans Recovery System(LS) - Ms- Access 97

(4) The Dry Cleaners System(DS) - Ms- Access 97

 

[dds82]

If you know ADO and are using Visual C++, you can use the #import directive to import the ADO DLL into your project, like this:

#import "c:\windows\system\msado15.dll" no_namespace rename("EOF","EndOfFile&quot

Now you can use ADO connection, command, and recordset objects. Read the MSDN documentation for details about the objects.

 

[areza123]

Hi there,
to connect to databases from C++,u need a set of libraries that support an API for this.The most popular are SPM Roguewave libraries.These are a database independent set of libraries that provide connectivity to any database.(It supports for sure Sybase && Oracle)