SQL Server CE and Delphi 5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paweł Łaziński - 26 Jun 2008 07:26 GMT

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

Reply to this Message

ErikEJ - 26 Jun 2008 09:59 GMT

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

Signature

Erik Ejlskov Jensen - MCTS: Mobile App Dev

> Hello everyone,
>
[quoted text clipped - 9 lines]
> Thanks.
> Pawel

Reply to this Message

ErikEJ - 26 Jun 2008 10:00 GMT

Signature

Erik Ejlskov Jensen - MCTS: Mobile App Dev

> Hello everyone,
>
[quoted text clipped - 9 lines]
> Thanks.
> Pawel

Reply to this Message

mibainfo - 28 Jun 2008 11:08 GMT

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.lazinski@orcom.pl> napísal v správe
news:8327611E-219B-4E1A-9434-057AF5EF84CF@microsoft.com...

> Hello everyone,
>
[quoted text clipped - 9 lines]
> Thanks.
> Pawel

Reply to this Message