Re: Adding a data source to a project

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Chuck,

With the registry settings below ( based on the reg changes the beta
versions did make) you can make the OleDB provider for SqlServer 2005 CE in
the list of OleDB provider in the Ado Select/Change Connection wizard
dialog.
Use it on your own risk!!

Erik


Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}]
@="Microsoft.SQLSERVER.MOBILE.OLEDB.3.0"
"OLEDB_SERVICES"=dword:fffffffe

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\ExtendedErrors]
@="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows
Error Lookup"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\ExtendedErrors\{D9007E8B-A33A-4429-B0FC-7FC211DB8110}]
@="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for
WindowsError Lookup"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\InprocServer32]
@="C:\\Program Files\\Microsoft SQL Server Compact
Edition\\v3.1\\sqlceoledb30.dll"
"ThreadingModel"="Both"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\OLE DB
Provider]
@="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\ProgID]
@="Microsoft.SQLSERVER.MOBILE.OLEDB.3.0"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\VersionIndependentProgID]
@="Microsoft.SQLSERVER.MOBILE.OLEDB"



"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> schreef in bericht
news:%23NE52T5THHA.3948@xxxxxxxxxxxxxxxxxxxxxxx
From my vb project I clicked on the following menu selections

Data>Add new Data source>Select Database>New Connection

I am now looking at the "Choose data Source" screen

in the Data source list box I have no "Sql server Compact edition" option

I am missing something but I have no clue what!!!!



.

Relevant Pages

  • Re: Adding a data source to a project
    ... I reinstalled the SQL Server 2005 Mobile. ... The provider is installed with the installer, but just does not show up in ... Is this the only way to get the provider for SqlServer 2005 CE installed?? ... @="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows ...
    (microsoft.public.sqlserver.ce)
  • 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
    ... Is this the only way to get the provider for SqlServer 2005 CE installed?? ... With the registry settings below (based on the reg changes the beta ... @="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows ...
    (microsoft.public.sqlserver.ce)
  • Re: Adding a data source to a project
    ... The provider is installed with the installer, but just does not show up in ... Is this the only way to get the provider for SqlServer 2005 CE installed?? ... @="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows ...
    (microsoft.public.sqlserver.ce)
  • Re: Components - SQL Server Compact Edition?
    ... Thx Vassiliev V. V., ... I do not have an OLDEB provider listed. ... The only OLEDB provider I have for SQL Server is: ...
    (borland.public.delphi.database.ado)