does not install SQL Query Analyzer

Hi,

I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please?

cheers,

michael

Hi,

Sorry... for info I am using CS VS2005 and SQL Mobile.

Thank you.

michael

|||

Query Analyzer 3.0 should deploy automatically if you are building and deploying a DEBUG build in VS2005 given your reference to System.Data.SqlServerCe.dll version 2.0. You can also just grab the dev tools CAB and install it to your device/emulator to save time. it is located (depending on your device's WinCE kernel) at:

<drive:>\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4\sqlce30.dev.ENU.ppc.wce4.armv4.CAB

or

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\<device CPU architecture>\

Darren

does a view refresh itself when i reference it? (was "Question On Views")

guys, ive never worked with Views before so forgive me.
i know how to create one, and that it creates a virtual table in memory, but i've got one small question.

if i create a view:

CREATE view dbo.myView
as
select Distinct FirstName,LastName from SomeTable

When ever i reference that view, such as
Select FirstName,LastName
from myView
where LastName like 'Jo%'

does that View Refresh itself??

in other words does it run each time i Reference it? or is it static from when i created it.

Wouldnt it be easier just to use a #TempTable or some other Table thats used to hold a few values?

thanks for any help
rikDont worry man ,view is not static .It always fetch records from base table.It is uptodate unless u r using index on views|||You know - I've always thought that the definition of a view as something like a virtual table as very confusing. When I studied relational databases the chapter on views made an assumption that the reader would be very confused at what differentiated a view from a table and spent line after line emphasising the difference. "No " thought I "I can very well differentiate a view from a table - what the flip is the distinction between a view and a query?"

The way I tend to think of views (indexed views excluded) is that a view is best thought of as a persistent, optimised, stored query that can usually be treated in the same way that you would treat a table as far as viewing data is concerned. It is, however, just that - a view of the data. As such, it does not store any data itself. Every time you call it it views the data afresh.

HTH|||thank you guys so much. that's exactly the answer i was looking for.
thanks again
rik

do you have to recreate ODBC after installing MDAC 2.8

Hello:
I just want to ask a quick question just for my future reference. There's
no emergency or anything. Take this scenario.
Client workstations have an ODBC connection, and the Terminal Services box
has an ODBC connection. The versions of the ODBC driver are different, and
you want to make them the same.
So, you download and install MDAC 2.8 on the client workstations and the
Terminal Services box. The version of the ODBC driver, unfortunately, does
not change.
In order to get the versions updated, do the ODBC connections themselves
need to be recreated?
Thanks!
childofthe1980s
No...not necessarily. The only problems I've seen have been
just the general install issues on Terminal Server.
The driver version change doesn't change on which - TS or
the workstations? Did you verify with Component Checker? Did
you reboot? There are some different steps for installing
MDAC on TS - did you follow those?
How to Install ODBC or MDAC on Terminal Server
http://support.microsoft.com/?id=216149
-Sue
On Sun, 14 Jan 2007 09:59:00 -0800, childofthe1980s
<childofthe1980s@.discussions.microsoft.com> wrote:

>Hello:
>I just want to ask a quick question just for my future reference. There's
>no emergency or anything. Take this scenario.
>Client workstations have an ODBC connection, and the Terminal Services box
>has an ODBC connection. The versions of the ODBC driver are different, and
>you want to make them the same.
>So, you download and install MDAC 2.8 on the client workstations and the
>Terminal Services box. The version of the ODBC driver, unfortunately, does
>not change.
>In order to get the versions updated, do the ODBC connections themselves
>need to be recreated?
>Thanks!
>childofthe1980s