I want to use RDA to pull tables from SQL Server into PDA, wenn i call the
pull method then the following errors are reported:
------------- ------------- -------------
Error retrieved from ISSCERDA->get_ErrorRecords
-------------
Description:'The OLEDB provider for SQL Server CE cannot be initialized.[,,,,,]'

Number: 80040154
NATIVE_ERROR: 29004
SOURCE: 'Microsoft SQL Server 2000 Windows CE Edition'
P0: 0
P1: 0
P2: 0
P3: ''
P4: ''
P5: ''
------------- ------------- -------------
Error reported on http://SERVER/.../sscerepl.log file
-------------
2003/03/04 08:48:50 Hr=00000000 Count of active RSCBs = 0
2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 RDA processing
entered 0
2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 RDA responding
0
2003/03/04 08:48:50 Thread=124 RSCB=4 Command=PULL Hr=00000000 C:\Arquivos
de programas\Microsoft SQL Server CE 2.0\Server\A27CF500-39D5-11C1-8000-DD2306CBB08F
0
2003/03/04 08:48:50 Thread=124 RSCB=4 Command=SCHK Hr=80040154 SyncCheck
responding 0
2003/03/04 08:48:50 Thread=124 RSCB=4 Command=SCHK Hr=00000000 Removing this
RSCB 0
------------- ------------- -------------
The source
-------------
ISSCERDA* ERDA;
WCHAR wszConnectString[512]; // Persists the RDAConnectionString
WCHAR wszLocalTable[255]; // Persists the RDALocalTable
WCHAR wszErrorTable[255]; // Persists the RDAErrorTable
WCHAR wszQuery[1024]; // Persists the RDAQuery
HRESULT hr = CoCreateInstance(CLSID_RemoteDataAccess, NULL, CLSCTX_INPROC_SERVER,
IID_ISSCERDA, (LPVOID *)&CERDA);
hr = CERDA->put_InternetURL(L"http://SERVER/virtual path/sscesa20.dll");

hr = CERDA->put_InternetLogin(L"name1");
hr = CERDA->put_InternetPassword(L"pwd1");
hr = CERDA->put_LocalConnectionString(L"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
Source=\\rep.sdf");
wcscpy(wszConnectString, L"Provider=sqloledb;Initial Catalog=myDB;Data Source=SERVER;UID=name2;password=pwd2");

wcscpy(wszErrorTable, L"ErrorTable");
wcscpy(wszQuery, L"Select id,name,description from remoteTable");
wcscpy(wszLocalTable, L"localTable"); //this table is not yet present
hr = CERDA->Pull(
wszLocalTable,
wszQuery,
wszConnectString,
TRACKINGOFF,
wszErrorTable
);
if(FAILED(hr)) ShowErrors( CERDA );
CERDA->Release();
------------- ------------- -------------
Enviroment:
-------------
- PocketPC2002
- ActiveSynch 3.6
- eVC++
- SQL Server 2000, SP3
- Microsoft SQL Server CE 2.0
- Basic authentication on IIS
- the user name2 is only present on SQLServer and with permition for the
specified Database (public,db_owner).
thanks in advance
junges