Showing posts with label studio. Show all posts
Showing posts with label studio. Show all posts

Friday, March 30, 2012

Installing MSDE2000

Hi,
I've been trying to follow Microsoft's instructions on installing MSDE2000 for Visual Studio. I do instancename=VSDOTNET SECURITY=SQL SAPWD=XXXX and all that. When I reboot, I notice that I have no services in the SQL Service Manager, nor can it find my computername.

Anybody know why this is?This is on Windows XP professional SP1.

Installing MSDE on different plattforms.

Product
Our product is developed in Visual Studio .NET using MFC and .NET.
It connects to a MS SQL Server Desktop Edition (MSDE), where the data is
stored.
Installation
Our problems relates to the installation of our product.
Installation happens in these steps:
- Install .NET
- Install MSDE2000 (with a SA password we have chosen)
- Reboot
- Start our own InstallDB.exe which does the follwoing:
-- Connects to the MSDE (the master database)
-- creates our own database (called "exordb" and creates our own sql
user called "exor")
-- Connects again to MSDE using the exor user and loads data into the
exordb database.
We are using the following connectionstring for connecting to master db the
first time.
Data Source=127.0.01; Integrated Security=SSPI;Initial Catalog=master
We are considering to use this one instead:
server=127.0.0.1;uid=sa;pwd=****;database=master
after the exordb is set up we connect using
server=127.0.0.1;uid=exor;pwd=***;database=exordb
Problems
1. (the most critical)
Installation failes (the first connection string) for some customers with XP
SP2 even if they turn off the firewall.
They get the standard SQLServer Exception:
SQL Server does not exist or access denied.
The MSDE is there (unnamed instance) and is ON.
2. (Windows 98)
When installed on Windows98 MSDE does not start automatically after the
reboot, at least that what it seems on the WIndows 98 machine we have tested
on. (We have also discovered that only SQL Autentification works on Win98,
we solved that by using the second connection string instead of the first
one).
3. (manual start of MSDE)
How may we detect (in our code, preferrably .NET/C#) that MSDE is not
running and how do we start it from the code?
4. (MSDE installed by someone else)
If MSDE is already installed on the computer by another program and
SQL-authentification is not set, how may we set it so our connection string
will work.
hi Vilhelm,
Vilhelm wrote:
> Product
> Our product is developed in Visual Studio .NET using MFC and .NET.
> It connects to a MS SQL Server Desktop Edition (MSDE), where the data
> is stored.
> Installation
> Our problems relates to the installation of our product.
> Installation happens in these steps:
> - Install .NET
> - Install MSDE2000 (with a SA password we have chosen)
> - Reboot
> - Start our own InstallDB.exe which does the follwoing:
> -- Connects to the MSDE (the master database)
> -- creates our own database (called "exordb" and creates our own
> sql user called "exor")
> -- Connects again to MSDE using the exor user and loads data into
> the exordb database.
>
> We are using the following connectionstring for connecting to master
> db the first time.
> Data Source=127.0.01; Integrated Security=SSPI;Initial
> Catalog=master
> We are considering to use this one instead:
> server=127.0.0.1;uid=sa;pwd=****;database=master
> after the exordb is set up we connect using
> server=127.0.0.1;uid=exor;pwd=***;database=exordb
> Problems
> 1. (the most critical)
> Installation failes (the first connection string) for some customers
> with XP SP2 even if they turn off the firewall.
> They get the standard SQLServer Exception:
> SQL Server does not exist or access denied.
> The MSDE is there (unnamed instance) and is ON.
I'm trying to get some more material about that kind of issue on XP sp2 to
report it to Microsoft representative... but I am unable to repro it in my
tests.. I'm aware of another issue on XP sp2 which cause installation
failure due to MDAC stack troubles, currently with no workaround as no MDAC
2.8 xp sp2 refresh is available... please forward me more info, if you
like..

> 2. (Windows 98)
> When installed on Windows98 MSDE does not start automatically after
> the reboot, at least that what it seems on the WIndows 98 machine we
> have tested on.
it's correct... MSDE runs as a standard application on Win9x platform as it
does not support service mode..
you should check that the service manager is added in the autostart folder
and that the "Autostart service when OS starts" check box is checked ..
to start MSDE you can call the SQL Server Service Manager as following:
(named instance)
scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
(default Instance)
scm.exe -Action 1 -Silent 1 -Service MSSQLServer
please keep in mind that, on Win9x, MSDE path will not be added to
autoexec.bat if you don't reboot the
computer, so you have to rely on Win32 API like FindFirstFile or the like to
find where the scm.exe is (usually ..\Program Files\Microsoft SQL
Server\80\Tools\Binn\scm.exe)

>(We have also discovered that only SQL
> Autentification works on Win98, we solved that by using the second
> connection string instead of the first one).
MSDE installed on Win9x does not support integrated security

> 3. (manual start of MSDE)
> How may we detect (in our code, preferrably .NET/C#) that MSDE is not
> running and how do we start it from the code?
you can rely on SQL-DMO COM object...
you can then ping it like
dim oServer as SQLDMO.SQLServer2
objServer.PingSQLServerVersion
start it, or just connect...

> 4. (MSDE installed by someone else)
> If MSDE is already installed on the computer by another program and
> SQL-authentification is not set, how may we set it so our connection
> string will work.
you have to manually change the login authentication mode, logging in as
member of the server's sysadmin role and setting the
objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
or modify the Windows registry
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
LoginMode=2
(HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
a named instance)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you a lot for some useful answers!!
More input on question 1.
I have not been able ot reproduce it here, but some of my customers report
this problem. Maybe we can resolve it with some well-phrased questions I can
ask one of my customers on the phone.
We use installshield Premier edition which installs MDAC 2.8 if necessary as
part of the installation process.
Vilhelm Heiberg
Norway.
"Andrea Montanari" wrote:

> hi Vilhelm,
> Vilhelm wrote:
> I'm trying to get some more material about that kind of issue on XP sp2 to
> report it to Microsoft representative... but I am unable to repro it in my
> tests.. I'm aware of another issue on XP sp2 which cause installation
> failure due to MDAC stack troubles, currently with no workaround as no MDAC
> 2.8 xp sp2 refresh is available... please forward me more info, if you
> like..
>
> it's correct... MSDE runs as a standard application on Win9x platform as it
> does not support service mode..
> you should check that the service manager is added in the autostart folder
> and that the "Autostart service when OS starts" check box is checked ..
> to start MSDE you can call the SQL Server Service Manager as following:
> (named instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQL$InstanceName
> (default Instance)
> scm.exe -Action 1 -Silent 1 -Service MSSQLServer
> please keep in mind that, on Win9x, MSDE path will not be added to
> autoexec.bat if you don't reboot the
> computer, so you have to rely on Win32 API like FindFirstFile or the like to
> find where the scm.exe is (usually ..\Program Files\Microsoft SQL
> Server\80\Tools\Binn\scm.exe)
>
> MSDE installed on Win9x does not support integrated security
>
> you can rely on SQL-DMO COM object...
> you can then ping it like
> dim oServer as SQLDMO.SQLServer2
> objServer.PingSQLServerVersion
> start it, or just connect...
>
> you have to manually change the login authentication mode, logging in as
> member of the server's sysadmin role and setting the
> objServer.IntegratedSecurity.SecurityMode = SQLDMOSecurity_Mixed
> or modify the Windows registry
> HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
> LoginMode=2
> (HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\InstanceName\MSSQLServer for
> a named instance)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

Installing MSDE 2000

I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd prompt
I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control panel
to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what this
message implies?
TX
Don't know if it has anything to do with it but can you firstly try..
Setup.exe SAPWD="password"
--Original Message--
From: CW [mailto:CW@.discussions.microsoft.com]
Posted At: Tuesday, 18 January 2005 7:55 AM
Posted To: microsoft.public.sqlserver.msde
Conversation: Installing MSDE 2000
Subject: Installing MSDE 2000
I'm trying to install SQL2000 Desktop for Visual Studio.Net. Fromcmd
prompt I'm running:
Setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1
SAPWD=password
Nothing happens then I get a popup saying: "Please go to the control
panel to install and configure system components".
How intuitive!! Does this mean MDAC upgrade or what? Anyone know what
this message implies?
TX

Wednesday, March 28, 2012

Installing Microsoft SQL server management studio express broke my asp.net databases

Morning,

I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine.

I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.

Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work.

Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.

Description: An

unhandled exception occurred during the execution of the current web

request. Please review the stack trace for more information about the

error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFY\ASPNET'.

I have posted a solution (that works for me) here.

And there are other solutions in that older post.

|||Simply set the user dafault database for the user to a database which is existing and accessible to him, either with the procedure sp_defaultdb or via the management Studio.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||It was working just fine till I installed the management studio though. What could that possibly be doing to muck with the permissions?

I checked and the user has the default database as master and it definately has access to it. None of the other solutions on this page worked either.

I am really really really unimpressed with this current situation, it is a terrible user experience.|||Make also sure that the database mentioned in the connection string (depending on your provider you are using, for .NET it should be "Initial Catalog" is existing and accessible to the user. if you didn′t configure the user extensivly just drop anbd recreate him. i don′t know which administrative tasks you did prior to this problem, but this should "reset" the settings. make also sure that the user is not in a group which has access denied in the database you are redirecting to. These right will be inherited to the user as restrictive right will always overwrite granted rights.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing Management Studio on Separate Computer from SQL 2005

I'm trying to install Management Studio on my dev box (separate from my server). But it won't install. Can someone give me a pointer or two?why won't it install? telling us the error would help.|||

It's basically complaining that SQL Server is not present on the machine.

I've already read however that if you install SSExpress 2005, the Management Studio won't install.

Hopefully that gets addressed somehow. Why should install order affect what I can and can't have on my machine?

|||

This is absolutely a supported configuration so something strange is going on. When do you get the error? What is the exact error message? Take a look at the following summary log file: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\summary.txt - it should provide additional clues or point to another log file with details. If there isn't any additional information in summary.txt take a look at: %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\log\files\*_core(local).log - you'll want to look at the latest version of this file. Near the bottom it should provide some clues as to what's going on.

Dan

|||

I'll try the install again tonight and let you know what the exact message is.

|||

To explain what happened, I deleted the local Windows Installer cache (that holds a copy of all the MSIs you have installed). When I did that, the SQL Server installer could not find the cached MSIs for MSXML6 and balked.

My solution was a handy tool called MSIZAP which you can use to repair aborted installations (or overzealous use of shift+delete in hidden system folders).by removing all references to the orphaned product.

Now if there were a way to tell MSI to not cache everything I install (the reason I butchered my system in the first place was that the cache had grown to gargantuan proportions).

So after zapping the orphaned SQLServer Install and reinstalling it, I am now able to use Management Studio from my development box.

installing management studio on a cluster

Hi,
I am installing sql 2005 on a two node cluster. I have managed to complete
the installation and then wanted to add the sql management studio on to the
cluster. I installed disk two and chose the support tools but have way
through the installation it failed with the following error:
Failed to install and configure assemblies C:\Program Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
I was installing this on the first node which had ownership of the shared
disks
Any ideas
Looks like you need to install a clustered instance of MSDTC.
http://www.microsoft.com/technet/prodtechnol/biztalk/2006/library/bts06clustering/55b0c81f-44a5-4069-b065-57df1cce19ac.mspx?mfr=true
Ignore the incoming caller stuff. That is for Biztalk.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:D07341A6-EDDA-4448-9C8A-23A1727E565B@.microsoft.com...
> Hi,
> I am installing sql 2005 on a two node cluster. I have managed to complete
> the installation and then wanted to add the sql management studio on to
> the
> cluster. I installed disk two and chose the support tools but have way
> through the installation it failed with the following error:
> Failed to install and configure assemblies C:\Program Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from
> HRESULT: 0x8004D01B)
> I was installing this on the first node which had ownership of the shared
> disks
>
> Any ideas

Installing Import/Export Wizard for SQL Express

Where do I install the necessary files to get the import/export wizard to show up in sql express management studio? I have tried installing the SP1 Toolkit, the advanced services etc but I cannot get it so that I can right click on a database and 'import data' or 'export data'

Thanks!

I am not sure but because Management studio express is for express database which does not support SSIS services and SQL agent which are used for export/import by wizard this option was removed from user interface.

Sorry

|||

It does not show up on the UI but I found it in this directory

C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I think it comes with the Toolkit download

Tony

Installing IIS After installing SQL server 2005 and visual studio 2005 help requested!

Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.

My situation:

My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.

So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.

The server is not connected to any network or the internet.

My Question:

Is their any way to fix this? and if yes could anyone tell me where to start

Thanks in Advance!

ps if their is information or logs that u need in order to help me just say so :-)

-Arjan

You are getting "Invalid namespace", check if you have installed SSRS properly or not. Check in the installation folders if you have all the folders (Log files, Report manager, report server, RSTempfiles). Also, for the config files.

You cannot report manager for sure since your SSRS is not configured properly. If you find nothing else, i guess you will have to reinstall SSRS.

To check for IIS, see if you are able to open the IIS Manager or not!!

Monday, March 26, 2012

Installing examples database

Hi
I need to install .sql and .mdf files
I'm using MSDE 2000 and Visual Studio .Net 2003
Thanks In Advance
__________________________
Rodrigo Juarez
__________________________
hi Rodrigo,
Rodrigo Juarez wrote:
> Hi
> I need to install .sql and .mdf files
> I'm using MSDE 2000 and Visual Studio .Net 2003
>
pubs and northwind database samples are available for download at
http://www.microsoft.com/downloads/d...displaylang=en
...
but I probably did not understand your requirements, did I? :D
plese expand on your question..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi
Thanks for your reply, and sorry for my english
I have some files contacts.mdf contacts.ldf and installcontacts.sql
I think that installcontacts.sql is a script for installing mdf and ldf
files, but I don't know how to install.
I'm using MSDE 2000 sp3, and I'm trying to run with osql, but I got some
errors ...
I run this command
osql -E -S (local)\NetSDK -i InstallContacts.sql
Attached is the .sql file
And this is the output
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 15010, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK,
Procedim
iento sp_dboption, Lnea 71
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 15010, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK,
Procedim
iento sp_dboption, Lnea 71
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 15010, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK,
Procedim
iento sp_dboption, Lnea 71
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 15010, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK,
Procedim
iento sp_dboption, Lnea 71
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 15010, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK,
Procedim
iento sp_dboption, Lnea 71
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 15010, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK,
Procedim
iento sp_dboption, Lnea 71
La base de datos 'Contacts' no existe. Utilice sp_helpdb para ver las bases
de
datos disponibles.
Available databases:
master
tempdb
model
msdb
pubs
Northwind
GrocerToGo
Portal
1> 2> 3> Mensaje 911, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK, Lnea
2
No se encuentra en sysdatabases la entrada de la base de datos 'Contacts'.
Asegrese de que ha escrito el nombre correctamente.
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> Mensaje 15007,
Nivel
16, Estado 1, Servidor DESARROLLO\NETSDK, Procedimiento sp_grantdbaccess,
Lnea
98
El inicio de sesin 'ASPNET' no existe.
1> 2> 3> 4> 5> Mensaje 15410, Nivel 11, Estado 1, Servidor
DESARROLLO\NETSDK, Pr
ocedimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> Mensaje 15410, Nivel 11, Estado 1, Servidor DESARROLLO\NETSDK,
Proce
dimiento sp_addrolemember, Lnea 66
El usuario o funcin 'ASPNET' no existe en la base de datos.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7>
8>
9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27>
28> 2
9> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3> 4> 5> 6> 7> 1> 2> 3>
Mensa
je 4604, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK, Lnea 2
No existe el usuario o grupo 'ASPNET'.
1> 2> 3> Mensaje 4604, Nivel 16, Estado 1, Servidor DESARROLLO\NETSDK, Lnea
2
No existe el usuario o grupo 'ASPNET'.
1> 2> 3> 1> 2> 3> Mensaje 4604, Nivel 16, Estado 1, Servidor
DESARROLLO\NETSDK,
Lnea 2
No existe el usuario o grupo 'ASPNET'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21>
22> 2
3> 24> 25> Mensaje 170, Nivel 15, Estado 1, Servidor DESARROLLO\NETSDK,
Lnea 15
Lnea 15: sintaxis incorrecta cerca de 'Contact Types'.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escribi en el mensaje
news:3t11u0FqcunfU1@.individual.net...
> hi Rodrigo,
> Rodrigo Juarez wrote:
> pubs and northwind database samples are available for download at
>
http://www.microsoft.com/downloads/d...displaylang=en
> ..
> but I probably did not understand your requirements, did I? :D
> plese expand on your question..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
begin 666 InstallContacts.sql
M__XO`"H`*@.`J`"H`*@.`J`" `3P!B`&H`90!C`'0`.@.`@.`" `1 !A`'0`80!B
M`&$`<P!E`" `0P!O`&X`= !A`&,`= !S`" `( `@.`" `4P!C`'(`:0!P`'0`
M( !$`&$`= !E`#H`( `S`"\`-P`O`#(`, `P`#(`( `Q`#H`-0`R`#H`- `T
M`" `4 !-`" `*@.`J`"H`*@.`J`"H`+P`-``H`20!&`" `10!8`$D`4P!4`%,`
M( `H`%,`10!,`$4`0P!4`" `;@.!A`&T`90`@.`$8`4@.!/`$T`( !M`&$`<P!T
M`&4`<@.`N`&0`8@.!O`"X`<P!Y`',`9 !A`'0`80!B`&$`<P!E`',`( !7`$@.`
M10!2`$4`( !N`&$`;0!E`" `/0`@.`$X`)P!#`&\`;@.!T`&$`8P!T`',`)P`I
M``T`"@.`)`$0`4@.!/`% `( !$`$$`5 !!`$(`00!3`$4`( !;`$,`;P!N`'0`
M80!C`'0`<P!=``T`"@.!'`$\`#0`*``T`"@.!#`%(`10!!`%0`1 0`@.`$0`00!4
M`$$`0@.!!`%,`10`@.`%L`0P!O`&X`= !A`&,`= !S`%T`( `@.`$\`3@.`@.`"@.`
M3@.!!`$T`10`@.`#T`( !.`"<`0P!O`&X`= !A`&,`= !S`%\`1 !A`'0`80`G
M`"P`( !&`$D`3 !%`$X`00!-`$4`( `]`" `3@.`G`%P`30!#`%,`1 !7`&4`
M8@.!!`' `< !S`%P`8P!H`&$`< !T`&4`<@.`P`#4`7 !#`&\`;@.!T`&$`8P!T
M`',`+@.!-`$0`1@.`G`" `+ `@.`%,`20!:`$4`( `]`" `,@.`L`" `1@.!)`$P`
M10!'`%(`3P!7`%0`2 `@.`#T`( `Q`# `)0`I`" `3 !/`$<`( !/`$X`( `H
M`$X`00!-`$4`( `]`" `3@.`G`$,`;P!N`'0`80!C`'0`<P!?`$P`;P!G`"<`
M+ `@.`$8`20!,`$4`3@.!!`$T`10`@.`#T`( !.`"<`7 !-`$,`4P!$`%<`90!B
M`$$`< !P`',`7 !C`&@.`80!P`'0`90!R`# `-0!<`$,`;P!N`'0`80!C`'0`
M<P`N`$P`1 !&`"<`( `L`" `4P!)`%H`10`@.`#T`( `Q`"P`( !&`$D`3 !%
M`$<`4@.!/`%<`5 !(`" `/0`@.`#$`, `E`"D`#0`*`" `0P!/`$P`3 !!`%0`
M10`@.`%,`40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0
M`#$`7P!#`$D`7P!!`%,`#0`*`$<`3P`-``H`#0`*`&4`> !E`&,`( !S`' `
M7P!D`&(`;P!P`'0`:0!O`&X`( !.`"<`0P!O`&X`= !A`&,`= !S`"<`+ `@.
M`$X`)P!A`'4`= !O`&,`; !O`',`90`G`"P`( !.`"<`9@.!A`&P`<P!E`"<`
M#0`*`$<`3P`-``H`#0`*`&4`> !E`&,`( !S`' `7P!D`&(`;P!P`'0`:0!O
M`&X`( !.`"<`0P!O`&X`= !A`&,`= !S`"<`+ `@.`$X`)P!B`'4`; !K`&,`
M;P!P`'D`)P`L`" `3@.`G`&8`80!L`',`90`G``T`"@.!'`$\`#0`*``T`"@.!E
M`'@.`90!C`" `<P!P`%\`9 !B`&\`< !T`&D`;P!N`" `3@.`G`$,`;P!N`'0`
M80!C`'0`<P`G`"P`( !.`"<`= !R`'4`;@.!C`"X`( !L`&\`9P`G`"P`( !.
M`"<`9@.!A`&P`<P!E`"<`#0`*`$<`3P`-``H`#0`*`&4`> !E`&,`( !S`' `
M7P!D`&(`;P!P`'0`:0!O`&X`( !.`"<`0P!O`&X`= !A`&,`= !S`"<`+ `@.
M`$X`)P!T`&\`<@.!N`" `< !A`&<`90`@.`&0`90!T`&4`8P!T`&D`;P!N`"<`
M+ `@.`$X`)P!T`'(`=0!E`"<`#0`*`$<`3P`-``H`#0`*`&4`> !E`&,`( !S
M`' `7P!D`&(`;P!P`'0`:0!O`&X`( !.`"<`0P!O`&X`= !A`&,`= !S`"<`
M+ `@.`$X`)P!R`&4`80!D`" `;P!N`&P`>0`G`"P`( !.`"<`9@.!A`&P`<P!E
M`"<`#0`*`$<`3P`-``H`#0`*`&4`> !E`&,`( !S`' `7P!D`&(`;P!P`'0`
M:0!O`&X`( !.`"<`0P!O`&X`= !A`&,`= !S`"<`+ `@.`$X`)P!D`&(`;P`@.
M`'4`<P!E`"<`+ `@.`$X`)P!F`&$`; !S`&4`)P`-``H`1P!/``T`"@.`-``H`
M90!X`&4`8P`@.`',`< !?`&0`8@.!O`' `= !I`&\`;@.`@.`$X`)P!#`&\`;@.!T
M`&$`8P!T`',`)P`L`" `3@.`G`',`:0!N`&<`; !E`"<`+ `@.`$X`)P!F`&$`
M; !S`&4`)P`-``H`1P!/``T`"@.`-``H`90!X`&4`8P`@.`',`< !?`&0`8@.!O
M`' `= !I`&\`;@.`@.`$X`)P!#`&\`;@.!T`&$`8P!T`',`)P`L`" `3@.`G`&$`
M=0!T`&\`<P!H`'(`:0!N`&L`)P`L`" `3@.`G`&8`80!L`',`90`G``T`"@.!'
M`$\`#0`*``T`"@.!E`'@.`90!C`" `<P!P`%\`9 !B`&\`< !T`&D`;P!N`" `
M3@.`G`$,`;P!N`'0`80!C`'0`<P`G`"P`( !.`"<`00!.`%,`20`@.`&X`=0!L
M`&P`( !D`&4`9@.!A`'4`; !T`"<`+ `@.`$X`)P!F`&$`; !S`&4`)P`-``H`
M1P!/``T`"@.`-``H`90!X`&4`8P`@.`',`< !?`&0`8@.!O`' `= !I`&\`;@.`@.
M`$X`)P!#`&\`;@.!T`&$`8P!T`',`)P`L`" `3@.`G`'(`90!C`'4`<@.!S`&D`
M=@.!E`" `= !R`&D`9P!G`&4`<@.!S`"<`+ `@.`$X`)P!F`&$`; !S`&4`)P`-
M``H`1P!/``T`"@.`-``H`90!X`&4`8P`@.`',`< !?`&0`8@.!O`' `= !I`&\`
M;@.`@.`$X`)P!#`&\`;@.!T`&$`8P!T`',`)P`L`" `3@.`G`$$`3@.!3`$D`( !N
M`'4`; !L`',`)P`L`" `3@.`G`&8`80!L`',`90`G``T`"@.!'`$\`#0`*``T`
M"@.!E`'@.`90!C`" `<P!P`%\`9 !B`&\`< !T`&D`;P!N`" `3@.`G`$,`;P!N
M`'0`80!C`'0`<P`G`"P`( !.`"<`8P!O`&X`8P!A`'0`( !N`'4`; !L`" `
M>0!I`&4`; !D`',`( !N`'4`; !L`"<`+ `@.`$X`)P!F`&$`; !S`&4`)P`-
M``H`1P!/``T`"@.`-``H`90!X`&4`8P`@.`',`< !?`&0`8@.!O`' `= !I`&\`
M;@.`@.`$X`)P!#`&\`;@.!T`&$`8P!T`',`)P`L`" `3@.`G`&,`=0!R`',`;P!R
M`" `8P!L`&\`<P!E`" `;P!N`" `8P!O`&T`;0!I`'0`)P`L`" `3@.`G`&8`
M80!L`',`90`G``T`"@.!'`$\`#0`*``T`"@.!E`'@.`90!C`" `<P!P`%\`9 !B
M`&\`< !T`&D`;P!N`" `3@.`G`$,`;P!N`'0`80!C`'0`<P`G`"P`( !.`"<`
M9 !E`&8`80!U`&P`= `@.`'0`;P`@.`&P`;P!C`&$`; `@.`&,`=0!R`',`;P!R
M`"<`+ `@.`$X`)P!F`&$`; !S`&4`)P`-``H`1P!/``T`"@.`-``H`90!X`&4`
M8P`@.`',`< !?`&0`8@.!O`' `= !I`&\`;@.`@.`$X`)P!#`&\`;@.!T`&$`8P!T
M`',`)P`L`" `3@.`G`'$`=0!O`'0`90!D`" `:0!D`&4`;@.!T`&D`9@.!I`&4`
M<@.`G`"P`( !.`"<`9@.!A`&P`<P!E`"<`#0`*`$<`3P`-``H`#0`*`&4`> !E
M`&,`( !S`' `7P!D`&(`;P!P`'0`:0!O`&X`( !.`"<`0P!O`&X`= !A`&,`
M= !S`"<`+ `@.`$X`)P!!`$X`4P!)`" `=P!A`'(`;@.!I`&X`9P!S`"<`+ `@.
M`$X`)P!F`&$`; !S`&4`)P`-``H`1P!/``T`"@.`-``H`90!X`&4`8P`@.`',`
M< !?`&0`8@.!O`' `= !I`&\`;@.`@.`$X`)P!#`&\`;@.!T`&$`8P!T`',`)P`L
M`" `3@.`G`&$`=0!T`&\`( !C`'(`90!A`'0`90`@.`',`= !A`'0`:0!S`'0`
M:0!C`',`)P`L`" `3@.`G`'0`<@.!U`&4`)P`-``H`1P!/``T`"@.`-``H`90!X
M`&4`8P`@.`',`< !?`&0`8@.!O`' `= !I`&\`;@.`@.`$X`)P!#`&\`;@.!T`&$`
M8P!T`',`)P`L`" `3@.`G`&$`=0!T`&\`( !U`' `9 !A`'0`90`@.`',`= !A
M`'0`:0!S`'0`:0!C`',`)P`L`" `3@.`G`'0`<@.!U`&4`)P`-``H`1P!/``T`
M"@.`-``H`=0!S`&4`( !;`$,`;P!N`'0`80!C`'0`<P!=``T`"@.!'`$\`#0`*
M``T`"@.`O`"H`*@.`J`"H`*@.`J`" `3P!B`&H`90!C`'0`.@.`@.`" `5 !A`&(`
M; !E`" `6P!D`&(`;P!=`"X`6P!#`&$`; !L`',`70`@.`" `( `@.`%,`8P!R
M`&D`< !T`" `1 !A`'0`90`Z`" `,P`O`#<`+P`R`# `, `R`" `,0`Z`#4`
M,@.`Z`#0`.0`@.`% `30`@.`"H`*@.`J`"H`*@.`J`"\`#0`*`&D`9@.`@.`&4`> !I
M`',`= !S`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`
M+@.!S`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.
M`&\`8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`0P!A`&P`
M; !S`%T`)P`I`" `80!N`&0`( !/`$(`2@.!%`$,`5 !0`%(`3P!0`$4`4@.!4
M`%D`* !I`&0`+ `@.`$X`)P!)`',`50!S`&4`<@.!4`&$`8@.!L`&4`)P`I`" `
M/0`@.`#$`*0`-``H`9 !R`&\`< `@.`'0`80!B`&P`90`@.`%L`9 !B`&\`70`N
M`%L`0P!A`&P`; !S`%T`#0`*`$<`3P`-``H`#0`*`"\`*@.`J`"H`*@.`J`"H`
M( !/`&(`:@.!E`&,`= `Z`" `( !4`&$`8@.!L`&4`( !;`&0`8@.!O`%T`+@.!;
M`$,`;P!N`'0`80!C`'0`( !4`'D`< !E`',`70`@.`" `( `@.`%,`8P!R`&D`
M< !T`" `1 !A`'0`90`Z`" `,P`O`#<`+P`R`# `, `R`" `,0`Z`#4`,@.`Z
M`#0`.0`@.`% `30`@.`"H`*@.`J`"H`*@.`J`"\`#0`*`&D`9@.`@.`&4`> !I`',`
M= !S`" `* !S`&4`; !E`&,`= `@.`"H`( !F`'(`;P!M`" `9 !B`&\`+@.!S
M`'D`<P!O`&(`:@.!E`&,`= !S`" `=P!H`&4`<@.!E`" `:0!D`" `/0`@.`&\`
M8@.!J`&4`8P!T`%\`:0!D`"@.`3@.`G`%L`9 !B`&\`70`N`%L`0P!O`&X`= !A
M`&,`= `@.`%0`>0!P`&4`<P!=`"<`*0`@.`&$`;@.!D`" `3P!"`$H`10!#`%0`
M4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`20!S`%4`<P!E`'(`5 !A
M`&(`; !E`"<`*0`@.`#T`( `Q`"D`#0`*`&0`<@.!O`' `( !T`&$`8@.!L`&4`
M( !;`&0`8@.!O`%T`+@.!;`$,`;P!N`'0`80!C`'0`( !4`'D`< !E`',`70`-
M``H`1P!/``T`"@.`-``H`+P`J`"H`*@.`J`"H`*@.`@.`$\`8@.!J`&4`8P!T`#H`
M( `@.`%0`80!B`&P`90`@.`%L`9 !B`&\`70`N`%L`0P!O`&X`= !A`&,`= !S
M`%T`( `@.`" `( !3`&,`<@.!I`' `= `@.`$0`80!T`&4`.@.`@.`#,`+P`W`"\`
M,@.`P`# `,@.`@.`#$`.@.`U`#(`.@.`T`#D`( !0`$T`( `J`"H`*@.`J`"H`*@.`O
M``T`"@.!I`&8`( !E`'@.`:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `
M9@.!R`&\`;0`@.`&0`8@.!O`"X`<P!Y`',`;P!B`&H`90!C`'0`< P`@.`'<`: !E
M`'(`90`@.`&D`9 `@.`#T`( !O`&(`:@.!E`&,`= !?`&D`9 `H`$X`)P!;`&0`
M8@.!O`%T`+@.!;`$,`;P!N`'0`80!C`'0`<P!=`"<`*0`@.`&$`; @.!D`" `3P!"
M`$H`10!#`%0`4 !2`$\`4 !%`%(`5 !9`"@.`:0!D`"P`( !.`"<`20!S`%4`
M<P!E`'(`5 !A`&(`; !E`"<`*0`@.`#T`( `Q`"D`#0`*`&0`<@.!O`' `( !T
M`&$`8@.!L`&4`( !;`&0`8@.!O`%T`+@.!;`$,`;P!N`'0`80!C`'0`<P!=``T`
M"@.!'`$\`#0`*``T`"@.`O`"H`*@.`J`"H`*@.`J`" `3P!B`&H`90!C`'0`.@.`@.
M`" `50!S`&4`<@.`@.`$$`4P!0`$X`10!4`" `( `@.`" `4P!C`'(`:0!P`'0`
M( !$`&$`= !E`#H`( `S`"\`-P`O`#(`, `P`#(`( `Q`#H`-0`R`#H`- `U
M`" `4 !-`" `*@.`J`"H`*@.`J`"H`+P`-``H`:0!F`" `;@.!O`'0`( !E`'@.`
M:0!S`'0`<P`@.`"@.`<P!E`&P`90!C`'0`( `J`" `9@.!R`&\`;0`@.`&0`8@.!O
M`"X`<P!Y`',`=0!S`&4`<@.!S`" `=P!H`&4`<@.!E`" `;@.!A`&T`90`@.`#T`
M( !.`"<`00!3`% `3@.!%`%0`)P`@.`&$`;@.!D`" `=0!I`&0`( `\`" `,0`V
M`#,`. `R`"D`#0`*``D`10!8`$4`0P`@.`',`< !?`&<`<@.!A`&X`= !D`&(`
M80!C`&,`90!S`',`( !.`"<`00!3`% `3@.!%`%0`)P`L`" `3@.`G`$$`4P!0
M`$X`10!4`"<`#0`*`$<`3P`-``H`#0`*`"\`*@.`J`"H`*@.`J`"H`( !/`&(`
M:@.!E`&,`= `Z`" `( !5`',`90!R`" `9 !B`&\`( `@.`" `( !3`&,`<@.!I
M`' `= `@.`$0`80!T`&4`.@.`@.`#,`+P`W`"\`,@.`P`# `,@.`@.`#$`.@.`U`#(`
M.@.`T`#4`( !0`$T`( `J`"H`*@.`J`"H`*@.`O``T`"@.`O`"H`*@.`J`"H`*@.`J
M`" `3P!B`&H`90!C`'0`.@.`@.`" `50!S`&4`<@.`@.`$$`4P!0`$X`10!4`" `
M( `@.`" `4P!C`'(`:0!P`'0`( !$`&$`= !E`#H`( `S`"\`-P`O`#(`, `P
M`#(`( `Q`#H`-0`R`#H`- `U`" `4 !-`" `*@.`J`"H`*@.`J`"H`+P`-``H`
M90!X`&4`8P`@.`',`< !?`&$`9 !D`'(`;P!L`&4`;0!E`&T`8@.!E`'(`( !.
M`"<`9 !B`%\`80!C`&,`90!S`',`80!D`&T`:0!N`"<`+ `@.`$X`)P!!`%,`
M4 !.`$4`5 `G``T`"@.!'`$\`#0`*``T`"@.`O`"H`*@.`J`"H`*@.`J`" `3P!B
M`&H`90!C`'0`.@.`@.`" `50!S`&4`<@.`@.`$$`4P!0`$X`10!4`" `( `@.`" `
M4P!C`'(`:0!P`'0`( !$`&$`= !E`#H`( `S`"\`-P`O`#(`, `P`#(`( `Q
M`#H`-0`R`#H`- `U`" `4 !-`" `*@.`J`"H`*@.`J`"H`+P`-``H`90!X`&4`
M8P`@.`',`< !?`&$`9 !D`'(`;P!L`&4`;0!E`&T`8@.!E`'(`( !.`"<`9 !B
M`%\`8@.!A`&,`:P!U`' `;P!P`&4`<@.!A`'0`;P!R`"<`+ `@.`$X`)P!!`%,`
M4 !.`$4`5 `G``T`"@.!'`$\`#0`*``T`"@.`O`"H`*@.`J`"H`*@.`J`" `3P!B
M`&H`90!C`'0`.@.`@.`" `50!S`&4`<@.`@.`$$`4P!0`$X`10!4`" `( `@.`" `
M4P!C`'(`:0!P`'0`( !$`&$`= !E`#H`( `S`"\`-P`O`#(`, `P`#(`( `Q
M`#H`-0`R`#H`- `U`" `4 !-`" `*@.`J`"H`*@.`J`"H`+P`-``H`90!X`&4`
M8P`@.`',`< !?`&$`9 !D`'(`;P!L`&4`;0!E`&T`8@.!E`'(`( !.`"<`9 !B
M`%\`9 !A`'0`80!R`&4`80!D`&4`<@.`G`"P`( !.`"<`00!3`% `3@.!%`%0`
M)P`-``H`1P!/``T`"@.`-``H`+P`J`"H`*@.`J`"H`*@.`@.`$\`8@.!J`&4`8P!T
M`#H`( `@.`%4`<P!E`'(`( !!`%,`4 !.`$4`5 `@.`" `( `@.`%,`8P!R`&D`
M< !T`" `1 !A`'0`90`Z`" `,P`O`#<`+P`R`# `, `R`" `,0`Z`#4`,@.`Z
M`#0`-0`@.`% `30`@.`"H`*@.`J`"H`*@.`J`"\`#0`*`&4`> !E`&,`( !S`' `
M7P!A`&0`9 !R`&\`; !E`&T`90!M`&(`90!R`" `3@.`G`&0`8@.!?`&0`80!T
M`&$`=P!R`&D`= !E`'(`)P`L`" `3@.`G`$$`4P!0`$X`10!4`"<`#0`*`$<`
M3P`-``H`#0`*`"\`*@.`J`"H`*@.`J`"H`( !/`&(`:@.!E`&,`= `Z`" `( !5
M`',`90!R`" `00!3`% `3@.!%`%0`( `@.`" `( !3`&,`<@.!I`' `= `@.`$0`
M80!T`&4`.@.`@.`#,`+P`W`"\`,@.`P`# `,@.`@.`#$`.@.`U`#(`.@.`T`#4`( !0
M`$T`( `J`"H`*@.`J`"H`*@.`O``T`"@.!E`'@.`90!C`" `<P!P`%\`80!D`&0`
M<@.!O`&P`90!M`&4`;0!B`&4`<@.`@.`$X`)P!D`&(`7P!D`&0`; !A`&0`;0!I
M`&X`)P`L`" `3@.`G`$$`4P!0`$X`10!4`"<`#0`*`$<`3P`-``H`#0`*`"\`
M*@.`J`"H`*@.`J`"H`( !/`&(`:@.!E`&,`= `Z`" `( !5`',`90!R`" `00!3
M`% `3@.!%`%0`( `@.`" `( !3`&,`<@.!I`' `= `@.`$0`80!T`&4`.@.`@.`#,`
M+P`W`"\`,@.`P`# `,@.`@.`#$`.@.`U`#(`.@.`T`#4`( !0`$T`( `J`"H`*@.`J
M`"H`*@.`O``T`"@.!E`'@.`90!C`" `<P!P`%\`80!D`&0`<@.!O`&P`90!M`&4`
M;0!B`&4`<@.`@.`$X`)P!D`&(`7P!D`&4`;@.!Y`&0`80!T`&$`< @.!E`&$`9 !E
M`'(`)P`L`" `3@.`G`$$`4P!0`$X`10!4`"<`#0`*`$<`3P`-``H`#0`*`"\`
M*@.`J`"H`*@.`J`"H`( !/`&(`:@.!E`&,`= `Z`" `( !5`',`90!R`" `00!3
M`% `3@.!%`%0`( `@.`" `( !3`&,`<@.!I`' `= `@.`$0`80!T`&4`.@.`@.`#,`
M+P`W`"\`,@.`P`# `,@.`@.`#$`.@.`U`#(`.@.`T`#4`( !0`$T`( `J`"H`*@.`J
M`"H`*@.`O``T`"@.!E`'@.`90!C`" `<P!P`%\`80!D`&0`<@.!O`&P`90!M`&4`
M;0!B`&4`<@.`@.`$X`)P!D`&(`7P!D`&4`;@.!Y`&0`80!T`&$`= P!R`&D`= !E
M`'(`)P`L`" `3@.`G`$$`4P!0`$X`10!4`"<`#0`*`$<`3P`-``H`#0`*`"\`
M*@.`J`"H`*@.`J`"H`( !/`&(`:@.!E`&,`= `Z`" `( !5`',`90!R`" `00!3
M`% `3@.!%`%0`( `@.`" `( !3`&,`<@.!I`' `= `@.`$0`80!T`&4`.@.`@.`#,`
M+P`W`"\`,@.`P`# `,@.`@.`#$`.@.`U`#(`.@.`T`#4`( !0`$T`( `J`"H`*@.`J
M`"H`*@.`O``T`"@.!E`'@.`90!C`" `<P!P`%\`80!D`&0`<@.!O`&P`90!M`&4`
M;0!B`&4`<@.`@.`$X`)P!D`&(`7P!O`'<`;@.!E`'(`)P`L`" `3@.`G`$$`4P!0
M`$X`10!4`"<`#0`*`$<`3P`-``H`#0`*`"\`*@.`J`"H`*@.`J`"H`( !/`&(`
M:@.!E`&,`= `Z`" `( !5`',`90!R`" `00!3`% `3@.!%`%0`( `@.`" `( !3
M`&,`<@.!I`' `= `@.`$0`80!T`&4`.@.`@.`#,`+P`W`"\`,@.`P`# `,@.`@.`#$`
M.@.`U`#(`.@.`T`#4`( !0`$T`( `J`"H`*@.`J`"H`*@.`O``T`"@.!E`'@.`90!C
M`" `<P!P`%\`80!D`&0`<@.!O`&P`90!M`&4`;0!B`&4`<@.`@.`$X`) P!D`&(`
M7P!S`&4`8P!U`'(`:0!T`'D`80!D`&T`:0!N`"<`+ `@.`$X`)P!!`%,`4 !.
M`$4`5 `G``T`"@.!'`$\`#0`*``T`"@.`O`"H`*@.`J`"H`*@.`J`" `3P!B`&H`
M90!C`'0`.@.`@.`" `5 !A`&(`; !E`" `6P!D`&(`;P!=`"X`6P!#`&$`; !L
M`',`70`@.`" `( `@.`%,`8P!R`&D`< !T`" `1 !A`'0`90`Z`" `,P`O`#<`
M+P`R`# `, `R`" `,0`Z`#4`,@.`Z`#4`,0`@.`% `30`@.`"H`*@.`J`"H`*@.`J
M`"\`#0`*`$,`4@.!%`$$`5 !%`" `5 !!`$(`3 !%`" `6P!D`&(`;P!=`"X`
M6P!#`&$`; !L`',`70`@.`"@.`#0`*``D`6P!#`&$`; !L`$D`1 !=`" `6P!I
M`&X`= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`;P!N`'0`
M80!C`'0`20!$`%T`( !;`&D`;@.!T`%T`( !.`$\`5 `@.`$X`50!,`$P`( `L
M``T`"@.`)`%L`0P!A`&P`; !$`&$`= !E`%T`( !;`&0`80!T`&4`= !I`&T`
M90!=`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!#`&$`; !L`%0`:0!M`&4`70`@.
M`%L`9 !A`'0`90!T`&D`;0!E`%T`( !.`%4`3 !,`" `+ `-``H`"0!;`%,`
M=0!B`&H`90!C`'0`70`@.`%L`;@.!V`&$`<@.!C`&@.`80!R`%T`( `H`#(`-0`U
M`"D`( !#`$\`3 !,`$$`5 !%`" `4P!1`$P`7P!,`&$`= !I`&X`,0!?`$<`
M90!N`&4`<@.!A`&P`7P!#`% `,0!?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L
M``T`"@.`)`%L`3@.!O`'0`90!S`%T`( !;`&X`= !E`'@.`= !=`" `0P!/`$P`
M3 !!`%0`10`@.`%,`40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L
M`%\`0P!0`#$`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `#0`*`"D`( !/`$X`
M( !;`% `4@.!)`$T`00!2`%D`70`@.`%0`10!8`%0`20!-`$$`1P!%`%\`3P!.
M`" `6P!0`%(`20!-`$$`4@.!9`%T`#0`*`$<`3P`-``H`#0`*`"\`*@.`J`"H`
M*@.`J`"H`( !/`&(`:@.!E`&,`= `Z`" `( !4`&$`8@.!L`&4`( !;`&0`8@.!O
M`%T`+@.!;`$,`;P!N`'0`80!C`'0`( !4`'D`< !E`',`70`@.`" `( `@.`%,`
M8P!R`&D`< !T`" `1 !A`'0`90`Z`" `,P`O`#<`+P`R`# `, `R`" `,0`Z
M`#4`,@.`Z`#4`-0`@.`% `30`@.`"H`*@.`J`"H`*@.`J`"\`#0`*`$,`4@.!%`$$`
M5 !%`" `5 !!`$(`3 !%`" `6P!D`&(`;P!=`"X`6P!#`&\`;@.!T`&$`8P!T
M`" `5 !Y`' `90!S`%T`( `H``T`"@.`)`%L`0P!O`&X`= !A`&,`= !4`'D`
M< !E`$D`1 !=`" `6P!I`&X`= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-
M``H`"0!;`$,`;P!N`'0`80!C`'0`5 !Y`' `90!=`" `6P!N`'8`80!R`&,`
M: !A`'(`70`@.`"@.`-0`P`"D`( !#`$\`3 !,`$$`5 !%`" `4P!1`$P`7P!,
M`&$`= !I`&X`,0!?`$<`90!N`&4`<@.!A`&P`7P!#`% `,0!?`$,`20!?`$$`
M4P`@.`$X`50!,`$P`( `-``H`*0`@.`$\`3@.`@.`%L`4 !2`$D`30!!`%(`60!=
M``T`"@.!'`$\`#0`*``T`"@.`O`"H`*@.`J`"H`*@.`J`" `3P!B`&H`90!C`'0`
M.@.`@.`" `5 !A`&(`; !E`" `6P!D`&(`;P!=`"X`6P!#`&\`;@.!T`&$`8P!T
M`',`70`@.`" `( `@.`%,`8P!R`&D`< !T`" `1 !A`'0`90`Z`" `,P`O`#<`
M+P`R`# `, `R`" `,0`Z`#4`,@.`Z`#4`-0`@.`% `30`@.`"H`*@.`J`"H`*@.`J
M`"\`#0`*`$,`4@.!%`$$`5 !%`" `5 !!`$(`3 !%`" `6P!D`&(`;P!=`"X`
M6P!#`&\`;@.!T`&$`8P!T`',`70`@.`"@.`#0`*``D`6P!#`&\`; @.!T`&$`8P!T
M`$D`1 !=`" `6P!I`&X`= !=`" `3@.!/`%0`( !.`%4`3 !,`" `+ `-``H`
M"0!;`$8`:0!R`',`= !.`&$`;0!E`%T`( !;`&X`=@.!A`'(`8P!H`&$`<@.!=
M`" `* `U`# `*0`@.`$,`3P!,`$P`00!4`$4`( !3`%$`3 !?`$P`80!T`&D`
M;@.`Q`%\`1P!E`&X`90!R`&$`; !?`$,`4 `Q`%\`0P!)`%\`00!3`" `3@.!5
M`$P`3 `@.`"P`#0`*``D`6P!,`&$`<P!T`$X`80!M`&4`70`@.`%L`;@.!V `&$`
M<@.!C`&@.`80!R`%T`( `H`#4`, `I`" `0P!/`$P`3 !!`%0`10`@.`%,`40!,
M`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0`#$`7P!# `$D`
M7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$0`90!A`'(`70`@.`%L`;@.!V
M`&$`<@.!C`&@.`80!R`%T`( `H`#4`, `I`" `0P!/`$P`3 !!`%0`10`@.`%,`
M40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0`#$`7P!#
M`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$$`9 !D`'(`90!S`',`
M70`@.`%L`;@.!V`&$`<@.!C`&@.`80!R`%T`( `H`#(`-0`U`"D`( !#`$\`3 !,
M`$$`5 !%`" `4P!1`$P`7P!,`&$`= !I`&X`,0!?`$<`90!N`&4`<@.!A`&P`
M7P!#`% `,0!?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`0P!I
M`'0`>0!=`" `6P!N`'8`80!R`&,`: !A`'(`70`@.`"@.`-0`P`"D`( !#`$\`
M3 !,`$$`5 !%`" `4P!1`$P`7P!,`&$`= !I`&X`,0!?`$<`90!N`&4`<@.!A
M`&P`7P!#`% `,0!?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`
M4P!T`&$`= !E`$\`<@.!0`'(`;P!V`&D`;@.!C`&4`70`@.`%L`;@.!V`&$`<@.!C
M`&@.`80!R`%T`( `H`#(`, `I`" `0P!/`$P`3 !!`%0`10`@.`%,`40!,`%\`
M3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0`#$`7P!# `$D`7P!!
M`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`% `;P!S`'0`80!L`$,`;P!D`&4`
M70`@.`%L`;@.!V`&$`<@.!C`&@.`80!R`%T`( `H`#(`, `I`" `0P!/`$P`3 !!
M`%0`10`@.`%,`40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`
M0P!0`#$`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`%(`90!G
M`&D`;P!N`%T`( !;`&X`=@.!A`'(`8P!H`&$`<@.!=`" `* `U`# `*0`@.`$,`
M3P!,`$P`00!4`$4`( !3`%$`3 !?`$P`80!T`&D`;@.`Q`%\`1P!E`&X`90!R
M`&$`; !?`$,`4 `Q`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`
M6P!#`&\`=0!N`'0`<@.!Y`%T`( !;`&X`=@.!A`'(`8P!H`&$`<@.!=`" `* `U
M`# `*0`@.`$,`3P!,`$P`00!4`$4`( !3`%$`3 !?`$P`80!T`&D`;@.`Q`%\`
M1P!E`&X`90!R`&$`; !?`$,`4 `Q`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.
M`"P`#0`*``D`6P!#`&\`;0!P`&$`;@.!Y`$X`80!M`&4`70`@.` %L`;@.!V`&$`
M<@.!C`&@.`80!R`%T`( `H`#4`, `I`" `0P!/`$P`3 !!`%0`10`@.`%,`40!,
M`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0`#$`7P!# `$D`
M7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`%0`:0!T`&P`90!=`" `6P!N
M`'8`80!R`&,`: !A`'(`70`@.`"@.`-0`P`"D`( !#`$\`3 !,`$$`5 !%`" `
M4P!1`$P`7P!,`&$`= !I`&X`,0!?`$<`90!N`&4`<@.!A`&P`7P!#`% `,0!?
M`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`5P!O`'(`:P!0`&@.`
M;P!N`&4`70`@.`%L`;@.!V`&$`<@.!C`&@.`80!R`%T`( `H`#,`, `I`" `0P!/
M`$P`3 !!`%0`10`@.`%,`40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`
M80!L`%\`0P!0`#$`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;
M`%<`;P!R`&L`10!X`'0`90!N`',`:0!O`&X`70`@.`%L`;@.!V` &$`<@.!C`&@.`
M80!R`%T`( `H`#(`, `I`" `0P!/`$P`3 !!`%0`10`@.`%,`40!,`%\`3 !A
M`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0`#$`7P!#` $D`7P!!`%,`
M( !.`%4`3 !,`" `+ `-``H`"0!;`$@.`;P!M`&4`4 !H`&\`;@.!E`%T`( !;
M`&X`=@.!A`'(`8P!H`&$`<@.!=`" `* `S`# `*0`@.`$,`3P!,`$P`00!4`$4`
M( !3`%$`3 !?`$P`80!T`&D`;@.`Q`%\`1P!E`&X`90!R`&$`; !?`$,`4 `Q
M`%\`0P!)`%\`00!3`" `3@.!5`$P`3 `@.`"P`#0`*``D`6P!-`&\`8@.!I`&P`
M90!0`&@.`;P!N`&4`70`@.`%L`;@.!V`&$`<@.!C`&@.`80!R`%T`( `H`#,`, `I
M`" `0P!/`$P`3 !!`%0`10`@.`%,`40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`
M;@.!E`'(`80!L`%\`0P!0`#$`7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-
M``H`"0!;`$8`80!X`$X`=0!M`&(`90!R`%T`( !;`&X`=@.!A`'(`8P!H`&$`
M<@.!=`" `* `S`# `*0`@.`$,`3P!,`$P`00!4`$4`( !3`%$`3 !?`$P`80!T
M`&D`;@.`Q`%\`1P!E`&X`90!R`&$`; !?`$,`4 `Q`%\`0P!)`%\`00!3`" `
M3@.!5`$P`3 `@.`"P`#0`*``D`6P!%`&T`80!I`&P`3@.!A`&T`90!=`" `6P!N
M`'8`80!R`&,`: !A`'(`70`@.`"@.`-0`P`"D`( !#`$\`3 !,`$$`5 !%`" `
M4P!1`$P`7P!,`&$`= !I`&X`,0!?`$<`90!N`&4`<@.!A`&P`7P!#`% `,0!?
M`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`0@.!I`'(`= !H`&0`
M80!T`&4`70`@.`%L`<P!M`&$`; !L`&0`80!T`&4`= !I`&T`90!=`" `3@.!5
M`$P`3 `@.`"P`#0`*``D`6P!,`&$`<P!T`$T`90!E`'0`:0!N`&<`1 !A`'0`
M90!=`" `6P!S`&T`80!L`&P`9 !A`'0`90!T`&D`;0!E`%T`( !.`%4`3 !,
M`" `+ `-``H`"0!;`$,`;P!N`'0`80!C`'0`5 !Y`' `90!)`$0`70`@.`%L`
M:0!N`'0`70`@.`$X`50!,`$P`( `L``T`"@.`)`%L`4@.!E`&8`90!R`'(`90!D
M`$(`>0!=`" `6P!N`'8`80!R`&,`: !A`'(`70`@.`"@.`-0`P`"D`( !#`$\`
M3 !,`$$`5 !%`" `4P!1`$P`7P!,`&$`= !I`&X`,0!?`$<`90!N`&4`<@.!A
M`&P`7P!#`% `,0!?`$,`20!?`$$`4P`@.`$X`50!,`$P`( `L``T`"@.`)`%L`
M3@.!O`'0`90!S`%T`( !;`&X`= !E`'@.`= !=`" `0P!/`$P`3 !!`%0`10`@.
M`%,`40!,`%\`3 !A`'0`:0!N`#$`7P!'`&4`;@.!E`'(`80!L`%\`0P!0`#$`
M7P!#`$D`7P!!`%,`( !.`%4`3 !,`" `+ `-``H`"0!;`$,`;P!N`'0`80!C
M`'0`<P!)`&X`= !E`'(`90!S`'0`<P!=`" `6P!N`'8`80!R`&,`: !A`'(`
M70`@.`"@.`,@.`U`#4`*0`@.`$,`3P!,`$P`00!4`$4`( !3`%$`3 !?`$P`80!T
M`&D`;@.`Q`%\`1P!E`&X`90!R`&$`; !?`$,`4 `Q`%\`0P!)`%\`00!3`" `
M3@.!5`$P`3 `@.``T`"@.`I`" `3P!.`" `6P!0`%(`20!-`$$`4@.!9`%T`( !4
M`$4`6 !4`$D`30!!`$<`10!?`$\`3@.`@.`%L`4 !2`$D`30!!`%(`60!=``T`
M"@.!'`$\`#0`*``T`"@.!!`$P`5 !%`%(`( !4`$$`0@.!,`$4`( !;`&0`8@.!O
M`%T`+@.!;`$,`80!L`&P`<P!=`" `5P!)`%0`2 `@.`$X`3P!#`$@.`10!#`$L`
M( !!`$0`1 `@.``T`"@.`)`$,`3P!.`%,`5 !2`$$`20!.`%0`( !;`% `2P!?
M`%\`0P!A`&P`; !S`%\`7P`U`#D`, `V`#,`00`T`#<`70`@.`% `4@.!)`$T`
M00!2`%D`( !+`$4`60`@.`" `0P!,`%4`4P!4`$4`4@.!%`$0`( `-``H`"0`H
M``T`"@.`)``D`6P!#`&$`; !L`$D`1 !=``T`"@.`)`"D`( `@.`$\`3@.`@.`%L`
M4 !2`$D`30!!`%(`60!=`" `#0`*`$<`3P`-``H`#0`*`$$`3 !4`$4`4@.`@.
M`%0`00!"`$P`10`@.`%L`9 !B`&\`70`N`%L`0P!O`&X`= !A`&,`= `@.`%0`
M>0!P`&4`<P!=`" `5P!)`%0`2 `@.`$X`3P!#`$@.`10!#`$L`( !!`$0`1 `@.
M``T`"@.`)`$,`3P!.`%,`5 !2`$$`20!.`%0`( !;`% `2P!?`%\`0P!O`&X`
M= !A`&,`= `@.`%0`>0!P`&4`<P!?`%\`-0!!`$4`10`X`#(`0@.`Y`%T`( !0
M`%(`20!-`$$`4@.!9`" `2P!%`%D`( `@.`$,`3 !5`%,`5 !%`%(`10!$`" `
M#0`*``D`* `-``H`"0`)`%L`0P!O`&X`= !A`&,`= !4`'D`< !E`$D`1 !=
M``T`"@.`)`"D`( `@.`$\`3@.`@.`%L`4 !2`$D`30!!`%(`60!=`" `#0`*`$<`
M3P`-``H`#0`*`$$`3 !4`$4`4@.`@.`%0`00!"`$P`10`@.`%L`9 !B`&\`70`N
M`%L`0P!O`&X`= !A`&,`= !S`%T`( !7`$D`5 !(`" `3@.!/`$,`2 !%`$,`
M2P`@.`$$`1 !$`" `#0`*``D`0P!/`$X`4P!4`%(`00!)`$X`5 `@.`%L`4 !+
M`%\`7P!#`&\`;@.!T`&$`8P!T`',`7P!?`#4`0P!$`#8`0P!"` #(`0@.!=`" `
M4 !2`$D`30!!`%(`60`@.`$L`10!9`" `( !#`$P`50!3`%0`10!2`$4`1 `@.
M``T`"@.`)`"@.`#0`*``D`"0!;`$,`;P!N`'0`80!C`'0`20!$` %T`#0`*``D`
M*0`@.`" `3P!.`" `6P!0`%(`20!-`$$`4@.!9`%T`( `-``H`1P!/``T`"@.`-
M``H`1P!2`$$`3@.!4`" `( !2`$4`1@.!%`%(`10!.`$,`10!3`" `+ `@.`" `
M4P!%`$P`10!#`%0`( `L`" `( !5`% `1 !!`%0`10`@.`"P`( `@.`$D`3@.!3
M`$4`4@.!4`" `+ `@.`" `1 !%`$P`10!4`$4`( `@.`$\`3@.`@.`%L`9 !B`&\`
M70`N`%L`0P!A`&P`; !S`%T`( `@.`%0`3P`@.`%L`00!3`% `3@.!%`%0`70`-
M``H`1P!/``T`"@.`-``H`1P!2`$$`3@.!4`" `( !2`$4`1@.!%`%(`10!.`$,`
M10!3`" `+ `@.`" `4P!%`$P`10!#`%0`( `L`" `( !5`% `1 !!`%0`10`@.
M`"P`( `@.`$D`3@.!3`$4`4@.!4`" `+ `@.`" `1 !%`$P`10!4`$4`( `@.`$\`
M3@.`@.`%L`9 !B`&\`70`N`%L`0P!O`&X`= !A`&,`= `@.`%0`>0!P`&4`<P!=
M`" `( !4`$\`( !;`$$`4P!0`$X`10!4`%T`#0`*`$<`3P`-``H`#0`*`$<`
M4@.!!`$X`5 `@.`" `4P!%`$P`10!#`%0`( `@.`$\`3@.`@.`%L`9 !B`&\`70`N
M`%L`0P!O`&X`= !A`&,`= !S`%T`( `@.`%0`3P`@.`%L`< !U`&(`; !I`&,`
M70`-``H`1P!/``T`"@.`-``H`1P!2`$$`3@.!4`" `( !2`$4`1@.!%`%(`10!.
M`$,`10!3`" `+ `@.`" `4P!%`$P`10!#`%0`( `L`" `( !5`% `1 !!`%0`
M10`@.`"P`( `@.`$D`3@.!3`$4`4@.!4`" `+ `@.`" `1 !%`$P`10!4`$4`( `@.
M`$\`3@.`@.`%L`9 !B`&\`70`N`%L`0P!O`&X`= !A`&,`= !S`%T`( `@.`%0`
M3P`@.`%L`00!3`% `3@.!%`%0`70`-``H`1P!/``T`"@.`-``H`#0`*`$D`3@.!3
M`$4`4@.!4`" `0P!O`&X`= !A`&,`= !S`" `5@.!!`$P`50!%`%,`( `H`#$`
M+ `@.`"<`2P!I`&T`)P`L`" `)P!!`&(`90!R`&,`<@.!O`&T`8@.!I`&4`)P`L
M`" `)P!-`',`+@.`G`"P`( `G`#$`,@.`S`#0`( !,`&\`;@.!E`" `1 !R`"X`
M)P`L`" `)P!-`&\`8@.!I`&P`90`G`"P`( `G`$$`3 `G`"P`( `G`#D`.0`Y
M`#D`.0`Y`"<`+ `@.`$X`50!,`$P`+ `@.`"<`50!3`$$`)P`L`" `)P!7`&D`
M9 !E`" `5P!O`'(`; !D`" `20!M`' `;P!R`'0`90!R`',`)P`L`" `3@.!5
M`$P`3 `L`" `)P`H`#$`,0`Q`"D`( `U`#4`-0`M`#$`,0`Q`#$`)P`L`" `
M)P`Y`#D`.0`G`"P`( `G`"@.`,0`Q`#$`*0`@.`#4`-0`U`"T`,@.`R`#(`,@.`G
M`"P`3@.!5`$P`3 `L`" `3@.!5`$P`3 `L`"<`<P!O`&T`90!O`&X`90! `&T`
M:0!C`'(`;P!S`&\`9@.!T`"X`8P!O`&T`)P`@.`"P`( `G`#@.`+P`S`"\`,0`Y
M`#8`,0`G`"P`( !.`%4`3 !,`"P`( `Q`"P`( !.`%4`3 !,`"P`( !.`%4`
M3 !,`"P`( `G`% `80!R`&$`<P!A`&D`; !I`&X`9P`G`"D`#0`*`$D`3@.!3
M`$4`4@.!4`" `0P!O`&X`= !A`&,`= !S`" `5@.!!`$P`50!%`%,`( `H`#(`
M+ `@.`"<`2@.!A`'D`)P`L`" `)P!!`&0`80!M`',`)P`L`" `)P!-`'(`+@.`G
M`"P`( `G`#8`,P`Q`" `10!A`&<`; !E`" `4@.!D`"X`)P`L`" `)P!7`&$`
M= !E`'(`= !O`'<`;@.`G`"P`( `G`% `00`G`"P`( `G`#D`.0`Y`#D`.0`Y
M`"<`+ `@.`$X`50!,`$P`+ `@.`"<`50!3`$$`)P`L`" `)P!&`&$`8@.!R`&D`
M:P!A`&T`)P`L`" `3@.!5`$P`3 `L`" `)P`H`#$`,0`Q`"D`( `U`#4`-0`M
M`#$`,0`Q`#(`)P`L`" `)P`X`#@.`. `G`"P`( `G`"@.`,0`Q`#$`*0`@.`#4`
M-0`U`"T`,@.`R`#(`,@.`G`"P`3@.!5`$P`3 `L`" `3@.!5`$P`3 `L`"<`<P!O
M`&T`90!O`&X`90! `&T`:0!C`'(`;P!S`&\`9@.!T`"X`8P!O`&T`)P`@.`"P`
M( `G`#0`+P`Q`"\`,0`Y`#0`,@.`G`"P`( !.`%4`3 !,`"P`( `S`"P`( !.
M`%4`3 !,`"P`( !.`%4`3 !,`"P`( !.`%4`3 !,`"D`#0`*`$D`3@.!3`$4`
M4@.!4`" `0P!O`&X`= !A`&,`= !S`" `5@.!!`$P`50!%`%,`( `H`#,`+ `@.
M`"<`00!D`&$`;0`G`"P`( `G`$(`80!R`"<`+ `@.`"<`30!R`"X`)P`L`" `
M)P`U`#4`( !0`&$`<P!S`&$`=P!A`'D`( !!`'8`90`N`"<`+ `@.`"<`0@.!O
M`',`= !O`&X`)P`L`" `)P!-`$$`)P`L`" `)P`Y`#D`.0`Y`#D`.0`G`"P`
M( !.`%4`3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`5P!I`&0`90`@.`%<`;P!R
M`&P`9 `@.`$D`;0!P`&\`<@.!T`&4`<@.!S`"<`+ `@.`$X`50!,`$P`+ `@.`"<`
M* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`S`"<`+ `@.`$X`50!,`$P`+ `@.
M`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`R`#(`,@.`R`"<`+ !.`%4`3 !,`"P`
M( !.`%4`3 !,`"P`)P!S`&\`;0!E`&\`;@.!E`$ `;0!I`&,`<@.!O`',`;P!F
M`'0`+@.!C`&\`;0`G`" `+ `@.`"<`,@.`O`#,`+P`Q`#D`-@.`U`"<`+ `@.`$X`
M50!,`$P`+ `@.`#0`+ `@.`$X`50!,`$P`+ `@.`$X`50!,`$P`+ `@.`"<`1@.!L
M`'D`( !F`&D`<P!H`&D`;@.!G`"<`*0`-``H`20!.`%,`10!2`%0`( !#`&\`
M;@.!T`&$`8P!T`',`( !6`$$`3 !5`$4`4P`@.`"@.`- `L`" `)P!)`&0`;P`G
M`"P`( `G`$(`90!N`"T`4P!A`&,`: !A`'(`)P`L`" `)P!-`'(`+@.`G`"P`
M( `G`#8`, `R`$$`( !,`&4`90!W`&$`<@.!D`" `1 !R`"X`)P`L`" `)P!3
M`&$`<@.!A`',`;P!T`&$`)P`L`" `)P!&`$P`)P`L`" `)P`Y`#D`.0`Y`#D`
M.0`G`"P`( !.`%4`3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`5P!I`&0`90`@.
M`%<`;P!R`&P`9 `@.`$D`;0!P`&\`<@.!T`&4`<@.!S`"<`+ `@.`$X`50!,`$P`
M+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`T`"<`+ `@.`"<`-P`W
M`#<`)P`L`" `)P`H`#$`,0`Q`"D`( `U`#4`-0`M`#(`,@.`R`#(`)P`L`$X`
M50!,`$P`+ `@.`$X`50!,`$P`+ `G`',`;P!M`&4`;P!N`&4`0 !M`&D`8P!R
M`&\`<P!O`&8`= `N`&,`;P!M`"<`( `L`" `)P`Q`"\`,@.`R`"\`,0`Y`#8`
M, `G`"P`( !.`%4`3 !,`"P`( `Q`"P`( !.`%4`3 !,`"P`( !.`%4`3 !,
M`"P`( !.`%4`3 !,`"D`#0`*`$D`3@.!3`$4`4@.!4`" `0P!O`&X`= !A`&,`
M= !S`" `5@.!!`$P`50!%`%,`( `H`#4`+ `@.`"<`0@.!R`&$`9 !L`&4`>0`G
M`"P`( `G`$(`90!C`&L`)P`L`" `)P!-`'(`+@.`G`"P`( `G`#0`- `@.`$$`
M9 !A`&T`<P`@.`%,`= `N`"<`+ `@.`"<`4 !A`'(`:P!A`'<`80!Y`"<`+ `@.
M`"<`3@.!*`"<`+ `@.`"<`.0`Y`#D`.0`Y`#D`)P`L`" `3@.!5`$P`3 `L`" `
M)P!5`%,`00`G`"P`( `G`$$`9 !V`&4`;@.!T`'4`<@.!E`" `5P!O`'(`:P!S
M`"<`+ `@.`$X`50!,`$P`+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`
M,0`U`"<`+ `@.`"<`,P`S`#,`)P`L`" `)P`H`#$`,0`Q`"D`( `U`#4`-0`M
M`#(`,@.`R`#(`)P`L`$X`50!,`$P`+ `@.`$X`50!,`$P`+ `G`',`;P!M`&4`
M;P!N`&4`0 !M`&D`8P!R`&\`<P!O`&8`= `N`&,`;P!M`"<`( `L`" `)P`Y
M`"\`,P`P`"\`,0`Y`#4`.0`G`"P`( !.`%4`3 !,`"P`( `R`"P`( !.`%4`
M3 !,`"P`( !.`%4`3 !,`"P`( !.`%4`3 !,`"D`#0`*`$D`3@.!3`$4`4@.!4
M`" `0P!O`&X`= !A`&,`= !S`" `5@.!!`$P`50!%`%,`( `H`#8`+ `@.`"<`
M2P!A`'(`90!N`"<`+ `@.`"<`0@.!E`'(`9P!E`"<`+ `@.`"<`30!R`',`+@.`G
M`"P`( `G`#(`, `U`" `3 !O`&X`90`@.`$0`<@.`N`"<`+ `@.`"<`30!O`&(`
M:0!L`&4`)P`L`" `)P!!`$P`)P`L`" `)P`Y`#D`.0`Y`#D`.0`G`"P`( !.
M`%4`3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`5P!I`&0`90`@.`%<`;P!R`&P`
M9 `@.`$D`;0!P`&\`<@.!T`&4`<@.!S`"<`+ `@.`$X`50!,`$P`+ `@.`"<`* `Q
M`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`V`"<`+ `@.`$X`50!,`$P`+ `@.`"<`
M* `Q`#$`,0`I`" `-0`U`#4`+0`R`#(`,@.`R`"<`+ !.`%4`3 !,`"P`( !.
M`%4`3 !,`"P`)P!S`&\`;0!E`&\`;@.!E`$ `;0!I`&,`<@.!O`',`;P!F`'0`
M+@.!C`&\`;0`G`" `+ `@.`"<`-@.`O`#<`+P`Q`#D`-@.`P`"<`+ `@.`$X`50!,
M`$P`+ `@.`#,`+ `@.`$X`50!,`$P`+ `@.`$X`50!,`$P`+ `@.`"<`5P!I`&X`
M9 !S`'4`<@.!F`&D`;@.!G`"<`*0`-``H`20!.`%,`10!2`%0`( !#`&\`;@.!T
M`&$`8P!T`',`( !6`$$`3 !5`$4`4P`@.`"@.`-P`L`" `)P!3`&,`;P!T`'0`
M)P`L`" `)P!"`&D`<P!H`&\`< `G`"P`( `G`$0`<@.`N`"<`+ `@.`"<`. `X
M`#D`. `@.`$P`:0!P`',`: !A`'<`( !"`&P`=@.!D`"X`)P`L`" `)P!0`&$`
M<@.!A`&0`:0!S`&4`)P`L`" `)P!/`%(`)P`L`" `)P`Y`#D`.0`Y`#D`.0`G
M`"P`( !.`%4`3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`5P!I`&0`90`@.`%<`
M;P!R`&P`9 `@.`$D`;0!P`&\`<@.!T`&4`<@.!S`"<`+ `@.`$X`50!,`$P`+ `@.
M`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`W`"<`+ `@.`"<`-0`U`#4`
M)P`L`" `)P`H`#$`,0`Q`"D`( `U`#4`-0`M`#(`,@.`R`#(`)P`L`$X`50!,
M`$P`+ `@.`$X`50!,`$P`+ `G`',`;P!M`&4`;P!N`&4`0 !M`&D`8P!R`&\`
M<P!O`&8`= `N`&,`;P!M`"<`( `L`" `)P`Q`#$`+P`R`#,`+P`Q`#D`-@.`Q
M`"<`+ `@.`$X`50!,`$P`+ `@.`#$`+ `@.`$X`50!,`$P`+ `@.`$X`50!,`$P`
M+ `@.`$X`50!,`$P`*0`-``H`20!.`%,`10!2`%0`( !#`&\`;@.!T`&$`8P!T
M`',`( !6`$$`3 !5`$4`4P`@.`"@.`. `L`" `)P!0`&$`= `G`"P`( `G`$,`
M;P!L`&4`;0!A`&X`)P`L`" `)P!-`',`+@.`G`"P`( `G`%(`= !E`" `,P`@.
M`$@.`:0!G`&@.`=P!A`'D`( `Y`#D`)P`L`" `)P!#`&D`<@.!C`&P`90`@.`$,`
M:0!T`'D`)P`L`" `)P!!`%H`)P`L`" `)P`Y`#D`.0`Y`#D`.0`G`"P`( !.
M`%4`3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`1@.!A`&(`<@.!I`&L`80!M`"<`
M+ `@.`$X`50!,`$P`+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`X
M`"<`+ `@.`"<`. `W`"<`+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`R`#(`
M,@.`R`"<`+ !.`%4`3 !,`"P`( !.`%4`3 !,`"P`)P!S`&\`;0!E`&\`;@.!E
M`$ `;0!I`&,`<@.!O`',`;P!F`'0`+@.!C`&\`;0`G`" `+ `@.`"<`,0`P`"\`
M,0`S`"\`,0`Y`#<`, `G`"P`( !.`%4`3 !,`"P`( `R`"P`( !.`%4`3 !,
M`"P`( !.`%4`3 !,`"P`( `G`%,`:P!I`&D`;@.!G`"<`*0`-``H`20!.`%,`
M10!2`%0`( !#`&\`;@.!T`&$`8P!T`',`( !6`$$`3 !5`$4`4P`@.`"@.`.0`L
M`" `)P!*`&$`;@.!E`"<`+ `@.`"<`0P!L`&$`>0!T`&\`;@.`G`"P`( `G`$T`
M<P`N`"<`+ `@.`"<`,@.`@.`%<`>0!L`&0`9@.!L`&\`=P!E`'(`( !,`&X`+@.`G
M`"P`( `G`$(`;P!U`&P`9 !E`'(`)P`L`" `)P!#`$\`)P`L`" `)P`Y`#D`
M.0`Y`#D`.0`G`"P`( !.`%4`3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`5P!I
M`&0`90`@.`%<`;P!R`&P`9 `@.`$D`;0!P`&\`<@.!T`&4`<@.!S`"<`+ `@.`$X`
M50!,`$P`+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`Y`"<`+ `@.
M`"<`,@.`R`"<`+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`R`#(`,@.`R`"<`
M+ !.`%4`3 !,`"P`( !.`%4`3 !,`"P`)P!S`&\`;0!E`&\`;@.!E`$ `;0!I
M`&,`<@.!O`',`;P!F`'0`+@.!C`&\`;0`G`" `+ `@.`"<`-0`O`#0`+P`Q`#D`
M-@.`Q`"<`+ `@.`$X`50!,`$P`+ `@.`#,`+ `@.`$X`50!,`$P`+ `@.`$X`50!,
M`$P`+ `@.`"<`2 !U`&X`= !I`&X`9P`G`"D`#0`*`$D`3@.!3`$4`4@.!4`" `
M0P!O`&X`= !A`&,`= !S`" `5@.!!`$P`50!%`%,`( `H`#$`, `L`" `)P!+
M`&$`<@.!I`"<`+ `@.`"<`2 !E`&X`<P!I`&4`;@.`G`"P`( `G`$T`<P`N`"<`
M+ `@.`"<`- `S`" `4P!T`&\`<@.!M`'<`80!T`&4`<@.`@.`$,`<@.`N`"<`+ `@.
M`"<`20!N`&0`:0!A`&P`80!N`'0`:0!C`"<`+ `@.`"<`1@.!,`"<`+ `@.`"<`
M.0`Y`#D`.0`Y`#D`)P`L`" `3@.!5`$P`3 `L`" `)P!5`%,`00`G`"P`( `G
M`$$`9 !V`&4`;@.!T`'4`<@.!E`" `5P!O`'(`:P!S`"<`+ `@.`$X`50!,`$P`
M+ `@.`"<`* `Q`#$`,0`I`" `-0`U`#4`+0`Q`#$`,0`P`"<`+ `@.`"<`, `Y
M`#@.`. `G`"P`( `G`"@.`,0`Q`#$`*0`@.`#4`-0`U`"T`,@.`R`#(`,@.`G`"P`
M3@.!5`$P`3 `L`" `3@.!5`$P`3 `L`"<`<P!O`&T`90!O`&X`90! `&T`:0!C
M`'(`;P!S`&\`9@.!T`"X`8P!O`&T`)P`@.`"P`( `G`#<`+P`W`"\`,0`Y`#4`
M.0`G`"P`( !.`%4`3 !,`"P`( `Q`"P`( !.`%4`3 !,`"P`( !.`%4`3 !,
M`"P`( !.`%4`3 !,`"D`#0`*`$D`3@.!3`$4`4@.!4`" `0P!O`&X`= !A`&,`
M= !S`" `5@.!!`$P`50!%`%,`( `H`#$`,0`L`" `)P!$`&\`;@.`G`"P`( `G
M`$8`=0!N`&L`)P`L`" `)P!-`'(`+@.`G`"P`( `G`#4`-0`@.`$T`;P!C`&,`
M80!S`&D`;@.`@.`%<`80!L`&P`;P!W`" `1 !R`"X`)P`L`" `)P!%`'(`;@.!S
M`'0`)P`L`" `)P!&`$P`)P`L`" `)P`Y`#D`.0`Y`#D`.0`G`"P`( !.`%4`
M3 !,`"P`( `G`%4`4P!!`"<`+ `@.`"<`1@.!O`'4`<@.!T`&@.`( !#`&\`9@.!F
M`&4`90`G`"P`( !.`%4`3 !,`"P`( `G`"@.`,0`Q`#$`*0`@.`#4`-0`U`"T`
M,0`Q`#(`, `G`"P`( `G`#$`,0`Q`"<`+ `@.`"<`* `Q`#$`,0`I`" `-0`U
M`#4`+0`R`#(`,@.`R`"<`+ !.`%4`3 !,`"P`( !.`%4`3 !,`"P`)P!S`&\`
M;0!E`&\`;@.!E`$ `;0!I`&,`<@.!O`',`;P!F`'0`+@.!C`&\`;0`G`" `+ `@.
M`"<`,P`O`#$`-0`O`#$`.0`V`#8`)P`L`" `3@.!5`$P`3 `L`" `,0`L`" `
M3@.!5`$P`3 `L`" `3@.!5`$P`3 `L`" `3@.!5`$P`3 `I``T`"@.`-``H`20!.
M`%,`10!2`%0`( `B`$,`;P!N`'0`80!C`'0`( !4`'D`< !E`',`(@.`@.`%8`
M00!,`%4`10!3`"@.`,0`L`" `)P!"`'4`<P!I`&X`90!S`',`)P`I``T`"@.!)
M`$X`4P!%`%(`5 `@.`"(`0P!O`&X`= !A`&,`= `@.`%0`>0!P`&4`<P`B`" `
M5@.!!`$P`50!%`%,`* `R`"P`( `G`%,`;P!C`&D`80!L`"<`*0`-``H`20!.
M`%,`10!2`%0`( `B`$,`;P!N`'0`80!C`'0`( !4`'D`< !E`',`(@.`@.`%8`
M00!,`%4`10!3`"@.`,P`L`" `)P!&`'(`:0!E`&X`9 `G`"D`#0`*`$D`3@.!3
M`$4`4@.!4`" `(@.!#`&\`;@.!T`&$`8P!T`" `5 !Y`' `90!S`"(`( !6`$$`
M3 !5`$4`4P`H`#0`+ `@.`"<`1@.!I`',`: !I`&X`9P`@.`&(`=0!D`&0`>0`G
M`"D`#0`*``T`"@.!)`$X`4P!%`%(`5 `@.`$,`80!L`&P`<P`@.`%8`00!,`%4`
M10!3`"@.`,0`L`#$`+ `G`#,`+P`S`"\`,@.`P`# `,@.`G`"P`( `G`#$`,@.`Z
M`# `, !0`$T`)P`L`" `)P!(`&\`<P!T`&D`;@.!G`" `<P!E`'(`=@.!I`&,`
M90!S`"<`+ `@.`"<`4@.!E`'0`=0!R`&X`( !C`&$`; !L`" `=P!I`'0`: `@.
M`&4`<P!T`&D`;0!A`'0`90!S`"<`*0`-``H`20!.`%,`10!2`%0`( !#`&$`
M; !L`',`( !6`$$`3 !5`$4`4P`H`#(`+ `S`"P`)P`S`"\`,P`O`#(`, `P
M`#(`)P`L`" `)P`Q`#H`, `P`% `30`G`"P`( `G`%0`<@.!I`' `( !T`&\`
M( !!`'H`;P!R`&4`<P`G`"P`( `G`$<`;P!T`" `; !O`',`= `@.`&\`;@.`@.
M`'<`80!Y`"X`( !.`&4`90!D`',`( !D`&D`<@.!E`&,`= !I`&\`;@.!S`"X`
M)P`I``T`"@.!)`$X`4P!%`%(`5 `@.`$,`80!L`&P`<P`@.`%8`00!,`%4`10!3
M`"@.`,P`L`#(`+ `G`#(`+P`Q`"\`,@.`P`# `,@.`G`"P`( `G`#$`, `Z`# `
M, !!`$T`)P`L`" `)P!,`&\`;@.!G`" `8P!A`&P`; `G`"P`( `G`$$`( !V
M`&4`<@.!Y`"P`( !V`&4`<@.!Y`" `; !O`&X`9P`@.`&,`80!L`&P`+@.`G`"D`
,#0`*``T`"@.`-``H`
`
end

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

sql

Installing Developer Edition Management Studio

I'm attempting to upgrade from SQL Express to SQL Developer. I uninstalled completely before loading Dev edition, but I can't seem to install the Management Studio now. Any ideas?

Hello Joe,

Could you please let us know what error you are getting while installing Dev edition?

This will help in narrowing down the cause so that we can resolve it quickly.

Regards,

Rajesh

|||

Actually, I just had to clean up the Windows Installer. Once I removed any references to Express Editions of visual studio and mssql, it worked just fine.

Thanks anyhow.

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||

Hi

Would you kindly guide me with installing the Data Mining Web Controls. In my SQL Server 2005 installation I cannot find a way to install samples. I tried to download all the relevant SQL Server 2005 samples from Codeplex but still the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder is not created.

|||

Rbonnici,

Just a couple thoughts:

Have you tried installing the samples from your SQL Server 2005 install discs? You may have better luck. Have you tried performing searching on your box for the file? Maybe it didnt install in that location. Also, Have you verified that the installs you downloaded from CodePlex actually installed by looking in Add/Remove programs?

I have never had or heard of the samples not installing.

-Cam

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||

Hi

Would you kindly guide me with installing the Data Mining Web Controls. In my SQL Server 2005 installation I cannot find a way to install samples. I tried to download all the relevant SQL Server 2005 samples from Codeplex but still the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls folder is not created.

|||

Rbonnici,

Just a couple thoughts:

Have you tried installing the samples from your SQL Server 2005 install discs? You may have better luck. Have you tried performing searching on your box for the file? Maybe it didnt install in that location. Also, Have you verified that the installs you downloaded from CodePlex actually installed by looking in Add/Remove programs?

I have never had or heard of the samples not installing.

-Cam

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?sql

Installing Data Mining Web Controls

Hello,

I have SQL 2005 and Visual Studio 2005 and I′m trying to install the Data Mining Web Controls. I downloaded the SQL Samples and I′m following the instructions of the "ReadMe_Data_Mining_Web_Controls.htm" file, but when I try to install de data mining web controls the setup.exe does′nt create the folder "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers " and the folder "C:\Inetpub\wwwroot\aspnet_client\microsoft_analysisservices_datamininghtmlviewers ".

Then, I don′t have the file "C:\Program Files\Microsoft.AnalysisServices.DataMiningHtmlViewers\Microsoft.AnalysisServices.DataMiningHTMLViewers.dll " for using the web controls.

Can somebody help me?

Dunia

The package coming with SQL Samples will install the sample source code in a Samples subfolder somewhere under %ProgramFiles%\Microsoft SQL Server\90. I am almost sure that the location is %ProgramFiles%\Microsoft SQL Server\90\Tools\Samples, but I may be wrong. A search for a folder called Samples under %ProgramFiles%\Microsoft SQL Server\90 will find the right location.

At that location, you will find the Data Mining web viewer sample, which is a Visual Studio 2005 solution. You have to open the solution in Visual Studio and build it. It contains:

- the web viewers sample (one assembly)

- a setup package that deploys the assembly together with the documentation in the location you mentioned (under %ProgramFiles%)

After building the solution, you should run the generated setup package, install the sample and then use it according to the documentation

Hope this helps

|||

Hi,

first of all I′d like to thank you for the answer.

I tryed to build the solution that you mentioned but I had the following error:

"Could not find file 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'"

Maybe the installer of the samples didn′t install this dll. I think that this is the problem. Do you know if I can download this dll from a site?

Thanks,

Dunia

|||

I never saw this before, but I can think of two possible reasons:

- In Visual Studio, you opened the setup project and not the whole solution which contains both the viewers project and the setup

or

- the solution was opened, you are trying to build the Release version and it incorrectly points to the debug version of the dll.

I would suggest:

- make sure that the full solution is opened, not only the setup project. Based on the error, I think it should be a file with the ".sln" extension in the "C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls" folder

- if that is not the problem, try to open in Visual Studio the .csproj project in 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls'. If this works, then you should retry to build the first project (the setup)

If none of these works, please let us know and I will post a zip containing the full solution for the sample

|||

Hello,

I have already tryed to build the .sln and .csproj, but I have the same error message, that there is no 'C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\DataMining\Data Mining Web Controls\WebControls\obj\Debug\Microsoft.AnalysisServices.DataMiningHtmlViewers.dll'.

I′d really appreciate if you could post me this file.....

Thanks,

Dunia


|||

My e-mail is dunia@.execplan.com.br

|||

Hello

Sorry for the late answer. I have sent you the sample code. Please let us know if you run into any more issues

bogdan

|||

I have the same problem with installing data mining web controls.

Can you please send me the zip that contains the solution ?

Thanks a lot

My email is georges_0@.hotmail.com

|||Hi Guys,
Can i have a copy of the file, Microsoft.AnalysisServices.DataMiningHtmlViewers.dll too. My email is bala.singam@.hotmail.com .

I also downloaded " DataMiningViewerClient " what's the different with the Data Mining Web Controls?|||I am having the same issue. I have made certain that all prerequisites have been installed and configured properly. How do I get a copy of this that has the missing dll?|||Dear friends.

The requested files are available at :
http://www.codeplex.com/MSFTASProdSamples/SourceControl/ListDownloadableCommits.aspx

Monday, March 19, 2012

installation.

GOOD MORNING,
I HAVE INSTALLED THE MSSQL RPT SVC ON A SQL SERVER
BUT HOW CAN I DESIGN A REPORT?
I DON'T HAVE VISUAL STUDIO .NET ON THE SERVER ,IS A PROBLEM?Good morning,
Congratulations for being able to set up RS.
The short question with version 1.0 you have to have Visual Studio.NET (on
you dev machine) for report authoring unless you want to generate the report
programatically or use third party tools. Looking ahead, SQL Server 2005
will give come with a stand alone designer and you won't need VS.NET.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Killer" <roninkaiser@.tiscali.it> wrote in message
news:SxpOc.20707$1V3.480258@.twister2.libero.it...
> GOOD MORNING,
> I HAVE INSTALLED THE MSSQL RPT SVC ON A SQL SERVER
> BUT HOW CAN I DESIGN A REPORT?
> I DON'T HAVE VISUAL STUDIO .NET ON THE SERVER ,IS A PROBLEM?
>|||On a side note, you only need the basic IDE with Visual Basic, which you can
get in VB.NET for under $100.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:%23hI2LSjdEHA.3704@.TK2MSFTNGP09.phx.gbl...
> Good morning,
> Congratulations for being able to set up RS.
> The short question with version 1.0 you have to have Visual Studio.NET (on
> you dev machine) for report authoring unless you want to generate the
report
> programatically or use third party tools. Looking ahead, SQL Server 2005
> will give come with a stand alone designer and you won't need VS.NET.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.prologika.com
>
> "Killer" <roninkaiser@.tiscali.it> wrote in message
> news:SxpOc.20707$1V3.480258@.twister2.libero.it...
> > GOOD MORNING,
> > I HAVE INSTALLED THE MSSQL RPT SVC ON A SQL SERVER
> > BUT HOW CAN I DESIGN A REPORT?
> >
> > I DON'T HAVE VISUAL STUDIO .NET ON THE SERVER ,IS A PROBLEM?
> >
> >
>

Installation Question

When I installed SQL Server 2005 from the downloaded disk, I seem to have
also installed visual studio. Firstly, is this an option that I checked at
the time (sorry but it was a while ago). The reason I ask is that the VS
2005 seems incomplete and only gives me access to AS, RS and IS packages.
However I want to use c#. So, can I still install the other components of VS
2005 or have I got the installation order incorrect?
TIA,
JB
What you have is the stripped down version of Visual Studio called the
Business Intelligence Management Studio. If you install Visual Studio 2005,
it will give you a complete install with all components active, including
the BI ones already installed. You have not messed anything up. The two
programs (SQL 2005 and VS 2005) were designed to complement each other.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"JB" <JB@.Acme.Com> wrote in message
news:exAJzbb%23FHA.916@.TK2MSFTNGP10.phx.gbl...
> When I installed SQL Server 2005 from the downloaded disk, I seem to have
> also installed visual studio. Firstly, is this an option that I checked at
> the time (sorry but it was a while ago). The reason I ask is that the VS
> 2005 seems incomplete and only gives me access to AS, RS and IS packages.
> However I want to use c#. So, can I still install the other components of
> VS 2005 or have I got the installation order incorrect?
> TIA,
> JB
>

Installation Question

When I installed SQL Server 2005 from the downloaded disk, I seem to have
also installed visual studio. Firstly, is this an option that I checked at
the time (sorry but it was a while ago). The reason I ask is that the VS
2005 seems incomplete and only gives me access to AS, RS and IS packages.
However I want to use c#. So, can I still install the other components of VS
2005 or have I got the installation order incorrect?
TIA,
JBWhat you have is the stripped down version of Visual Studio called the
Business Intelligence Management Studio. If you install Visual Studio 2005,
it will give you a complete install with all components active, including
the BI ones already installed. You have not messed anything up. The two
programs (SQL 2005 and VS 2005) were designed to complement each other.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"JB" <JB@.Acme.Com> wrote in message
news:exAJzbb%23FHA.916@.TK2MSFTNGP10.phx.gbl...
> When I installed SQL Server 2005 from the downloaded disk, I seem to have
> also installed visual studio. Firstly, is this an option that I checked at
> the time (sorry but it was a while ago). The reason I ask is that the VS
> 2005 seems incomplete and only gives me access to AS, RS and IS packages.
> However I want to use c#. So, can I still install the other components of
> VS 2005 or have I got the installation order incorrect?
> TIA,
> JB
>