Using SQL server with VS.NET Professional?  
Author Message
Lu,Pan\(Eric





PostPosted: Thu Mar 04 04:56:32 CST 2004 Top

SQL Server >> Using SQL server with VS.NET Professional?

Hi

I'm having problems creating my database in VB.NET. I've done this recently on my PocketPC using SqlServerCE, and it worked swell! (Although slow.) But when I try to create a database on my desktop in similar fashion I get the error message: "SQL Server does not exist or access denied" when trying to open a connection

I have an MSDN Professional subscription (which seems not to include SQL Server). Hence the error message i presume... or am I wrong

How do I go about programmatically creating my database then? I thought I had to use ADO and started searching info on that, and stumbled upon a code download from Microsoft on how to create databases using ADO. But as far as I can see from the code, it uses SQL server. And I canâ??t run the code. It claims that I only need VS.NET Professional, but I canâ??t get it working. What do I need to install

Hereâ??s the download
http://www.hide-link.com/ ;displaylang=e

Iâ??m left somewhat perplexed. Is SQL Server out of reach for me just having professional subscription or not

I also have a question on performance. My database will consist of about 100.000 up to 1 million rows. Is collecting a couple of thousands of those rows going to take ages (depending on if one uses ADO or SQL Server)? My attempt to build my system on a Pocket PC showed that the database would be really slow (minutes), and I took for granted that a real PC would speed things up greatly (seconds?)

It will be a single user application, so in some sense I guess SQL server is overkill. Right

In short
Is it possible to use SQL server to create databases with MSDN professional
Where can I find info on the performance of SQL server and ADO
Any suggested approach

Iâ??d be really glad for any help I can get on this
/Danie

SQL Server180  
 
 
Sebastian





PostPosted: Thu Mar 04 04:56:32 CST 2004 Top

SQL Server >> Using SQL server with VS.NET Professional?

Inline comments follow:

> I'm having problems creating my database in VB.NET. I've done this
> recently on my PocketPC using SqlServerCE, and it worked swell!
> (Although slow.) But when I try to create a database on my desktop in
> similar fashion I get the error message: "SQL Server does not exist
> or access denied" when trying to open a connection.
>
> I have an MSDN Professional subscription (which seems not to include
> SQL Server). Hence the error message i presume... or am I wrong?

Yes, SQL Server is not included in Professional subscription:

MSDN Subscriptions Level & Feature Overview
http://msdn.microsoft.com/subscriptions/levels/default.asp

but this will not prevent you from connecting to any SQL Server instance in
your environment.
You may buy yourself a SQL Server Developer Edition for development ($49) or
use MSDE - see my answers below:

> How do I go about programmatically creating my database then? I
> thought I had to use ADO and started searching info on that, and
> stumbled upon a code download from Microsoft on how to create
> databases using ADO. But as far as I can see from the code, it uses
> SQL server. And I can't run the code. It claims that I only need
> VS.NET Professional, but I can't get it working. What do I need to
> install?
>
> Here's the download:
>
http://www.microsoft.com/downloads/details.aspx?familyid=864c5c6f-a53b-4453-a2aa-7853d4cf16fe&displaylang=en

Could you please post the part of the code that is relevant to setting up
connection to your SQL Server and creating database? I don't have time to
download and install the code right now, sorry.

> I also have a question on performance. My database will consist of
> about 100.000 up to 1 million rows. Is collecting a couple of
> thousands of those rows going to take ages (depending on if one uses
> ADO or SQL Server)? My attempt to build my system on a Pocket PC
> showed that the database would be really slow (minutes), and I took
> for granted that a real PC would speed things up greatly (seconds?).

SQL Server is a _very_ fast multiuser RDBMS platform, I assume you are a SQL
Server beginner, so my advice is - learn as much as you can about designing
efficient relational databases and designing for performance. Look into
indexes, they are crucial to SQL Server performance!

> It will be a single user application, so in some sense I guess SQL
> server is overkill. Right?

See MSDE, it is a free, redistributable version of SQL Server that's ideal
for client applications requiring an embedded database, new developers
learning how to build data-driven applications, and websites serving up to
25 concurrent users. You may always upgrade later to SQL Server Standard or
Enterprise when the application grows.

http://www.microsoft.com/sql/msde/default.asp

> In short:
> Is it possible to use SQL server to create databases with MSDN
> professional?

Technically - yes
In terms of licensing - no, as long as you want to use SQL Server Developer,
Standard or Enterprise and do not have appropriate license. You may use MSDE
as a fully functional replacement for a SQL Server.

Learn about MSDE workload governor and 5 concurrent queries performance
limit
http://www.microsoft.com/sql/msde/techinfo/workloadgov.asp

> Where can I find info on the performance of SQL server and ADO?
> Any suggested approach?

See for beginning:

http://www.sql-server-performance.com/sql_server_performance_audit.asp
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
http://www.swynk.com/friends/vandenberg/perfmonitor.asp

sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.