How to access SQL DB in C++?

Question

I am looking for a free cross-platform (Windows, Linux) C++ library for an access to an MS SQL server DB.

For example, I want to convert the following C# flow to unmanaged C or C++ (from here) :

static void Main()
{
    string connectionString = 
       ConsoleApplication746.Properties.Settings.Default.ConnectionString;
    using (SqlConnection con = new SqlConnection(connectionString))
    {
        con.Open();
        using (SqlCommand command = 
           new SqlCommand("SELECT TOP 2 * FROM Dogs1", con))
        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                 Console.WriteLine("{0} {1} {2}", reader.GetInt32(0),
                    reader.GetString(1), reader.GetString(2));
            }
        }
    }
}

Isn't SQLite an implementation of a DB, and not a library to access an existing DB? — Igor
– Igor, Commented Mar 29, 2011 at 15:46
@Igor Oks: you are creating confusion here because you don't tell us which SQL db you are talking of. Microsoft SQL Server, Oracle, Sybase, IBM DB2, ... ??? Or are you looking for a generic library for different DB vendors? — Doc Brown
– Doc Brown, Commented Mar 29, 2011 at 16:05
Why do some people think MS has invented the word "sql server"? — Doc Brown
– Doc Brown, Commented Mar 30, 2011 at 11:26
@Doc Brown: Yes, really. SQL Server®. microsoft.com/About/Legal/EN/US/IntellectualProperty/Trademarks/… — Ben
– Ben, Commented Apr 14, 2011 at 15:14

kbjorklu · Accepted Answer · 2011-03-30 12:17:20Z

4

Try DTL or SOCI.

Edit: or OTL.

answered Mar 30, 2011 at 12:17

kbjorklu

1,3988 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Doc Brown · Accepted Answer · 2011-03-30 11:21:05Z

Accessing MS SQL server from windows should not be a problem in general. For accessing it from Linux, this web page may help you to find a way

http://www.sommarskog.se/mssqlperl/unix.html

Finding a solution that works on both Windows and Linux is a task that may not be solved easily, depends on the exact requirements and your current architecture. For example, when you just need C++ program calling a Perl script which does the DB work for you, this path may provide you with a free cross-platform solution. Perl is free and cross-platform, and the DBI modules too.

On the other hand, when your cross-platform C++ program uses a cross-platform framework like Qt, and you need a direct connection in your C++ program to the SQL server, ODBC may be the best option:

http://doc.qt.nokia.com/4.7/sql-driver.html

Unfortunately, according to the information behind my first link, there are no free ODBC drivers for Linux, so you might bite the bullet and buy one.

Ben · Accepted Answer · 2011-04-02 12:45:05Z

1

There is no reason to rewrite perfectly good, tested, working code.

Don't do it. Use Mono to run your existing code on Unix/Linux instead.

answered Apr 2, 2011 at 12:45

Ben

35.9k6 gold badges81 silver badges117 bronze badges

Comments

MonsieurPiwi · Accepted Answer · 2011-03-29 16:01:42Z

0

Indeed, SQLite is an implementation of a DB where data is stored in a flat file.

I think ODBC might be the technology you're looking for.

answered Mar 29, 2011 at 16:01

MonsieurPiwi

1

Comments

Marius Bancila · Accepted Answer · 2011-03-29 16:03:25Z

0

What about SQLAPI++? Works both on Windows and Linux/Unix. http://www.sqlapi.com/.

answered Mar 29, 2011 at 16:03

Marius Bancila

16.4k9 gold badges53 silver badges97 bronze badges

1 Comment

Igor Over a year ago

It is not free, as far as I know

Collectives™ on Stack Overflow

How to access SQL DB in C++?

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related