Do I need to install SQLXML?

I am trying some excerxises in a self-paced training kit.I am supposed to communicate with SQL Server 2005 from Visual Studio. In Visual Studio I am supposed to add references to, and import a library called:

Microsoft.data.sqlxml.

The problem is that I don't find it on my system. Do I have to install new components?

I use :

WinXP,
SQL Server 2005 Express,
Visual Studio

Regards

Fredrik

Quote:

Originally Posted by Fredrik Cerha

I am trying some excerxises in a self-paced training kit.I am supposed to communicate with SQL Server 2005 from Visual Studio. In Visual Studio I am supposed to add references to, and import a library called:

Microsoft.data.sqlxml.

The problem is that I don't find it on my system. Do I have to install new components?

I use :

WinXP,
SQL Server 2005 Express,
Visual Studio

Regards

Fredrik

Yes, you will need to download SQLXML. SQLXML enables XML support for your SQL Server Database. Heres the link to download it from Microsoft: (it's free, too!)

SQLXML
Hope that helps,

-Cody-

Do I have to install SQL Express?

I'm using the login/roles from Visual Studio 2005 in a website.

Is MS SQL Express mandatory? I already have MS SQL 2000 on the box. Is there any way to use that instead?

And if so, will I need to install MS SQL on the box I'm building the webiste on?

Thanks,

oilcan

You dont't have to have MS SQL 2005 express on your developer machine.

There is a build-in database schema behind the memebership function in ASP.NET 2.0. By default, if you have MS SQL 2005 express installed, you will get a database named as ASPNETDB.MDF installed under App_data folder in your application when you start using membership.

It would be easy to play with samples and test simple things. However, you need to know how to move this database to another database if you want to host your application somewhere. For example, SQL 2005 or SQL 2000.

You can mannuly install this database by using a tool in this location(most likely): C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe

You can pick where you want to install this database from this tool's interface.

After you install this database, you need change your connection string to point to your new database which includes all tables from ASPNETDB.MDF

You may need to read through some articles from searching this topic about membership.

This is just a start and you will get there. If you have problems, you will easily get answers from here.

Enjoy the journey.

|||Any idea where I might find some of those articles you mentioned? I don't feel real comfortable just experimenting, it is a live web server.|||

Hello there:

This article talks about how to merge this ASPNETDB.MDF to your database.

http://aspnet.4guysfromrolla.com/articles/040506-1.aspx

Please follow this article, you will bepretty close. I think you better to test on your developer machine before you move on.

Also I came across this one from DisccountASP forum to show users how to move the starter kits to their server. Just for you as a reference.

http://community.discountasp.net/default.aspx?f=25&m=8785

Let me know if I can help more.

Limno

Do I HAVE to have IIS installed to use SQL Server Express 2005? and do I have to install SQLE2K5

Hi,

I'm an absolute beginner trying to learn SQL and Visual Basic/Visual Web developer.

I've downloaded SQL Express 2005 and want to install it on my laptop (Dell XPS, 2gb Ram) so that I can start doing the tutorials (for SQL and VB/VWS). I dont want any connection to the internet - i only want to have it on my local pc.

I'm confused as I 'm sure I read that I dont need to have the IIS service running, and that it wont require a server...however, I keep reading that IIS, and a server is a MUST, and for installing SQLE2005.

I'm so confused, and frustrated that I dare'nt install SQLE2005...

...Can anyone put me out of my misery?

All advice greatly appreciated.

SQLEB

Hi,

If you have downloaded SQL Express edition with Advance Services then only you require to have IIS installed on your system Refer http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005Advanced.htm

and if you have installed SQL Express w/o Advance Services you don't require to have IIS Refer http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005.htm

HTH

Hemantgiri S. Goswami

|||No, IIS is NOT required for the use and operation of SQL Server.sql

Do I Get the GUI with SQL Server 2005 Developer Edition

Hi,

Do I Get the GUI (Query Analyser and Enterprice Manager) with SQL Server 2005 Developer edition (which is available as free with Visual Studio 2005). I will be thankful if u give information.

SQL Server Developer edition have all the features of SQL Server Enterprise edition... But the enterprise manager equivalent in SQL Server 2005 is Sql Server Management Stuiod...

Refer these link for an overview

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

http://www.microsoft.com/sql/editions/developer/default.mspx

Madhu

|||

SSMS is included with the installation media, however, it is not installed with the default installation.

You will need to install the 'Client Tools' from the installation media in order to obtain Management Studio.

|||

K. Ravinder Reddy wrote:

Do I Get the GUI (Query Analyser and Enterprice Manager) with SQL Server 2005 Developer edition (which is available as free with Visual Studio 2005). I will be thankful if u give information.

Are you sure you have the Developer Edition? I know that Visual Studio 2005 comes with SQL Server Express Edition (which is different than Developer Edition). The tool you are looking for is called SQL Server Management Studio. It combines and extends most of the functionality of Query Analyzer and Enterprise Manager (SQL Server 2000 tools).

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

sql

DNS problem with reports (server URL)

I'm developing a SSRS site using SQL Server 2000 and Visual Studio 2003.
The target device is a Nokia 770 Internet tablet over a wireless network
using VPN for authentication (corporate requirement).
The 770 currently has a problem resolving server names to a fully-qualified
URL. It's been identified as a DNS-oriented bug that may take time to be
fixed. In order to enable the 770 tablet to navigate to my site, instead of
using http://myserver/Reports I have to instruct users to enter
http://myserver.country.company.com/Reports. This in and of itself is not a
problem. The trouble starts when the user clicks a report or chart; the url
generated contains a reference to http://myserver/Reportserver.
Unfortunately the tablet can't resolve this.
What I am looking for is a way to override whatever setting is limiting the
Reportserver URL and replace it with a fully qualified URL.
Anyone have any ideas? I've looked into it some but haven't figured out
what I can do.
Thanks,
Randall Arnold
NokiaRandall,
If you're able, I think the simplest solution would be to create a little
one page aspx program in which you can display your reports. Then you can
pass the full domain name to the reports server as part of the program.
Tim
Pharos Innovations
"Randall Arnold" wrote:
> I'm developing a SSRS site using SQL Server 2000 and Visual Studio 2003.
> The target device is a Nokia 770 Internet tablet over a wireless network
> using VPN for authentication (corporate requirement).
> The 770 currently has a problem resolving server names to a fully-qualified
> URL. It's been identified as a DNS-oriented bug that may take time to be
> fixed. In order to enable the 770 tablet to navigate to my site, instead of
> using http://myserver/Reports I have to instruct users to enter
> http://myserver.country.company.com/Reports. This in and of itself is not a
> problem. The trouble starts when the user clicks a report or chart; the url
> generated contains a reference to http://myserver/Reportserver.
> Unfortunately the tablet can't resolve this.
> What I am looking for is a way to override whatever setting is limiting the
> Reportserver URL and replace it with a fully qualified URL.
> Anyone have any ideas? I've looked into it some but haven't figured out
> what I can do.
> Thanks,
> Randall Arnold
> Nokia
>
>sql

DMX vs Visual Studio

Hi

Are there any (important?) advantages of using data mining through DMX instead of Visual Studio 2005 on the SQL server 2005?

/Dennis

DMX is the only solution for querying the mining models, and BI Dev Studio also uses DMX in the prediction query builder.

In general, as far as mining object manipulation is concerned, DMX and the XMLA-based Analysis Services Scripting Language (aka DDL or ASSL), the script used by BI Dev Studio, have similar features.

There are a few differences, however, mostly deriving from the fact that DMX is designed as an extension for SQL, for application developers and, therefore, it is more concise (so that it can be embedded or generated by applications).

Some DDL features not supported by DMX:

full control over the metadata of mining objects. Properties such as Description, bindings, name bindings are only supported in DDL and not in DMX