SQL CE and unknown databasefile

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kracks - 12 Sep 2007 17:53 GMT

Hi,

I have httpd webserver and once i give <ipaddr> it goes to remote
admin. I was able to receive the messages once i run dbconnect. asp
code(my sample code)in my webserver. The code just opens connection
with sqlserver.

My sample code is

Set conn = CreateObject("ADOCE.Connection.3.1")
conn.Open "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;" & _
"Data Source=\Northwind.sdf

Its showing the message:

Microsoft SQL Server 2000 Windows CE Edition: '80004005'
Description: The database file cannot be found. Check the path to the
database. [,,,File name,,]

I have a doubt whether that error message is because of webserver
running in virtualpath.
I set virtual path in my webserver.

Northwind.sdf i just copied from PC to target.

Anything wrong in my code

Whether i can copy the database to target using Active Sync.

Whether i can create a database in PC using SQLCE console and put to
target.

Pls .help.I am just fighting to talk to database from webserver.
Pls. suggest. how to open database in target wince device and talk
to it.

Regards,

Kirthika

Reply to this Message

Ginny Caughey [MVP] - 12 Sep 2007 18:02 GMT

It looks to me like you have the wrong OleDb provider. To connect to SQL
Compact 3.1 database on the desktop try
Provider=Microsoft.SqlServer.Mobile.OleDb.3.0. (SQL CE 2.0 databases can't
be used except on Windows CE machines.)

Signature

Ginny Caughey
Device Application Development MVP

> Hi,
>
[quoted text clipped - 35 lines]
>
> Kirthika

Reply to this Message

kracks - 12 Sep 2007 22:09 GMT

On Sep 12, 10:02 pm, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:

> It looks to me like you have the wrong OleDb provider. To connect to SQL
> Compact 3.1 database on the desktop try
[quoted text clipped - 50 lines]
>
> - Show quoted text -

Hi,

I tried
set conn=CreateObject("ADOCE.Connection.3.1")
conn.ConnectionString="Provider=Microsoft.SqlServer.Mobile.OleDb.3.0;
Data Source=\Northwind.sdf"

Its saying

Parse error in script

ASP scripting compilation error: '800a0e7a'

Description: ADO could not find the specified provider.

I copied the database file from mobile edition (\Northwind.sdf)

Is there anyother way to create a database for my target device and
put in target.

I added SQL Server CE 2.0 to OS design. But in my webpage its saying

Microsoft SQL Server 2000 Windows CE Edition: '80004005'
Is it right.

I copied the adoce31.dll from pocketPC 2002 and sqlceoledb is there in
platform builder itself since it is added with OS design.
I am not sure whether its true.

Many confusion with many SQL \
Pls. help...
I have to fix this problem soon...

Regards,
Kirthika

Reply to this Message

Ginny Caughey [MVP] - 12 Sep 2007 22:24 GMT

I'm confused. Are you trying to access the sdf file from a CE device or from
a desktop/server? On PocketPC 2002 you only have the choice of the older SQL
CE 2.0.

Signature

Ginny Caughey
Device Application Development MVP

> On Sep 12, 10:02 pm, "Ginny Caughey [MVP]"
> <ginny.caughey.onl...@wasteworks.com> wrote:
[quoted text clipped - 90 lines]
> Regards,
> Kirthika

Reply to this Message

kracks - 12 Sep 2007 23:11 GMT

On Sep 13, 2:24 am, "Ginny Caughey [MVP]"
<ginny.caughey.onl...@wasteworks.com> wrote:

> I'm confused. Are you trying to access the sdf file from a CE device or from
> a desktop/server? On PocketPC 2002 you only have the choice of the older SQL
[quoted text clipped - 104 lines]
>
> - Show quoted text -

hi,
Mine is ARMV4I based cpu.

The thing is i just copied database(Northwind.sdf) from \SQL Server
2005 Mobile edition and i put in target device.
In my target device i added SQL CE 2.0 from OS design.

I copied adoce31. dll, etc.... from Pocket PC/dataaccess/ARM

Since u said its because the problem of OLEDB on mobile edition
database (Northwind.sdf) i just put sqlceoledb.dll from Microsoft SQL
Server 2005 Mobile Edition\Device\Mobile\v3.0\wce500\armv4i and put
in target.

With my firmware i was able to open database.

But it reports the following error when try to open from desktop
application (sqlce console application)

You are trying to access an older version of a SQL Server Compact
Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run
upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later
database, run Compact / Repair. [Db version,Requested version,,File
name,,]

Whether i can create database but with what extension.. (.sdf)

Yah i am confused. Pls .help.

Regards,
kiruthika.

Reply to this Message

Ginny Caughey [MVP] - 12 Sep 2007 23:37 GMT

Here's the bottom line: the older devices can only handle SQL CE 2.0, but
SQL Mobile is the same is SQL CE 3.0, and the databases are somewhat
different. That is the source of the error message you're getting. You can
only use SQL Mobile and above on the desktop. If you need to work with SQL
CE 2.0 data from a desktop app, there are 3rd party products that can make
this work. I'm still not clear exactly what you want to do.

Signature

Ginny Caughey
Device Application Development MVP

> On Sep 13, 2:24 am, "Ginny Caughey [MVP]"
> <ginny.caughey.onl...@wasteworks.com> wrote:
[quoted text clipped - 143 lines]
> Regards,
> kiruthika.

Reply to this Message