SQL Express Edition

  • Thread starter Thread starter CypherDrive
  • Start date Start date
C

CypherDrive

We are currently tied between two options. One is to use Microsoft Access
2003 or Use MS SQL Express Edition (Bundled with Visual Studio.Net 2005). I
read a documentation Saying that in The Express Edition you can't make a
parallel Query etc... Our company is just a small business catering to a
maximum of 20 Concurrent Connections on a Database. Is it ok if we use SQL
Express Edition? What are the Pros and Cons? We are finding it hard to
develop Application using MS Access because of Limited Resources and one
thing more we are all new to this technology because we are using Foxpro for
DOS 2.6 and Visual Foxpro 7.0. MS SQL 2005 is very expensive and our company
can't afford it now. Will you please give me some advice.

Do you have sample source codes that implements MS Access VB.NEt 2005 with
Parent and Child Tables using DataGridView and having Default Buttons such
as Add, Edit, Delete, Find, Save where everything was done programmatically
including connection strings, Data Adapter etc...

This will really fastrack our Development Process. We downloaded a few but
some are not working when we run it our Visual Studio.Net 2005.

It is really hard on part to develop since our company is using only Dial Up
internet with 56 KBPS Connection.

Thanks in advance for your kind support.
 
All of my Hitchhiker Guides from the 4th to the 7th Editions discuss using
SQL Server instead of Access. While Access/JET has some appeal, I don't
recommend it for production work. Yes, many people use it to create
commercial applications, but due to it limitations and a bevy of other
issues, I can't recommend it to my clients, students or staff. I suggest
getting the 7th Edition as it will walk you through the issues and show you
other alternatives.

hth

CypherDrive said:
We are currently tied between two options. One is to use Microsoft Access
2003 or Use MS SQL Express Edition (Bundled with Visual Studio.Net 2005).
I read a documentation Saying that in The Express Edition you can't make a
parallel Query etc... Our company is just a small business catering to a
maximum of 20 Concurrent Connections on a Database. Is it ok if we use SQL
Express Edition? What are the Pros and Cons? We are finding it hard to
develop Application using MS Access because of Limited Resources and one
thing more we are all new to this technology because we are using Foxpro
for DOS 2.6 and Visual Foxpro 7.0. MS SQL 2005 is very expensive and our
company can't afford it now. Will you please give me some advice.

Do you have sample source codes that implements MS Access VB.NEt 2005 with
Parent and Child Tables using DataGridView and having Default Buttons such
as Add, Edit, Delete, Find, Save where everything was done
programmatically including connection strings, Data Adapter etc...

This will really fastrack our Development Process. We downloaded a few but
some are not working when we run it our Visual Studio.Net 2005.

It is really hard on part to develop since our company is using only Dial
Up internet with 56 KBPS Connection.

Thanks in advance for your kind support.
Click to expand...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Hi Cypher,
Regarding your questions, please see my answers below:
Q: "I read a documentation Saying that in The Express Edition you can't
make a parallel Query etc"
A: Yes, that is true, however it does not related to concurrent
connections. Parallel queries requires more than one processors. If there
is only one CPU on your server, no matter which SQL Server 2005 Edition, it
cannot support parallel query. The problem is that SQL Server 2005 Express
can only support 1 CPU. That is why it does not support parallel query by
the CPU limitation.

Q: Our company is just a small business catering to a maximum of 20
Concurrent Connections on a Database. Is it ok if we use SQL Express
Edition? What are the Pros and Cons?
A: This is OK. By default SQL Server 2005 does not have connection
limitations. Generally SQL Server 2005 Express has better query performance
than Access, however when you decided to use SQL Server 2005 Express
Edition, you should know that it has the following resource limitations: 1
CPU, 1 GB RAM, and total 4 GB database size. You need to evaluate your
requirements and optimization plan to see if you can accept the limitations.

Q: Do you have sample source codes that implements MS Access VB.NEt 2005
with Parent and Child Tables using DataGridView and having Default Buttons
such as Add, Edit, Delete, Find, Save where everything was done
programmatically including connection strings, Data Adapter etc...
A: This question is generic and related to many technologies such as
ADO.NET, VB.NET and Windows Form/ASP.NET. I did not find a complete code
sample from internet. Anyway I would like to recommend the following
articles for your reference so that you can change the code according to
your requirement:
Insert, Update, Delete & Search Values in MS Access 2003 with VB.NET 2005
http://www.codeproject.com/KB/vb/InsertUpdateDeleteSearch.aspx
Using ADO.Net DataRelations
http://home.hot.rr.com/graye/Articles/DataRelations.htm
Display parent and child records in two DataGrid controls in VB .NET
http://www.vb-helper.com/howto_net_datagrid_master_child.html
Add, Edit, And Delete In DataGridView
http://www.visualbuilder.com/showCode.php?id=81373&scd_id=2978

