Re: Components - SQL Server Compact Edition?

Thx Vassiliev V. V.,


However, I do not have an OLDEB provider listed. I know the end result
should be something like:
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=myPath\myData.sdf;

The only OLEDB provider I have for SQL Server is:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=AdventureWorks2000;Data Source=OIC01

I have reinstalled "SQLServerCE31-EN.msi" but still cannot see a provider.

This is why I thought going the component route might be easier...
Any ideas would be appreciated.
Thx again,
Kim.

"Vassiliev V. V." <support@xxxxxxxxxxxxxxx> wrote in message
news:46ef92dd$1@xxxxxxxxxxxxxxxxxxxxxxxxx
You can use ADO components, or any components that work with OLEDB or
ODBC.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Kim Bracknell" <kbracknell@xxxxxxxxxxxxx> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ
ñëåäóþùåå: news:46ef9115@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi there,
Apart from SDAC (Corelab), are there any other components that can be
used to connect to SQL Server 2005 Compact Edition?
Thx,
Kim.





.

Relevant Pages

  • RE: Problems with ACE OLEDB provider
    ... Excel sheets created as linked servers from SQL Server via the ACE ... OLEDB provider version 12 fail on table updates. ... I have this worksheet defined as a linked server in SQL Server via this ...
    (microsoft.public.excel.programming)
  • Re: Adding a data source to a project
    ... the list of OleDB provider in the Ado Select/Change Connection wizard ... @="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows ...
    (microsoft.public.sqlserver.ce)
  • Fix for not listed Sql CE OleDB provider
    ... the list of OleDB provider in the Ado Select/Change Connection wizard ... @="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows ...
    (microsoft.public.sqlserver.ce)
  • Re: Components - SQL Server Compact Edition?
    ... I do not have an OLDEB provider listed. ... The only OLEDB provider I have for SQL Server is: ... This is why I thought going the component route might be easier... ...
    (borland.public.delphi.database.ado)
  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)