Solved

Accessing Sybase ASA using OLE DB from C++

Posted on 2006-06-22
5
213 Views
Last Modified: 2013-11-20
I need to write some code to access an ASA database using plain OLE DB.  It needs to be the same code that will work both in Windows CE and Windows XP.  Are there any good samples out there?  Thanks.

Timothy Dean
0
Comment
Question by:kevinbenedict
5 Comments
 

Author Comment

by:kevinbenedict
ID: 16964593
This should be similar to accessing SQL Server CE using OLE DB, so if no ASA sample is available, a SQL Server CE sample might also be useful.  Thanks.

Timothy Dean
0
 
LVL 22

Accepted Solution

by:
mahesh1402 earned 500 total points
ID: 16967366
You may use following connection string to connect to a Sybase DB using OLE DB. Hopefully, this will give you a start.

strConnection.Format("Provider=Sybase.ASEOLEDBProvider;Persist Security Info=True;Data Source=%s", m_acServer);    // Connection string ...
m_pConn->Open ((_bstr_t)strConnection, m_bstrLogin, m_bstrPass, adConnectUnspecified);    //Open the connection

>>so if no ASA sample is available, a SQL Server CE sample might also be useful

http://www.codeproject.com/ce/mysqlce.asp <==

-MAHESH
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
cat dog challenge 18 124
bobThere java chalenge 45 91
Fibonacci challenge 11 110
x-bar in Google Sheets 2 26
This is to be the first in a series of articles demonstrating the development of a complete windows based application using the MFC classes.  I’ll try to keep each article focused on one (or a couple) of the tasks that one may meet.   Introductio…
Introduction: Finishing the grid – keyboard support for arrow keys to manoeuvre, entering the numbers.  The PreTranslateMessage function is to be used to intercept and respond to keyboard events. Continuing from the fourth article about sudoku. …
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now