Re: !!

I installed sql 2005 compact Edition. There are no other servers installed.

Everytime I try to connect, iot asks me for provider, a server and a database.

I use SQL Server Provider - there is no oledb provider for the compact
edition (unless I need extra files). So, I don't see any servers.

I'm using the latest files for:

ADO (2.8)
SQL Server 2005 Compact Edition (spanish version).
..NET Framework 2.0

The system is a genuine Microsoft Windows XP.

What else do I need?




"Ralph" wrote:


"newbie in hell" <newbieinhell@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39A84947-CFC2-4752-9ECB-004B23D6E7F0@xxxxxxxxxxxxxxxx
Hi, all:

Microsoft SQL Server 2005 Compact Edition is supposed to be much liter and
faster than Microsoft SQ Server Express Edition(or MSDE) - but all the
reading I've seen, including SQLBOL for CE, is about Visual Basic.NET(or
C#).
It looks like we are finally dead(¿?)

I know you can connect to SQL Express Edition through ADO with VB6, in the
same way you do for MySQL (by the way there is a new ADO-like connector
for
MySQL), but - now that I'm in hell accoding to Microsoft Standards
(because
it's hell, you know), How can I connect to this fabulous Ms SQL 2005
Compact
Edition which you can ship with your applications usin VB6!!!

I wonder if it's any faster that MS Access!!!

I installed MS SQL CE on my machine, with a sample database. I don't see
any
server and I suppose I use OLE DB fopr SQL Server. And next? (no server,
you
know - just a database).


What's the question?

To use SQL Express Compact Edition use the OLE DB Provider that comes with
it. Can't get to the disk or install at the moment, so I don't know the
exact name. Use the Data Link utility to find and connect.

MySQL has had several Ole Db Providers published for it. None has worked
well. Let's hope the new does. But what has that got to do with anything?

What's the real problem?

-ralph



.

Relevant Pages

  • Re: Insert a whole datatable
    ... Server Compact Edition. ... Hitchhiker's Guide to Visual Studio and SQL Server ... MasterDB and SubDB ...
    (microsoft.public.dotnet.framework.adonet)
  • Connecting to remote SQL database on the sbs does not work but will work on the workstations
    ... Hello we are soon creating a new system that will require our sql ... database on our websites dedicated server. ... An error has occurred while establishing a connection to the server. ... (provider: TCP Provider, error: 0 - A socket operation ...
    (microsoft.public.windows.server.sbs)
  • RE: OLE DB Provider - how tell to not use cursor internally for jo
    ... from server to client. ... me under SQL 2000 error, because DBE OLE provider use cursor for join tables. ... Under SQL 7.0 it run well, the cursor isn't use for join tables. ...
    (microsoft.public.sqlserver.programming)
  • Re: Woher kommt das Timeout?
    ... Im SQL Query Analyzer (SQL Server 2000). ... Also, ich will einen linked server in MS SQL Server 2000, also brauche ich ... OLE DB-Fehlertrace [OLE/DB Provider 'LCPI.IBProvider.2' ...
    (microsoft.public.de.sqlserver)
  • Re: Insert a whole datatable
    ... Server Compact Edition. ... Hitchhiker's Guide to Visual Studio and SQL Server ... MasterDB and SubDB ...
    (microsoft.public.dotnet.framework.adonet)