• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Accessing Sybase ASA using OLE DB from C++

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
kevinbenedict
Asked:
kevinbenedict
1 Solution
 
kevinbenedictAuthor Commented:
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
 
mahesh1402Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now