beginner in MSDE

Hello
Two questions:
I have installed the MSDE included on the Visual Studio NET, I use the tools in Visual to create data bases, but what other interface can I use to create MSDE data bases if I don't have SQL Server neither access ?
I create a view in a database with the following command:
SELECT ind_emp, lastName + firstName AS name FROM employee
when I try to run the view I received a message that says "operator ADD is not valid to use with texts champs" Why is that?
Thanks a lot
hi Carmen,
"Carmen" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:D15E830D-7C49-46D8-8F27-E737000A399E@.microsoft.com...
> Hello
> Two questions:
> I have installed the MSDE included on the Visual Studio NET, I use the
tools in Visual to create data bases, but what other interface can I use to
create MSDE data bases if I don't have SQL Server neither access ?
> I create a view in a database with the following command:
> SELECT ind_emp, lastName + firstName AS name FROM employee
> when I try to run the view I received a message that says "operator ADD is
not valid to use with texts champs" Why is that?
> Thanks a lot
>
in order to manage MSDE instance in a visual way, you can have a look at a
free prj of mine, available at the link following my sign.m which provides a
user interface similar to Enterprise Manager..
further tools are listed at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442
as regard your second question, you can not concatenate text and blob
columns like that..
anyway, you probably have to change the datatype for your lastName +
firstName columns to VARCHAR datatype..
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply