Member Avatar for anitha av

hello...i am doing a project on connecting c language with sql. but i am unable to write the program in c language by using the sql code for connectivity. plz advise me as how to learn to write the c program using sql.

  • 5 Contributors
  • 7 Replies
  • 124 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by sai subhashini
Member Avatar for rubberman

What SQL library are you trying to use? Is it an implementation of the ODBC API's, or something specific for a particular database. For example, MySQL has its own library for C and C++ connectivity (my current project uses their C++ library). Oracle has similar. They both have ODBC and JDBC libraries (JDBC == Java DataBase Connectivity, ODBC Open DataBase Connectivity) as well. ODBC is generally a C library, and JDBC is a Java library (.jar files).

Member Avatar for Ancient Dragon

Here is an odbc tutorial. BTW what compiler and operating system are you using?

Edited by Ancient Dragon
Member Avatar for velayutham e

Thanks for your replies..I am trying to connect it with c library.I am using windows 7 operating system & i wish to compile my program in c. The main idea behind my project to bring the student's log book in c language by connecting it with the sql database.
For this, i don't know how to write the program in c language for connectiing it with sql.
plz guide me with some proper & clear tutorials for writing that program. If possible, plz guide me with example programs.

thanks.

Member Avatar for Ancient Dragon

Unfortunately there are not a whole lot of tutorials in C language. The link I posted is probably one of the most comprehensive -- take a few days to study it well. Have you tried to google for "odbc c tutorials"? It's somewhat complicated stuff so you won't find anything short and simple. Requires a bit of studying and some practice. There are some c++ class wrappers, but if you are stuck with C language then they won't be of any use to you.

Edited by Ancient Dragon
Member Avatar for Ancient Dragon

That's a bad link -- I get "File not found" error. Maybe the link it to a site which I don't have permissions to read. MySQL is a specific kind of SQL server so the contents of that pdf may or may not apply to other SQL server programs. If it teaches standard ODBC then you should be ok with it.

Here are some more MySQL-specific tutorials you might be interested in.

Edited by Ancient Dragon
Member Avatar for sai subhashini

Thanks a lot sir. I got cleared of my doubts...thank u.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.