How to connect to Oracle, DB2, MYSQL, ODBC through C++and Oracle ODBC and DB2 CLIE Library
How to connect to Oracle, DB2, MYSQL, ODBC through C++and Oracle ODBC and DB2 CLIE Library
There is a really good open source C++ libary to do this through ODBC. It is easy to set up and showcase. I demo this briefly on it.
Get more details and links at:
http://quantlabs.net/blog/2011/12/you...
Download source code example here: http://quantlabs.net/blog/2012/11/you...
Closed Caption:
they all its a Brian here from
clubs dotnet I just want to give you a
brief are rundown
as I'm getting deeper and getting
reacquainted with C plus plus
are I found it quite surprisingly
difficult to connect to Siegel Server
MySQL a remote database
are in c plus plus arm
I'm trying to keep everything as
portable as possible arm
as well as that's why I'm using MySQL
more if I decide if I want to move into
a Linex arm my school's perfect for that
it's free
blah blah blah blah but arm this this
library about to show you foresee plus
plus enables you to connect to Oracle
uses an ODBC connector or db2 as well as
MySQL
arms let me give you a rundown how it
kinda works
I assume that you are kinda lawyer will
c plus plus
and some the underpinnings as you can
tell I am a user of Windows
I by the one thing you do need to
understand is
within c plus plus it would use an ODBC
to connect arm two-tier to
databases and that's done by creating
put/call TSN's or datasource names when
those
in this case your best bet is to run a
little program called ODBC
8032 that will bring up a little program
your ODBC datasource a administrator
MySQL enables you to use their driver
others ODBC 3.51 dry which went download
from MySQL dot com
on and then connect to it are
and then you do that through your source
code once you connect through
this library you can download I
and it's free its found on SourceForge
I'm currently using the current version
OT of four arm let me show you
in Examples source code example follow
it comes with
arm that and
I you know you do need to connect to
your
to your database through that the SNR
showed you
that's done through here with the
connection string and
enables you to connect to the database
remotely and then you can do your
standard
SQL queries to and select
updates in this example it does create
the
database and a table for you and it does
do an insert as well on that table 6
quick to insure on on showing how all
this library works
and enabling you to connect to your
remote
job database and again with ODBC you can
probably go through single serve you
choose to use this library
I'm still looking for something for
Microsoft to show me how to
nicely in easily connect the sequel
server through
visual c plus plus is doesn't seem to
exist at this point also help ya for now
Video Length: 03:01
Uploaded By: Bryan Downing
Published: 12/5/2011
View Count: 19,366
Related Software Products
MySQL-to-Oracle
Published By:
Intelligent Converters
Description:
MySQL-to-Oracle is a program to migrate MySQL database to Oracle server. All MySQL data types and attributes are supported. The program has easy-to-use wizard style interface and supports command line parameters. License Information Single-User License allows clients to install the software product on exactly one (1) computer system. Client can store a backup copy of the software but cannot use two copies of the software at any one time. Single-User License does NOT allow to make use of the ...
Oracle-to-MySQL
Published By:
Intelligent Converters
Description:
Oracle-to-MySQL is a program to move Oracle databases to MySQL server. Depending on your privileges on the target MySQL server you can export Oracle data into new database or overwrite the contents of an existing MySQL database. All Oracle data types and attributes are supported. The program works with all versions of Unix and Windows MySQL servers. License Information Single-User License allows clients to install the software product on exactly one (1) computer system. Client can store a ...