SQL Server CE and Delphi 5   

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

date: Thu, 26 Jun 2008 08:26:58 +0200   author:   Pawe³ £aziñski

RE: SQL Server CE and Delphi 5   

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


"Paweł Łaziński" wrote:

> 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 
>

date: Thu, 26 Jun 2008 01:59:00 -0700   author:   ErikEJ

RE: SQL Server CE and Delphi 5   

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


"Paweł Łaziński" wrote:

> 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 
>

date: Thu, 26 Jun 2008 02:00:01 -0700   author:   ErikEJ

Re: SQL Server CE and Delphi 5   

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

date: Sat, 28 Jun 2008 12:08:25 +0200   author:   mibainfo