If your question is dedicated to DataGridView, I would recommend that you
have a new post at windowsforms community if the datagridview is a windows
form control or aspnet community if the datagridview is a ASP.NET web
control.

Please feel free to let me know if you have any other questions or
concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 
I would also recommend going and using the SQL Express on your first try.

I tried originally to learn .net with access and it was soo much harder
googling and finding answers to questions - and also to know what
'questions' I should be asking.

Switching to SQL Express - also allowed me to purchase some books that have
walkthru's and explain bits step by step.
Its pretty hard to find some old Access books.

I am glad I switched -and for me - by taking a couple steps back and
re-learning sql express and going thru some very very beginner books - my
questions even on this board dropped a tonne ( im sure everyone here must be
happy about that :-) )

But once I gone thru the basic examples some books I am able to create very
basic screens.
But its defenitly easier than the headache I was going thru with Access.

-Just a suggestion from a newbie.

FYI: The bok that William Vaughn suggest is defenitly a good read. It was
out of my leauge to read it at the 'point' when I did...but it defentily
gets you ready to ask some very important quesitions on how you will do some
programming prior to even writing a bit of code.

Miro
 
I would also like to add that once you design an application around SQL
Server Express or better, the problem of expanding scalability past the
generous limitations of SS Express is simply a matter of installing the
Workgroup or better version of SQL Server. This cannot be said for
Access/JET applications. Once you hit the wall on your tricycle, you're
done. No amount of tweaking will help security, scalability or
performance--you're looking at a general re-design of the application.
Anyone who tells you that an Access/JET application can be easily
transformed to SQL Server (or any serious DBMS) is confused at best.

"Charles Wang [MSFT]" said:
Hi Cypher,
Regarding your questions, please see my answers below:
Q: "I read a documentation Saying that in The Express Edition you can't
make a parallel Query etc"
A: Yes, that is true, however it does not related to concurrent
connections. Parallel queries requires more than one processors. If there
is only one CPU on your server, no matter which SQL Server 2005 Edition,
it
cannot support parallel query. The problem is that SQL Server 2005 Express
can only support 1 CPU. That is why it does not support parallel query by
the CPU limitation.

Q: Our company is just a small business catering to a maximum of 20
Concurrent Connections on a Database. Is it ok if we use SQL Express
Edition? What are the Pros and Cons?
A: This is OK. By default SQL Server 2005 does not have connection
limitations. Generally SQL Server 2005 Express has better query
performance
than Access, however when you decided to use SQL Server 2005 Express
Edition, you should know that it has the following resource limitations: 1
CPU, 1 GB RAM, and total 4 GB database size. You need to evaluate your
requirements and optimization plan to see if you can accept the
limitations.

Q: Do you have sample source codes that implements MS Access VB.NEt 2005
with Parent and Child Tables using DataGridView and having Default Buttons
such as Add, Edit, Delete, Find, Save where everything was done
programmatically including connection strings, Data Adapter etc...
A: This question is generic and related to many technologies such as
ADO.NET, VB.NET and Windows Form/ASP.NET. I did not find a complete code
sample from internet. Anyway I would like to recommend the following
articles for your reference so that you can change the code according to
your requirement:
Insert, Update, Delete & Search Values in MS Access 2003 with VB.NET 2005
http://www.codeproject.com/KB/vb/InsertUpdateDeleteSearch.aspx
Using ADO.Net DataRelations
http://home.hot.rr.com/graye/Articles/DataRelations.htm
Display parent and child records in two DataGrid controls in VB .NET
http://www.vb-helper.com/howto_net_datagrid_master_child.html
Add, Edit, And Delete In DataGridView
http://www.visualbuilder.com/showCode.php?id=81373&scd_id=2978

If your question is dedicated to DataGridView, I would recommend that you
have a new post at windowsforms community if the datagridview is a windows
form control or aspnet community if the datagridview is a ASP.NET web
control.

Please feel free to let me know if you have any other questions or
concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
=========================================================
Click to expand...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Thank you so much for the Updates.

I really appreciated it.

Regards,

Alvin


