Re: SQL Server Compact 3.5

Hi,

i have changed my registry so now i can try to make an adoconnection.

However i'm getting a error on opening the connection : 'Provider could not set DATASOURCE, USERID, or PASSWORD'

My source code is very simple :

ADOConnection1.Close;
ADOConnection1.ConnectionString:='Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=c:\data\MyDatabase#1.sdf';
ADOConnection1.Open('','fvg&51351');

Anyone a idea ?

Filip


"Filip Vercruysse" <pingwin@xxxxxxxxxxxxx> schreef in bericht news:4847ce84$1@xxxxxxxxxxxxxxxxxxxxxxxxx
hi,

i need to create a Application on Windows Mobile running SQL Server Compact Edition.
Iis there a way (driver) to connect from a Delphi application to SQL Server Compact 3.5 Edition ?

Br,

Filip



.

Relevant Pages

  • Re: Installing sqlce30.wce5.armv4i.CAB with a program
    ... To privately install the SQL Server Compact Edition with your application, ... application and copy the DLL files to the application directory. ... where the SQL Server Compact Edition DLL files are installed which by ...
    (microsoft.public.dotnet.framework.compactframework)
  • RE: SSIS and SQL CE
    ... finally I found out why my post was ignored even I have valid MSDN ... After renewal of MSDN Subscription it is required to create new ... there is error in provider - instead of properties there is only ... Provider for Microsoft SQL Server Compact" ...
    (microsoft.public.sqlserver.dts)
  • Re: Compcat edtion RC1
    ... Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop as well as on mobile devices. ...
    (microsoft.public.sqlserver.ce)
  • Re: A Sql Compact problem
    ... I'm very pleased with Sql Server Compact Edition, ... database has an SupplierArticles table. ... SupplierArticleNo search it sometimes seems like the application is hanging. ...
    (microsoft.public.sqlserver.ce)
  • A Sql Compact problem
    ... I have written a quite big retail application for Windows Mobile. ... I'm very pleased with Sql Server Compact Edition, ... SupplierArticleNo search it sometimes seems like the application is hanging. ...
    (microsoft.public.sqlserver.ce)