How do you Access MS Access from C?

Answer 1

The following example creates an OracleConnection and sets some of its properties in the connection string. * ** Syntax based on .NET Framework version 1.1 ** #using #using #using using namespace System; using namespace System::Data; using namespace System::Data::OracleClient; __gc class COracleConnection

{ public:

void CreateOracleConnection( )

{ String* myConnString Oracle8i;Integrated Security new OracleConnection( myConnString ); myConnection->Open( ); MessageBox::Show( String::Format( S"ServerVersion: {0}\nDataSource:{1}", myConnection->ServerVersion, myConnection->DataSource ) ); myConnection->Close(); } }; // This is the entry point for this application #ifdef _UNICODE int wmain( void ) #else int main( void ) #endif { COracleConnection *pCOracleConnection = new COracleConnection(); pCOracleConnection->CreateOracleConnection( ); return 0; } You will use Oracle's API. Its called OCI for Oracle Call Interface -- use Google for details about its usage. You can also use OTL, which is the Oracle Template Library. Its much easier to use than OCI. Additionally, you can use embedded sql and precompile this code into pure C using the Oracle Pro*C/C++ precompiler. Sample code exists in ORACLE_HOME/precomp/demo/proc and ORACLE_HOME/rdbms/demo. As Oracle is the largest database company in the world with the largest market share of enterprise s/w, you can bet there is code all over the internet to do what you want to do. Check the forums at otn.oracle.com, google (or other search engine), or asktom.oracle.com. Answer You can also use library such as OCILIB (wraper for OCI) and Libsqlora. The other solution is use UnixODBC for unix programming environtment. Visit www.alldatabaseprogramming.blogspot.com or www.gtkinaction.blogspot.com for further information.

Answer 2

The C and C++ languages do not have standard libraries to manage databases, you need to use the libraries provided by the compiler, or database vendors or

any 3rd party libraries to connect and manage databases.

You can find libraries and examples of connecting to MySQL, Oracle and Sybase databases from here:

http://prokutfaq.byethost15.com/HowToConnectDatabase

Answer 3

The easiest way to access an Access database from C++ is to use ODBC. An access database can easily be setup as an ODBC data source. The "Connection Strings" website provides you with many alternatives and 'connection string' syntax to complete this, too. Try; http://www.connectionstrings.com/

Answer 4

You do not access MS Access from C you do it from windows by using MS Access api calls.

MS Access does not run on a computer running Linux, QNX or DOS etc. but they can all be programmed in C

Answer 5

U need to find the DRIVER for C language that will connect to Oracle or Access Database and then access that driver through C program.