OLEDB / ODBC connection

[Gian Paolo Clarici]

It is possible to use the OLEDB or ODBC tecnology to connect a database
different from SQL Server?
I need to connect to Sybase Adaptive Server Enterprise.

I'm using VS2005, .Net CF2sp1.

thanks for any suggestion.
JPC

--

 

[Ilya Tumanov [MS]]

No, ODBC is not supported on CE at all and there's no OLEDB ADO.Net provider
for NETCF.

Besides, it probably won't do you any good as I doubt there's OLEDB driver
for "Sybase Adaptive Server Enterprise" which is designed for CE.



Usual way to solve this is to go through Web Service as proxy.


--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

 

[Rüdiger Kardel]

alternative to a webservice:

Sybase provides a .NET data provider for it's SQL Anywhere Studio.
You can define the tables from the "Enterprise Server" within SQL Anywhere
as proxy tables. The devices can access the tables "quasi directly" thru the
SQL Anywhere server.

Ruediger