William Vaughn (MVP) said:
I would also like to add that once you design an application around SQL
Server Express or better, the problem of expanding scalability past the
generous limitations of SS Express is simply a matter of installing the
Workgroup or better version of SQL Server. This cannot be said for
Access/JET applications. Once you hit the wall on your tricycle, you're
done. No amount of tweaking will help security, scalability or
performance--you're looking at a general re-design of the application.
Anyone who tells you that an Access/JET application can be easily
transformed to SQL Server (or any serious DBMS) is confused at best.

"Charles Wang [MSFT]" said:
Hi Cypher,
Regarding your questions, please see my answers below:
Q: "I read a documentation Saying that in The Express Edition you can't
make a parallel Query etc"
A: Yes, that is true, however it does not related to concurrent
connections. Parallel queries requires more than one processors. If there
is only one CPU on your server, no matter which SQL Server 2005 Edition,
it
cannot support parallel query. The problem is that SQL Server 2005
Express
can only support 1 CPU. That is why it does not support parallel query by
the CPU limitation.

Q: Our company is just a small business catering to a maximum of 20
Concurrent Connections on a Database. Is it ok if we use SQL Express
Edition? What are the Pros and Cons?
A: This is OK. By default SQL Server 2005 does not have connection
limitations. Generally SQL Server 2005 Express has better query
performance
than Access, however when you decided to use SQL Server 2005 Express
Edition, you should know that it has the following resource limitations:
1
CPU, 1 GB RAM, and total 4 GB database size. You need to evaluate your
requirements and optimization plan to see if you can accept the
limitations.

Q: Do you have sample source codes that implements MS Access VB.NEt 2005
with Parent and Child Tables using DataGridView and having Default
Buttons
such as Add, Edit, Delete, Find, Save where everything was done
programmatically including connection strings, Data Adapter etc...
A: This question is generic and related to many technologies such as
ADO.NET, VB.NET and Windows Form/ASP.NET. I did not find a complete code
sample from internet. Anyway I would like to recommend the following
articles for your reference so that you can change the code according to
your requirement:
Insert, Update, Delete & Search Values in MS Access 2003 with VB.NET 2005
http://www.codeproject.com/KB/vb/InsertUpdateDeleteSearch.aspx
Using ADO.Net DataRelations
http://home.hot.rr.com/graye/Articles/DataRelations.htm
Display parent and child records in two DataGrid controls in VB .NET
http://www.vb-helper.com/howto_net_datagrid_master_child.html
Add, Edit, And Delete In DataGridView
http://www.visualbuilder.com/showCode.php?id=81373&scd_id=2978

If your question is dedicated to DataGridView, I would recommend that you
have a new post at windowsforms community if the datagridview is a
windows
form control or aspnet community if the datagridview is a ASP.NET web
control.

Please feel free to let me know if you have any other questions or
concerns. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.
=========================================================
Click to expand...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
Click to expand...
 
Zhi-xin Ye,

Thanks so Much. Appreciate that.

I'm currenly creating an SQL Express Database using the Microsoft SQL Server
Management Studio Express.

I created a new database.

I Entered the Database Name

I click Ok

The Message "Create Failed for Database Logistics"

Permission Denied in Database Master

MS SQL Server Error 262
 
Zhi-xin Ye,

Thanks so Much. Appreciate that.

I'm currenly creating an SQL Express Database using the Microsoft SQL Server
Management Studio Express.

I created a new database.

I Entered the Database Name

I click Ok

The Message "Create Failed for Database Logistics"

Permission Denied in Database Master

MS SQL Server Error 262
 
Zhi-xin Ye,

Thanks so Much. Appreciate that.

I'm currenly creating an SQL Express Database using the Microsoft SQL Server
Management Studio Express.

I created a new database.

I Entered the Database Name

I click Ok

The Message "Create Failed for Database Logistics"

Permission Denied in Database Master

MS SQL Server Error 262
 
Hi CypherDrive,
Did you post the response to another thread? There is no Zhi-xin in this thread. :-)

Anyway let me answer your new issue. From the error message, it indicated that it was a permission issue, so I think that you did not log on your SQL Server with an administrator account.

I recommend that you first log on your SQL Server with a local Windows administrator account or a sysadmin SQL account like sa (if you enable it in your SQL Server 2005 Express instance), then
you can create a database with those accounts. If you are using a normal SQL account, please first use an administrator account to grant CREATE DATABASE permission. For example:
USE master
Go
GRANT CREATE DATABASE TO <user name>
GO

You may also refer to this article for more information:
GRANT Database Permissions (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms178569.aspx

If you have any other questions or concerns, please feel free to let me know. Have a nice day!

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: (e-mail address removed).
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
 
Back
Top