Solved

Accessing Sybase ASA using OLE DB from C++

Posted on 2006-06-22
5
199 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction: Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers).  Error trapping with try..catch to help the code run even if something goes wrong. Continuing from the seve…
If you use Adobe Reader X it is possible you can't open OLE PDF documents in the standard. The reason is the 'save box mode' in adobe reader X. Many people think the protected Mode of adobe reader x is only to stop the write access. But this fe…
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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

757 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

19 Experts available now in Live!

Get 1:1 Help Now