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: 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: how to get functions from stored procedures
    ... You don't say which OLEDB provider you are using here, ... Provider for SQL Server does not), then you can just obtain unrestricted ... > procedures but i get both functions as well as stored procedures from that ...
    (microsoft.public.data.oledb)
  • 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)