SQL Server CE and Delphi 5

[Paweł Łaziński]

Hello everyone,

I'm searching to answer for the question: is exists some posibilities to
connect sql server 2005 compact edition from Delphi 5, by using a ado
connection (ole db) ?
At this moment, one what I done, is only message: "Unknown error".
My connection string looking like that:
"Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data
Source=d:\\mydatabase.sdf;Persist Security Info=False".
If You are solve this problem or have some sugestions, please write.

Thanks.
Pawel

[ErikEJ]

I have made some sample VBA code that you might be able to use:
http://forums.microsoft.com/msdn/showpost.aspx?postid=3146645&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1

http://erikej.blogspot.com/2008/04/import-sql-compact-data-to-excel.html

--
Erik Ejlskov Jensen - MCTS: Mobile App Dev

[ErikEJ]

I have made some sample VBA code that you might be able to use:
http://forums.microsoft.com/msdn/showpost.aspx?postid=3146645&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1

http://erikej.blogspot.com/2008/04/import-sql-compact-data-to-excel.html

--
Erik Ejlskov Jensen - MCTS: Mobile App Dev

[mibainfo]

For Delphi 7.0:

//-----
...
uses
.. , ADODB_TLB, ssce35_tlb;
...
const
c_SSCE35 = 'Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=%s;Persist
Security Info=False';
var
s:String;
connSDF : _Connection;
begin
connSDF := CoConnection.Create;
s:= Format(c_SSCE, [sFileName] );
connSDF.Open( s, '', '', Integer (adConnectUnspecified ) );
...
end;
//-----

Miro

"Paweł Łaziński" <p.laz...@orcom.pl> napísal v správe
news:8327611E-219B-4E1A...@microsoft.com...