12 Replies - 12466 Views - Last Post: 03 December 2005 - 03:51 PM Rate Topic: -----

#1 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

What SQL API works with Dev-C++?

Posted 02 December 2005 - 09:49 PM

And... if something compiles fine in Dev-C++, should it not compile (if all headers are still present) with Borland's compiler too?
Is This A Good Question/Topic? 0
  • +

Replies To: What SQL API works with Dev-C++?

#2 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: What SQL API works with Dev-C++?

Posted 02 December 2005 - 10:32 PM

<sql.h> is the usual set of libraries...but that can very...<sqltext> is another, and windows.h has SQL related functions as well.
Was This Post Helpful? 0
  • +
  • -

#3 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

Re: What SQL API works with Dev-C++?

Posted 02 December 2005 - 10:36 PM

Ok then, do I need to open the database or connect to it with a specific chunk of code? None of the tutorials I've looked at mention how to connect. They all just show manipulation of the DB.
Was This Post Helpful? 0
  • +
  • -

#4 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: What SQL API works with Dev-C++?

Posted 02 December 2005 - 10:43 PM

Depends what database you are using, and the method...are you using ODBC, or ADO?
Was This Post Helpful? 0
  • +
  • -

#5 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

Re: What SQL API works with Dev-C++?

Posted 02 December 2005 - 11:14 PM

Ok, I've figured out that ADO seems to be considered the easiest (and I'm just going to start with a basic DB, with the base function of Add, Insert, Edit and Delete.

Is

http://www.developer...o.uk/show/4033/

a decent resource to use? (I don't want to get started with bad info.)

Thanks,

Me
Was This Post Helpful? 0
  • +
  • -

#6 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 08:25 AM

That is a good enough starting resource, although it presumes you'll be using an ado import (make sure that dll is there on your system). What database software are you using?
Was This Post Helpful? 0
  • +
  • -

#7 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 10:31 AM

I'm not sure what DB program I'll be using... I'm a little confused. What is the flow between my code and the actual database?

code opens connection with db server
code performs commands
code closes db connection


I'm not sure where the db program comes into play...
Was This Post Helpful? 0
  • +
  • -

#8 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 12:53 PM

The db server is running some software...something like MySQL, SQL Server, something like that...or it will connect to an instance of a stand alone database, like Access...the connection string you use will differ based on what you are connecting to.
Was This Post Helpful? 0
  • +
  • -

#9 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 01:04 PM

So if I'm running windows 2000 server and eventually plan on using a web interface to manipulate the db, MySQL would be the way to go?

(Next question would be is MySQL free for personal use?)
Was This Post Helpful? 0
  • +
  • -

#10 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 02:24 PM

MySQL is a great choice...it is free for personal use. It is not just for web apps...you can access it with anything.
Was This Post Helpful? 0
  • +
  • -

#11 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 02:28 PM

Great, thanks for the info :). "I can see clearly now, the brain is gone..."
Was This Post Helpful? 0
  • +
  • -

#12 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,507
  • Joined: 12-July 02

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 03:22 PM

No problem, bur forgot to tell you...if you're going to use c++ and MySQL, then check this out...it's the C++ wrapper for the MySQL C API
Was This Post Helpful? 0
  • +
  • -

#13 Piperlester  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 3
  • View blog
  • Posts: 131
  • Joined: 18-October 05

Re: What SQL API works with Dev-C++?

Posted 03 December 2005 - 03:51 PM

That brings up another question... I looked into MySQL++ on my previous attempts to learn to DB... there's no flavour of MySQL++ (that I've found) that works with Dev-C++... and I've done all my programming in there recently... I don't have a problem using BCC (Borland), but for some reason I get lots of errors compiling things in BCC32, that worked fine in Dev-C++. I've made a post in C and C++ so as to keep C++ questions in the C++ forum.

Question:

This post has been edited by Piperlester: 03 December 2005 - 03:55 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1