473,385 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Connecting to the database and executing SP in C++

Hi all

Can someone direct me on how to connect to a database Sybase/Oracle
from C++. and execute a Store Procedure.

Help will be much appreciated.

Thanks,
Nishanth

Jun 5 '06 #1
6 2055
Nishanth wrote:
Hi all

Can someone direct me on how to connect to a database Sybase/Oracle
from C++. and execute a Store Procedure.

Help will be much appreciated.

Use whatever library is supplied with the database. There should at
least be a C API.

--
Ian Collins.
Jun 5 '06 #2
Nishanth ha scritto:
Hi all

Can someone direct me on how to connect to a database Sybase/Oracle
from C++. and execute a Store Procedure.

Help will be much appreciated.

Thanks,
Nishanth

If you are working on M$ I suggest you ODBC ...
Jun 5 '06 #3

ehilah wrote:
Nishanth ha scritto:
Hi all

Can someone direct me on how to connect to a database Sybase/Oracle
from C++. and execute a Store Procedure.

Help will be much appreciated.

Thanks,
Nishanth

If you are working on M$ I suggest you ODBC ...


I have to get the job done both in Windows and solaris.. I still have
no idea how to go about the same....

Jun 5 '06 #4
Nishanth wrote:
ehilah wrote:
Nishanth ha scritto:
Hi all

Can someone direct me on how to connect to a database Sybase/Oracle
from C++. and execute a Store Procedure.

Help will be much appreciated.

Thanks,
Nishanth


If you are working on M$ I suggest you ODBC ...

I have to get the job done both in Windows and solaris.. I still have
no idea how to go about the same....

Have you looked for the libraries I suggested?

--
Ian Collins.
Jun 5 '06 #5
I checked in the solaris and the admin has not installed the same, so
am looking around the net so as to download the same.

Jun 5 '06 #6
For oracle you can use (sinze 9i I think ) Oracle Object for C++ that
are not so far from using jdbc in java. I suggest to look at oracle
documentation (otn.oracle.com) , otherwise you can use OCI directly.
Ask about the client Oracle version you will have to work with becouse
this objects are installed with client oracle and so I suggest you to
look at the documentation related to the release you work with.
I remember that for sybase there were some native libraries too but I
looked at them many years ago so I can not help you. Another solution is
using odbc for unix. In this case with the same code you can go on
sybase/oracle.
Bye
Pier Paolo
Jun 5 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: John Morgan | last post by:
I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP...
1
by: Jennifer | last post by:
I have a database on DB2 server 8.1. One of the databases in the same instance has the following problems, while the others are working ok. 1. cannot connect to the database no matter from CLP or...
12
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...
1
by: Peri | last post by:
Dear All, Can you one give me some sample code for connecting to the SQL server DB and executing a stored procedure in the SQL server using ASP.NET ? I also need to display the result set in...
29
by: Bryce K. Nielsen | last post by:
Suddenly this week, I've started getting this error message: System.Data.SqlClient.SqlConnection(GetOpenConnection)ExecuteNonQuery requires an open and available Connection. The connection's...
0
by: =?Utf-8?B?R2lkaQ==?= | last post by:
Hi, I've my win32 application which connecting to my sql database. till now i used MSDE as my database and now i want to upgrade to sql express 2005. after the upgrade i tried to connect to the...
1
by: ishwarjoshi | last post by:
I am in the process of upgrading an old Access ADP/SQL 2000 App to Access 2007 ADP/SQL 2005. There are a lot of buttons in the Access form which are calling Access Macros, the Macros call...
8
by: Ananthu | last post by:
Hi I have done all the codings part for connecting mysql with java in eclipse environment. Coding Part: import java.sql.Connection; import java.sql.DriverManager; public class...
1
by: ypytt | last post by:
Hi all, I'm developing a Windows application in C# using Visual Studio 2005. The application should be able to read data from a MySql database. I've developed applications that read data from a...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.